SUMMARY DUTIES AND RESPONSIBILITIES
A Power BI Developer/Analyst transforms raw data into actionable business insights by designing interactive dashboards, developing complex data models, and writing DAX queries. They connect to diverse data sources, ensuring data security and performance optimization. Key roles include creating reports, conducting data analysis, and collaborating with stakeholders.
KEY RESPONSIBILITIES
Report & Dashboard Creation: Develop, publish, and maintain interactive Power BI reports and dashboards
- Data Modeling & DAX: Create complex data models (relationships, schemas, etc.) and write advanced DAX formulas for calculated columns and measures
- Data Integration (ETL): Connect to various data sources (SQL Server, SharePoint, Azure, APIs, Excel) and transform data using Power Query (M language)
- Performance Optimization: Improve report performance, dashboard responsiveness, data refresh efficiency, and underlying query performance.
- Stakeholder Collaboration: Collaborate with business users and cross-functional teams to gather requirements, translate business needs into reporting solutions, and provide analytical insights.
- Data Security & Governance: Ensure compliance with data governance standards, including row-level security, access controls, and overall data integrity.
SKILLS AND QUALIFICATIONS
PRE-EMPLOYMENT:
Must be legally authorized to work in the United States.
- Must successfully complete required drug screening and physical examination.
- TWIC (Transportation Worker Identification Credential) required prior to offer acceptance; MSHA (Mine Safety and Health Administration) training to be completed upon hire
ON THE JOB SKILLS:
Power BI Desktop and Service: Advanced knowledge of Microsoft Power BI Desktop and Service, including workspaces, scheduled refresh, app distribution, and workspace administration.
- Power Query and M language: Proficiency in Power Query and M language for data cleaning, reshaping, and custom transformations
- SQL & Database Knowledge: Strong SQL skills for data extraction, joining, filtering, and aggregation across relational databases
- Data Analysis Skills: Experience in data warehousing concepts, ETL processes, and data modeling (star schemas)
- Data Visualization & User Experience: Ability to design clear, intuitive, and visually compelling reports and dashboards that prioritize user experience, usability, and ease of navigation, using features such as drill-throughs, bookmarks, KPIs, and conditional formatting.
- Design Thinking and Stor