Job description

DAILY DUTIES / RESPONSIBILITIES:-• Data Modeling and Transformation: Collaborate with stakeholders to gather requirements and translate them into technical specifications. Build and maintain data models within Power BI using DAX (Data Analysis Expressions) and Power Query.• Report Development: Design, develop, and publish interactive dashboards and reports in Power BI. Ensure reports are user-friendly and meet business requirements.• Data Integration: Connect Power BI to various data sources, including databases, APIs, and flat files. Perform data cleansing and transformation to prepare data for analysis.• Performance Optimization: Monitor and optimize dashboard performance and responsiveness. Implement best practices for data visualization and reporting.• Collaboration and Communication: Work closely with business stakeholders, data analysts, and other stakeholders to understand reporting needs. Provide training and support to end-users and ITS on using Power BI.• Documentation: Maintain documentation of Power BI solutions, including data models, reports, and business logic. Create user guides and training materials for stakeholders.• DEVELOP TECHNICAL DOCUMENTATION FOLLOWING AGENCY POLICIES, CJIS SECURITY GUIDANCE, AND STATE SECURITY STANDARDS.• Troubleshooting and Support: Address any Power BI reports and dashboards issues. Provide ongoing support and maintenance for existing Power BI solutions.• Facilitate ongoing knowledge sharing sessions with IT Team• SUPPORTS AND ADHERES TO CHANGE MANAGEMENT PROCESS• AWARENESS OF SECURITY-BASED CHANGE PROCESSES, I.E., DOCUMENTATION, DEPLOYMENT STRATEGIES, AND CHANGE LOG REVIEWS.• IDENTIFIES RISKS AND COMMUNICATES RISKS TO THE CIO AND IT TEAMS. REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):-• 1. Power BI Expertise:• - Proficient in Power BI Desktop and Power BI Service for report creation and publishing. – Experience embedding Power BI in custom applications• 2. Data Modeling:-• - Strong understanding of data modeling concepts and experience in building complex data models.• 3. DAX Proficiency:-• - Ability to write advanced DAX queries for calculations and data manipulation.• 4. SQL Skills:-• - Proficient in SQL for querying and extracting data from relational databases.• 5. Data Visualization:-• - Strong skills in creating engaging and effective visualizations that communicate data insights clearly.• 6. Analytical Thinking:-• - Ability to analyze data requirements and translate them into actionable insights.• 7. Communication Skills:-• - Strong verbal and written communication skills for collaboration and• EXPERIENCED IN POWER APPS, POWER PLATFORM, AND DYNAMICS 365 APPS• SKILLED WITH SHAREPOINT, STREAM, AND TEAMS• CANDIDATE MUST BE ABLE TO DEMONSTRATE WORKING KNOWLEDGE• ABILITY TO COMMUNICATE DIRECTLY WITH THE IT TEAM, BUSINESS EMPLOYEES, AND VENDOR PARTNERS. PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):-• 1. EXPERIENCE WITH ETL TOOLS:• FAMILIARITY WITH ETL (EXTRACT, TRANSFORM, LOAD) TOOLS SUCH AS AZURE DATA FACTORY OR SSIS.•• 2. KNOWLEDGE OF AZURE SERVICES:• - UNDERSTANDING OF AZURE SERVICES RELATED TO DATA ANALYTICS AND REPORTING.• 3. BUSINESS INTELLIGENCE CONCEPTS:• - FAMILIARITY WITH BUSINESS INTELLIGENCE METHODOLOGIES AND BEST PRACTICES.• 4. EXPERIENCE WITH .NET AND C#• - UNDERSTANDING OF PROGRAMMING LANGUAGES LIKE DATA MANIPULATION AND ANALYSIS.EXPERIENCE WITH IBM SPSS GOOD TIME MANAGEMENT SKILLS TO MEET PROJECT AND ACTION ITEMS DEADLINES:-• EXCELLENT DECISION MAKING AND CRITICAL-THINKING SKILLS• EXCELLENT ORAL AND WRITTEN COMMUNICATION SKILLS TO COMMUNICATE EFFECTIVELY WITH OTHERS• ABILITY TO UNDERSTAND, DEVELOP, AND CREATE TECHNICAL DOCUMENTATION TO DEMONSTRATE WORKING KNOWLEDGE• GOOD ORGANIZATION SKILLS AND DETAIL ORIENTED• ABILITY TO LEARN AND SUPPORT NEW TECHNOLOGIES AND TRAIN OTHERS• GOOD INTERPERSONAL SKILLS• PROVEN ABILITY FOR SUPPORT TO END-USERS AND TECHNICAL SUPPORT TEAMS• PROACTIVE AND SELF-MOTIVATED• SELF-MANAGE ABILITIES REQUIRED EDUCATION:-BACHELOR'S DEGREE OR MASTER’S DEGREE COMPUTER SCIENCE, INFORMATION TECHNOLOGY, DATA SCIENCE, OR A RELATED FIELD.OR EQUIVALENT WORK EXPERIENCE. PREFERRED MICROSOFT AZURE ASSOCIATE OR EXPERT CERTIFICATIONS:-MICROSOFT CERTIFIED: DATA ANALYST ASSOCIATE- MICROSOFT CERTIFIED: AZURE DATA SCIENTIST ASSOCIATE- MICROSOFT CERTIFIED: AZURE DATA ENGINEER ASSOCIATE- POWER BI CERTIFICATION (FROM RECOGNIZED INSTITUTIONS)

Requirements