Power BI Lead

About the Role

Our Client is undergoing a significant digital transformation initiative to modernize its data infrastructure and reporting capabilities. This role is central to the VISION – CWIS FACS Conversion Initiative, which involves migrating critical program data from a GCP BigQuery environment into an enterprise SQL data warehouse. As the Lead Power BI Developer, you will be instrumental in redesigning and rebuilding legacy reports on the Power BI platform, ensuring that business operations, program leadership, and analytical initiatives are supported by accurate, modern, and accessible reporting solutions. You will serve as the technical anchor for a growing team of Power BI developers, establishing best practices, governance standards, and high-quality deliverables throughout this transition. This position offers a unique opportunity to drive enterprise-level reporting modernization within a dynamic and impactful our client technology environment.

Key Responsibilities

• Lead the development, redesign, and modernization of legacy reporting systems into new, scalable Power BI solutions.
• Provide technical leadership, mentoring, and guidance to a team of four or more Power BI developers to ensure consistent quality and adherence to best practices.
• Collaborate closely with business partners, data engineers, and ETL developers to ensure accurate and efficient data sourcing from BigQuery-based data marts.
• Design and develop visually effective, accessible, and standardized reports that align with agency reporting standards and accessibility requirements.
• Enforce established governance, security, and documentation standards for all Power BI assets to maintain data integrity and compliance.
• Perform rigorous testing and validation to ensure the accuracy, reliability, and consistency of all reporting products before deployment.
• Work with stakeholders to gather requirements, verify data elements, and support enterprise reporting needs across various program areas.
• Produce and maintain comprehensive technical documentation, report specifications, and support materials to facilitate knowledge transfer and ongoing maintenance.

Required Skills & Experience

• Minimum of 5 years of hands-on experience developing Power BI reports and dashboards in a production enterprise environment.
• Demonstrated expertise in ETL processes and Reporting/BI tools, with a strong understanding of data flow and transformation.
• Proven ability to serve as a Technical Lead, including experience in mentoring junior developers and managing team workflows.
• Strong proficiency in SQL for querying and manipulating data within enterprise data warehouses.
• Experience working with cloud-based data platforms, specifically Google Cloud Platform (GCP) and BigQuery, is highly preferred.
• Excellent communication skills to collaborate effectively with non-technical stakeholders and business partners.

Tools & Technologies

• Microsoft Power BI: Core tool for designing, developing, and deploying reports and dashboards.
• Google Cloud Platform (GCP) & BigQuery: Source environment for critical program data and data marts.
• SQL: Used for querying enterprise data warehouses and validating data accuracy.
• ETL Tools: Experience with tools used for extracting, transforming, and loading data into reporting environments.
• Version Control: Familiarity with Git or similar tools for managing Power BI project code and assets.

Work Schedule & Duration

• Contract Duration: From October 26, 2026, to June 30, 2027.
• Work Arrangement: Hybrid or Onsite, with specific onsite requirements at the Des Moines, IA location.
• Interview Type: Either Webcam or In-Person interview.

Interview Process

The interview process typically includes an initial screening with the recruitment team, followed by a technical interview with the client's project manager or technical lead. This may be conducted via webcam or in person, depending on the candidate's location and preference. The final stage may involve a panel interview to assess cultural fit and leadership capabilities.

Position Details

• Employment Type: Contract
• Duration: Approximately 12 months (with potential for extension)
• Work Authorization: Must be authorized to work in the United States