Power BI Developer

SR POWER BI DEVELOPER

Application Developer IV

Denver, CO

12 months

Candidate must be local to Denver, CO (within 20 miles)

The Client 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.