Job Title: Power BI Developer Location: Denver, CO 80203 (Hybrid) Duration: 12 Months Contract (With a possible extension) Job Description and Requirement: The client is seeking a skilled Power BI Developer to assist with our BI Program.
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 Client Integration 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.
- 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.