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