Azure Data Architect

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Unable to Provide Sponsorship

Skills

Dashboard
DAX
Microsoft Power BI
Data Engineering
Databricks
Data Lake

Job Details

The Senior Data Engineer Power BI & Databricks Reporting will play a key role in designing, developing, and optimizing data models, metrics, and reports that drive data-informed decision-making across the organization. This role combines strong Power BI visualization expertise with advanced data engineering skills in Databricks with Unity Catalog, ensuring high-quality, scalable data products for both enterprise reporting and self-service analytics use cases.

 

Key Responsibilities:

Power BI Reporting & Visualization

* Design, develop, and maintain interactive Power BI dashboards and reports for various business domains (finance, operations, marketing, etc.).

* Power BI/Fabric Reporting & Visualization

* Leveraged Microsoft Fabric for end-to-end data architecture integrating Lakehouse, Data Flows, and Direct Lake models to power advanced Power BI analytics.

* Create semantic models and DAX measures that are intuitive and optimized for performance.

* Collaborate with business users to translate requirements into visual insights and define KPI frameworks.

* Implement row-level security (RLS) and governance standards within Power BI workspace environments.

* Support self-service BI adoption by developing certified datasets and user-friendly data models.

Databricks & Data Engineering

* Design and build data pipelines and curated layers (Bronze, Silver, Gold) within Databricks using Unity Catalog, PySpark / SQL / Delta Lake.

* Develop metric layers and data marts in Databricks to support Power BI and other analytical tools.

* Ensure data quality, consistency, and accuracy through robust data validation and monitoring processes.

* Implement performance tuning and cost optimization best practices for Databricks jobs and clusters.

* Collaborate with the data governance and architecture teams to align data models with enterprise standards.

Collaboration & Governance

* Partner with business analysts, product owners, and stakeholders to identify new reporting opportunities.

* Work closely with data governance, QA, and DevOps teams to ensure compliant, secure, and automated delivery.

* Provide technical leadership and mentorship to junior engineers on best practices for BI and data engineering.

* Support the development of metadata-driven frameworks and data catalogs to enable discoverability and reusability.

 

Required Skills & Experience:

* Bachelor s or master s degree in computer science, Information Systems, or a related field.

* 5 8+ years of experience in data engineering and BI development.

* Strong hands-on experience with:

o Databricks (PySpark, Delta Lake, SQL)

o Power BI (DAX, Power Query, Data Modeling)

o Azure Data Services (Data Lake, Synapse, ADF preferred)

* Proven ability to develop and maintain metric frameworks for enterprise reporting.

* Experience implementing CI/CD pipelines for Power BI and Databricks deployments (nice to have).

* Strong understanding of data modeling, ETL design, and data architecture principles.

* Excellent analytical thinking, problem-solving, and stakeholder communication skills.

* Creation of a reusable, well-governed metric layer in Databricks for enterprise use.

* Improved data reliability, transparency, and self-service enablement across teams.

 

Preferred Qualifications:

* Knowledge of modern data architecture patterns (Medallion Architecture, Data Mesh).

* Prior experience in food, beverage, retail, or gaming industries (plus).

* Microsoft Power BI Data Analyst Associate or Databricks Data Engineer certification preferred.

* Delivery of high-quality, automated Power BI dashboards that align with business metrics.

* Demonstrated collaboration with cross-functional teams to enable a data-driven culture.

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.