BI Analytics Developer

BI Analytics Developer

Location: Remote (EST)

Only W2

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.

As a BI Analytics Developer you'll build business-ready semantic models and dashboards using Databricks and Power BI. (Databricks + Power BI + AI/BI)

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