What are the responsibilities and job description for the Senior Power BI Developer position at IES Holdings?
Location: Sugar Land, TX – On-site, Full-Time
About IES Holdings, Inc.
IES Holdings, Inc. (NASDAQ: IESC) is a national provider of electrical, mechanical, and industrial infrastructure services with 130 locations and 9,000 employees. The Corporate IT team is expanding its Business Intelligence function to support stronger decision-making across a decentralized organization.
Position Summary
The Senior Power BI Developer leads the design, development, and delivery of business intelligence solutions that turn complex data into clear insights. This role focuses heavily on data modeling, DAX, performance tuning, and building executive-level dashboards from Microsoft Dynamics 365 and other data sources.
This person will act as a technical lead for BI initiatives, partnering with business leaders, finance, operations, and IT. The role blends hands-on development with senior-level guidance, solution design, and best-practice governance.
Key Responsibilities
Data Modeling & Integration
• Build and own complex data models and star schemas optimized for enterprise reporting.
• Extract, clean, and transform data from SQL Server, Azure resources, APIs, Excel, and Dynamics 365.
• Develop and maintain robust ETL pipelines using SQL, Power Query, and related tools.
• Set standards for data integrity, validation, and cross-system consistency.
Reporting & Visualization
• Design advanced Power BI dashboards for executive, financial, and operational reporting.
• Create DAX measures and calculations for complex business logic.
• Translate raw data into clear insights that support decision-making.
• Partner with stakeholders to define KPIs, metrics, and reporting requirements.
• Ensure usability, readability, and adoption of BI solutions.
Performance, Governance & Support
• Optimize large-scale datasets, refresh reliability, and report performance.
• Manage workspaces, dataflows, and app lifecycle in Power BI Service.
• Establish BI development standards and best practices.
• Troubleshoot SQL, DAX, gateway, and refresh issues.
• Offer guidance and light training to business users and junior BI staff.
Required Qualifications
• Bachelor’s degree in Computer Science, Information Systems, Data/Business Analytics, or similar.
• 5–7 years of hands-on experience with Power BI.
• Expert-level SQL skills, including query optimization and complex joins.
• Strong experience with dimensional modeling and relational architecture.
• Demonstrated experience using Microsoft Dynamics 365 data for reporting.
• Hands-on ETL experience (Power Query, SQL-based ETL, or similar).
• Strong ability to explain findings and insights to non-technical audiences.
Preferred Qualifications
• Experience with Azure Data Factory, Synapse, or other cloud BI components.
• Experience implementing role-level security, governance, or BI access frameworks.
• Familiarity with Agile/Scrum environments.
• Microsoft Certified: Power BI Data Analyst Associate or higher.
Soft Skills
• Strong analytical and critical thinking.
• Comfortable working with large, complex datasets.
• Clear communicator with strong follow-through.
• High attention to detail and accuracy.
• Able to handle multiple priorities in a fast environment.
