Job Title: Power BI developer
Job Location: 601 East 18th Avenue Suite 250 Denver Colorado
Duration: 12 Months
This engagement is expected to exceed 12 months in duration.
Candidate must be within 50 miles
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 inperson meetings in one of the State offices.
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 columnlevel security within the Power BI semantic model.
- Needs to be able to establish reusable 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 drillthrough 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.