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)
Any Graduate