Senior Data Warehouse & Power BI Specialist

Job Description

Job Description

Job Description

Senior Data Warehouse & Power BI Specialist

Position Overview

• Role Title: Senior Software Developer (Business Intelligence Specialist)

• INC Rate: $100/hour

• Assignment Dates: Start Date: 2026-01-05; End Date: 2026-11-13

• Scope: Help build a new data warehouse/lakehouse on Microsoft Azure and deliver the reporting MVP (minimum viable product).

Key Assignment Deliverables

As a member of the data team, the Senior Software Developer will be responsible for defining and delivering the data and reporting infrastructure.

• Data Warehouse Design: Analyze business requirements to design an efficient data warehouse/lakehouse/golden layer on Microsoft Azure.

• Data Integration and ETL: Develop and automate ETL processes to load and integrate data from Dynamics 365 CE and F&O and other diverse sources into the new data warehouse/lakehouse.

• Data Modeling: Create logical and physical data models that align with the project’s analytical and reporting needs.

• Reporting and Visualization: Develop reports, dashboards, and visualizations as per the reporting MVP using Power BI, ensuring the quality, accuracy, and integrity of the reports.

• Performance Optimization: Fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.

• Data Security and Governance: Implement appropriate security controls and governance practices to protect sensitive data.

Mandatory Skills & Experience

Candidates must demonstrate proficiency in the following key areas:

• Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features such as DAX and Power Query.

• Dynamics 365 Reporting: Demonstrated experience with data analytics and reporting from Dynamics 365 CE and/or F&O.

• Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance.

• SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query issues, including knowledge of indexing and execution plans.

Desired Skills & Knowledge (Nice to Have)

• Cloud Certifications: Azure cloud certifications (e.g., Azure fundamentals, Azure Power BI Data Analyst Associate).

• Power Platform: Experience with the PowerApps platform, Power Automate, and knowledge of the Dynamics CE and F&O application side.

• Data Ecosystem Knowledge: Knowledge of technologies commonly used with Dynamics 365, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.

• DevOps/Tools: Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps). Experience with SQL Server Management Studio, Azure data management tools, SSIS, and SSRS.

Senior Software Developer Resume Evaluation Focus Areas

This section outlines the five key areas and their weighted contribution to the overall candidate assessment. Candidates should ensure their resume clearly demonstrates experience in each of these domains.

1. Power BI & Visualization (25 Points)

• Focus: Expert-level proficiency in Power BI.

• Demonstrate Experience in: Creating interactive reports and dashboards, mastery of DAX and Power Query, and configuring data gateways.

2. Data Warehouse & Modeling (25 Points)

• Focus: Practical experience in modern Data Warehouse/Lakehouse environments.

• Demonstrate Experience in: Designing and supporting a Data Warehouse/Lakehouse (including Bronze/Silver/Golden layers), applying dimensional modeling concepts (e.g., Star/Snowflake schemas), and working with Azure Synapse Workspaces (pipelines, data flows).

3. Dynamics 365 Data (20 Points)

• Focus: Deep knowledge of Dynamics 365 as a data source.

• Demonstrate Experience in: Strong understanding of the Dynamics 365 CE/F&O data model, entities, and relationships. Experience developing reports from D365 source data. Familiarity with Dataverse.

4. SQL & Database Performance (20 Points)

• Focus: Advanced SQL skills and database performance tuning.

• Demonstrate Experience in: Proficiency with data manipulation languages (T-SQL/PL-SQL), query performance analysis & tuning, and experience with enterprise databases (e.g., SQL Server, Azure SQL). Experience with SSIS/SSRS is beneficial.

5. Azure Platform & DevOps (10 Points)

• Focus: Familiarity with the Azure data ecosystem and software development practices.

• Demonstrate Experience in: Hands-on work with Azure Data Factory and Synapse Workspaces, knowledge of Azure data management tools, familiarity with DevOps (e.g., Azure Repos/DevOps), and possession of relevant Azure cloud certifications.