Job description

Summary: We are looking for a BI Analytics Developer to build business-ready semantic models and dashboards using Databricks and Power BI . The role focuses on shaping Gold-layer analytics datasets , defining metrics and KPIs , and enabling insights through Power BI and Databricks AI/BI (Genie) . This is not a data engineering role , but strong Databricks SQL and Lakehouse knowledge is required. Duties: Databricks (Lakehouse / Gold Layer) • Build analytics-ready datasets and semantic models using Databricks SQL • Create business views, measures, dimensions, and KPIs • Use Unity Catalog for discovery, lineage, metadata, and governance • Apply semantic metadata for AI/BI (Genie) consumption Power BI • Develop optimized dashboards and datasets using Databricks SQL Warehouses • Select the right connectivity mode (DirectQuery / DirectLake / Import) • Apply best practices for data modeling, DAX, and performance tuning • Reuse Databricks-defined metrics wherever possible Analytics & Business Logic • Translate business needs into dimensional models (facts, dimensions, KPIs) • Define and validate business rules and calculations • Ensure data quality and metric consistency Collaboration • Partner with data engineering to refine Silver/Gold layers • Work with business stakeholders to finalize KPIs and reporting needs • Coordinate with governance teams on metadata and data definitions Required: • Strong SQL and experience building analytic views/models • Hands-on Databricks SQL, Delta tables, Unity Catalog • Solid understanding of dimensional modeling & semantic layers • Power BI expertise (DAX, modeling, performance, Databricks integration) • Ability to deliver curated, business-ready datasets for BI and AI/BI Desired: • Python for analysis in notebooks • Experience with Databricks AI/BI (Genie) or semantic metrics • Knowledge of data governance, metadata, lineage, data quality • Healthcare or financial domain KPI exposure • Strong communication and stakeholder management skills Qualifications: • AWS + Databricks + Power BI Service experience • BI data modeling best practices • Familiarity with data governance and cataloging tools Deliverables: • Power BI semantic models & dashboards • Databricks Gold-layer data products • KPI and metrics documentation • Metadata tagging and governance inputs

Requirements

Must-haves

Databricks (Lakehouse / Gold Layer)
Build analytics-ready datasets and semantic models using Databricks SQL
Create business views, measures, dimensions, and KPIs
Use Unity Catalog for discovery, lineage, metadata, and governance
Apply semantic metadata for AI/BI (Genie) consumption
Develop optimized dashboards and datasets using Databricks SQL Warehouses
Select the right connectivity mode (DirectQuery / DirectLake / Import)
Apply best practices for data modeling, DAX, and performance tuning
Reuse Databricks-defined metrics wherever possible
Analytics & Business Logic
Translate business needs into dimensional models (facts, dimensions, KPIs)
Define and validate business rules and calculations
Ensure data quality and metric consistency
Collaboration
Partner with data engineering to refine Silver/Gold layers
Work with business stakeholders to finalize KPIs and reporting needs
Coordinate with governance teams on metadata and data definitions
Strong SQL and experience building analytic views/models
Hands-on Databricks SQL, Delta tables, Unity Catalog

Nice-to-haves

Python for analysis in notebooks
Experience with Databricks AI/BI (Genie) or semantic metrics
Knowledge of data governance, metadata, lineage, data quality
Healthcare or financial domain KPI exposure
Strong communication and stakeholder management skills

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aisqlpythonaws

Platform: jobdiva
Effort: medium