Power BI Developer

Job Overview
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 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):

• Power BI Expertise:
• Proficient in Power BI Desktop and Power BI Service for report creation and publishing. – Experience embedding PowerBI in custom applications
• Data Modeling:
• Strong understanding of data modeling concepts and experience in building complex data models.
• DAX Proficiency:
• Ability to write advanced DAX queries for calculations and data manipulation.
• SQL Skills:
• Proficient in SQL for querying and extracting data from relational databases.
• Data Visualization:
• Strong skills in creating engaging and effective visualizations that communicate data insights clearly.
• Analytical Thinking:
• Ability to analyze data requirements and translate them into actionable insights.
• 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.
• KNOWLEDGE OF AZURE SERVICES:
• UNDERSTANDING OF AZURE SERVICES RELATED TO DATA ANALYTICS AND REPORTING.
• BUSINESS INTELLIGENCE CONCEPTS:
• FAMILIARITY WITH BUSINESS INTELLIGENCE METHODOLOGIES AND BEST PRACTICES.
• 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)

Job Type: Full-time

Ability to Commute:

• West Columbia, SC 29169 (Required)

Ability to Relocate:

• West Columbia, SC 29169: Relocate before starting work (Required)

Work Location: In person