Power BI Developer

About the Role

This role supports Our Client's Office of Information Technology (OIT) Business Intelligence program by designing, building, and maintaining Power BI solutions that drive data‑driven decision making. The developer will work closely with business stakeholders, data analysts, and integration teams in a collaborative, fast‑paced environment. You will be responsible for translating business requirements into intuitive visualizations while ensuring data security and performance at scale. The position offers the opportunity to influence how the organization consumes data and to introduce modern AI‑enhanced analytics practices.

Key Responsibilities

• Gather and analyze business requirements to define report and dashboard specifications.
• Design, develop, and document conceptual, logical, and physical data models within Power BI.
• Create reusable semantic models, implement row‑level and column‑level security, and optimize data structures for performance.
• Develop interactive Power BI reports and dashboards incorporating slicers, drill‑through, streaming visuals, and ArcGIS map layers.
• Write and maintain complex DAX formulas, calculated columns, and measures to meet analytical needs.
• Connect Power BI to diverse data sources such as APIs, Google BigQuery, SQL Server, Excel, and GIS services, ensuring reliable data extraction and transformation.
• Collaborate with the OIT Integrations team to align data pipelines with organizational integration patterns.
• Publish reports to Power BI Service, manage access controls, schedule refreshes, and monitor performance using DAX Studio and built‑in tools.
• Leverage AI tools (e.g., Google AI) to automate repetitive tasks and enhance analytical workflows.
• Adhere to source control and version‑control standards, documenting changes and maintaining code repositories.

Required Skills & Experience

• Minimum 3‑5 years of hands‑on experience developing Power BI reports and data models.
• Strong proficiency in DAX for creating calculated columns, measures, and custom calculations.
• Intermediate to advanced Excel skills, including complex formulas, pivot tables, and data analysis.
• Experience designing and implementing row‑level and column‑level security within Power BI.
• Proven ability to gather requirements, translate business needs into technical specifications, and communicate findings to non‑technical stakeholders.
• Familiarity with data modeling best practices and tools such as Tabular Editor and its Best Practice Analyzer.
• Exposure to AI‑assisted analytics tools; experience with Google AI tools is a plus.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field.

Tools & Technologies

• Microsoft Power BI (Desktop, Service, Dataflows)
• DAX (Data Analysis Expressions)
• Tabular Editor & Best Practice Analyzer
• DAX Studio for performance tuning
• Microsoft Excel (advanced functions, pivot tables)
• SQL databases (SQL Server, MySQL, etc.) for data connectivity
• APIs, Google BigQuery, ArcGIS map and feature layers for source integration
• Version control systems (e.g., Git) for source management
• AI/ML tools such as Google AI platforms (optional)

Work Schedule & Duration

• Contract length: Approximately 8 months (Start: 10/26/2026 – End: 06/30/2027).
• On‑site work at the Denver office (1575 Sherman Street, Denver, CO 80203) with potential hybrid flexibility based on client policy.

Interview Process

The interview process typically includes an initial recruiter screening, followed by a technical interview focused on Power BI, DAX, and data modeling concepts. Successful candidates may then meet with a panel of business analysts and OIT managers to discuss past projects and problem‑solving approaches. The final step is often a brief culture fit conversation before an offer is extended.

Position Details

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