Senior Power BI Architect for EPC Analytics

Position Overview Kiewit is seeking a Power BI Developer to architect, design, and deliver enterprise‑grade analytics solutions supporting complex EPC projects across the organization. This is a technical role that involves building strong relationships with project and discipline leads and deploying complex data strategies activities across Kiewit’s business functions. This role operates within the Digital Project Execution (DPE) team and will collaborate closely with data engineers, solution architects, project leadership, and technology teams to deliver production‑grade BI solutions that drive operational decisions on major construction programs. Responsibilities Power BI Development Develop interactive dashboards for project and field use Implement row‑level security (RLS), object‑level security (OLS), and governance standards Deploy and manage solutions within Power BI capacities Configure and optimize data gateways Manage workspaces, deployment pipelines, and versioning strategies Design and develop scalable Power BI datasets using modeling best practices Build optimized semantic models supporting enterprise‑scale reporting Implement incremental refresh, aggregation tables, composite models, and DirectQuery/Import hybrid architectures Engineer high‑performance DAX measures for complex business logic Troubleshoot and refactor poorly performing models Contribute to enterprise data standards and BI best practices Data Integration and Engineering Collaboration Work with data engineers to define optimized data contracts Analyze and troubleshoot end‑to‑end data pipelines Contribute to ELT design patterns across: Azure Data Lake (ADLS Gen2) Azure Databricks (Spark / PySpark / Spark SQL) Azure Data Factory SQL Server / Azure SQL Ensure datasets are structured for performance, scalability, and reusability Qualifications Primary Technology Stack Power BI Power BI Premium / Embedded Azure Databricks (PySpark, Spark SQL) Azure Data Lake Azure Data Factory SQL Server Snowflake Supporting Technology Stack Python Git (source control) CI/CD deployment pipelines Data modeling and warehousing frameworks Required Skills and Abilities Strong Power BI experience, including Power BI Premium or Embedded Expert level SQL, PL/SQL, and experienced Python skills with a track record of optimizing complex Power BI models for performance and scalability Proficient in advanced/comprehensive SQL, with expertise in optimization and performance tuning Familiarity with the EPC industry (engineering or construction) Experience troubleshooting and resolving issues across teams Ability to understand complex business rules and processes and build integration processes and database views to represent those rules Preferred experience with secondary tools such as Azure Databricks, Visual Studio, Azure Data Factory Excellent written and oral communication skills Understanding of ETL fundamentals and solutions Experience with Python/PySpark and Spark SQL Experience troubleshooting data issues and analyzing end‑to‑end data pipelines Strong data analytics and visualization experience with transformation and aggregation from multiple formats to uncover insights for project teams Familiar with source control and version control systems Experience creating technical documentation for functional requirements, scope documents, technical design, and business process modeling Industry Specific Experience 8+ years of experience in BI / data analytics Other Requirements Regular, reliable attendance Work productively and meet deadlines timely Communicate and interact effectively and professionally with supervisors, employees, and others individually or in a team environment Perform work safely, following oral and written instructions, including warning signs and equipment use Work during normal operating hours to organize and complete work within deadlines; overtime and weekends as required Field roles only: may work at various locations and conditions may vary Base Compensation: $136,000/yr - $142,000/yr (Actual compensation is subject to variation due to such factors as education, experience, skill set, and/or location) We offer our full‑time staff employees a comprehensive benefits package that’s among the best in our industry, including top‑tier medical, dental and vision plans covering eligible employees and dependents, voluntary wellness and employee assistance programs, life insurance, disability, retirement plans with matching, and generous paid time off. Equal Opportunity Employer, including disability and protected veteran status. #J-18808-Ljbffr