CL - Programmer - Consultant

Job Description: Max Bill Rate:

SCOPE OF THE PROJECT:
MICROSOFT POWERBI DEVELOPER TO SUPPORT DATA VISUALIZATION AND REPORTING NEEDS WITHIN THE AGENCY

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 userfriendly 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 endusers 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 SECURITYBASED 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 PowerBI 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):
. 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 CRITICALTHINKING 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 ENDUSERS AND TECHNICAL SUPPORT TEAMS
PROACTIVE AND SELFMOTIVATED
SELFMANAGE ABILITIES

REQUIRED EDUCATION:
BACHELORS 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)
Additional Sills: 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 PowerBI 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): . 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 SPSSGOOD TIME MANAGEMENT SKILLS TO MEET PROJECT AND ACTION ITEMS DEADLINES EXCELLENT DECISION MAKING AND CRITICALTHINKING 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 ENDUSERS AND TECHNICAL SUPPORT TEAMS PROACTIVE AND SELFMOTIVATED SELFMANAGE ABILITIESREQUIRED EDUCATION: BACHELORS 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)***These are preferred not required Skills: No items to display.