Power BI Developer

Position Summary 

The data analytics team’s objective is to provide an efficient, reliable, and seamless user experience across the organization’s systems and platforms that enables functional groups to make informed, data-driven decisions. The team collaborates with the Information Technology and Process Improvement teams to scope system and stakeholder requirements, propose solutions, and ensures the deliverables meet business needs. 

The Power BI Developer designs and develops comprehensive reporting solutions on the Power BI platform that draws on one or more of the organizations data resources. Reports include a variety of data intensive measurements, metrics, calculations, and visualizations, and cover functional areas such as safety, quality, construction operations, human resources, finance, and accounting. The Power BI Developer works closely with the Data Management Director, ETL Engineer, and area stakeholders to define reporting requirements, and then build, update, test, and deploy reports and dashboards. The Power Bi Developer actively updates and manages deployed reports as requirements and data resources change. 

Essential Duties and Responsibilities 

• Design and develop Power BI reports and dashboards. Perform data modeling, source required data, and support the development of data set ingestion, transformation, and data flow processes 
• Work within a cross-functional team to gather and document upstream and downstream data and reporting requirements 
• Perform reporting and process walkthroughs with stakeholders to understand reporting requirements. Develop supporting data models, functional and technical requirements, and translate those requirements into specifications that will be used to develop reports and dashboards 
• Design, publish and maintain Power BI data models with interrelated tables 
• Think creatively and out-of-the-box to develop engaging Power BI visualizations, reports, and dashboards that effectively and efficiently communicate information 
• Utilize analytical and problem-solving skills to reverse engineer reports, templates, and metrics. Utilize data analysis expressions (DAX) to rebuild the reports and dashboards in Power BI. 
• Extract and analyze data using Power Query, Excel, and other tools. Reconcile data sets to ensure completeness and accuracy of reports and dashboards 
• Provide ongoing maintenance support to ensure maximum availability and optimal performance of published reports and dashboards 
• Manage a portfolio of reporting projects in various stages. Continuously transition reports and dashboards developed on other, legacy platforms to Power BI 
• Implement configuration and change management controls to ensure report modifications are communicated, approved, and documented 
• Design and implement technology best practices and guidelines to ensure repeatable processes and results

Required Technical Experience and Skills 

• Significant development experience using Power BI Desktop, Report Server, and Analysis Modeling 
• Experience with advanced DAX functions and Power Query 
• Experience with building creative reports and dashboards with various visualization and KPIs 
• Knowledge of Power BI best practices 
• Excellent communication skills, both written and verbal, to identify requirements, provide status, and effectively discuss technical details with stakeholders and leadership throughout the organization 
• Excellent report debugging skills 
• Attention to detail

Bonus Points 

• Microsoft Azure technology stack experience 
• SQL server and queries 
• Knowledge of continuous integration, continuous delivery (CI/CD) and agile development methodologies 
• Experience in the construction and engineering industry 
• Experience presenting and training applications and reports