Application Developer IV

OIT is seeking a skilled Power BI Developer to assist with our BI Program. Ideally will have expertise in the following technical areas aspects: Requirements Gathering • Collaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as underlying data model. • Capable of identifying relevant data sources and attributes for use in model Data Modeling: • Designing and documenting efficient conceptual, logical, and physical data models to support business requirements. • Understands how to deliver row and column-level security within the Power BI semantic model. • Needs to be able to establish re-usable semantic data models within Power BI. • Familiarity with running tabular Editor Best Practice Analyzer for adhering to modeling and DAX best practices. • Creating relationships between tables and optimizing data structures. Data Source Connectivity Setup: • Connecting to various data sources (APIs, Big Query, ArcGIS map and feature layers, SQL databases, Excel files, etc.) including streaming datasets. • Ensuring seamless data extraction and transformation. • Collaborating with the members of OIT Integrations team to ascertain available integration patterns. DAX Formulas: • Proficiency in writing DAX (Data Analysis Expressions) formulas. • Calculated columns, measures, and custom calculations. Report Creation: • Designing and developing interactive and visually appealing reports and dashboards. • Incorporating slicers, visuals, and drill-through functionality, including streaming and ArcGIS visuals. • Needs to be cognizant of and adhere to accessibility standards (section 508). • Capable of optimizing Power BI reports or making suggestions to underlying data model for performance, including the use of DAX Studio and built in Power BI performance tools. • It is expected that the developer will follow organizational patterns for source and version control for Power BI files and be able to utilize Azure DevOps as appropriate within that process. • This engagement is expected to exceed 12 months in duration. • While OIT supports telecommuting / remote work, it is expected that the contractor performs the work within the State of Colorado and preferably in the Denver Metropolitan Area; there will be occasions where the contractor will have to collaborate with their colleagues and attend in-person meetings in one of the State offices.

Created: 2026-03-04