BI Analytics Developer (Databricks + Power BI)

Location: East Coast / Remote Specific Job Functions We are seeking an experienced BI Analytics Developer with a strong background in building data products for the consumption layer. The ideal candidate will have hands-on experience with Databricks, Power BI, and Unity Catalog, and will be responsible for creating semantic models, enriching metadata, and mapping gold layer attributes to KPIs for advanced analytics and predictive dashboards. Key Responsibilities • Data Product Development • Design and build data products for the consumption layer using Databricks and Power BI. • Develop semantic models in Databricks to support self-service analytics and enterprise reporting. • Create reusable datasets and data marts optimized for performance and scalability. • Databricks Integration • Leverage Databricks SQL and Delta Lake for building curated gold layer tables. • Implement Unity Catalog for data governance, security, and lineage tracking. • Apply metadata enrichment techniques to provide business context, tagging, and classification. • Business Context & KPI Mapping • Collaborate with business stakeholders to map gold layer attributes to KPIs. • Define metrics and measures for dashboards and predictive analytics. • Ensure alignment with organizational data standards and governance policies. • Visualization & Reporting • Build Power BI dashboards and reports for operational, analytical, and predictive insights. • Optimize Power BI models for performance and usability. • Integrate Databricks visualizations where applicable. • Collaboration & Documentation • Work closely with data engineers, product owners, and business analysts to translate requirements into technical solutions. • Document semantic models, data products, and metadata strategies. • Participate in design reviews and provide recommendations for best practices. Required Skills • Technical Expertise: • Strong experience with Databricks (SQL, Delta Lake, Unity Catalog). • Advanced Power BI skills (DAX, semantic modelling, performance tuning). • Proficiency in SQL and PySpark for data transformation and modelling. • Proficiency in Python for complex procedures • Data Governance & Metadata: • Experience with Unity Catalog for access control and lineage. • Ability to enrich metadata for business context and tagging. • Analytics & Visualization: • Proven track record of building enterprise-grade dashboards and predictive analytics solutions. • Domain Knowledge: • Familiarity with healthcare or financial KPIs is a plus. • Soft Skills: • Excellent communication and stakeholder engagement skills. • Ability to lead discussions and drive requirements to completion. • Preferred Qualifications • Experience with Azure Databricks and Power BI Service. • Knowledge of data modelling best practices for BI and analytics. • Familiarity with data governance frameworks and data cataloguing tools. • Deliverables • Semantic models in Power BI. • Gold layer data products in Databricks. • Metadata enrichment and tagging strategy. • KPI mapping documentation and predictive dashboards.