Senior BI & Analytics Engineer

Responsibilities

• Design, develop, deploy, and support enterprise dashboards using Power BI and Databricks AI/BI Dashboards.

• Build scalable Power BI semantic models, advanced DAX measures, Power Query transformations, and interactive reporting experiences.

• Create, configure, test, and continuously improve Databricks Genie Agents for approved business domains

• Develop Genie Agent instructions, business definitions, synonyms, sample SQL queries, trusted assets, and benchmark questions.

• Review and troubleshoot natural‑language‑to‑SQL outputs to ensure accurate filters, joins, calculations, aggregations, and business interpretations.

• Design governed dimensional models, metric definitions, and reusable semantic layers across reporting and conversational analytics.

• Document KPI definitions, data lineage, calculation logic, assumptions, ownership, and refresh requirements.

• Apply appropriate security and governance controls using row filters, column masks, and Power BI row‑level security.

• Optimize SQL queries, semantic models, dashboards, and analytical datasets for performance, reliability, and scalability.

• Conduct data validation, reconciliation, UAT, production‑readiness reviews, and post‑production support.

• Partner with business and technical teams to reduce manual reporting and improve adoption of governed self‑service analytics.

• Contribute to group‑wide standards for dashboard development, semantic modelling, Genie Agent configuration, testing, and deployment.

Requirements:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related discipline.

• Over 5 years of experience in business intelligence, analytics engineering, data engineering, or enterprise reporting.

• Advanced hands‑on experience with Power BI, including DAX, Power Query, semantic modelling, workspace administration, security, deployment, and performance optimization.

• Strong experience with Databricks SQL and AI/BI Dashboards.

• Practical experience creating or managing Databricks Genie Agents/Spaces, including instructions, semantic metadata, example SQL, testing, monitoring, and accuracy improvement.

• Expert‑level SQL skills and strong knowledge of dimensional modelling, star schemas, facts, dimensions, relationships, and data‑grain management.

• Understanding of data governance, metadata, lineage, privacy, access control, and production‑release processes.

• Experience translating complex business requirements into trusted and user‑friendly analytical products.

• Strong communication skills with the ability to explain technical concepts to business and senior stakeholders.

• Microsoft Power BI and Databricks certifications are advantageous.

• Strong written and spoken English.