Senior BI and Automation Engineer (Power BI, DAX, Power Automate, Azure Data)

About the role
You’ll build enterprise dashboards, reporting systems, and automation workflows, ensuring KPI standardization, reporting accuracy, and data governance compliance while improving operational efficiency through structured automation.

What you’ll do

• Build Power BI dashboards aligned to business KPIs; advanced DAX measures; standardized templates; performance optimization 
• Design data models and ETL pipelines; validate data quality; maintain dimensional modeling standards; optimize SQL performance 
• Own KPI governance: formal KPI definitions/formulas, centralized KPI dictionary, prevent conflicting metrics 
• Build Power Automate workflows (approvals/notifications/triggers) with reliability + exception handling; API-based automation integration 
• Enforce data governance/security: RBAC + Power BI row-level security; compliance with access policies 
• Validate outputs vs source systems; reconciliation checks; audit trails; RCA for discrepancies 

Must-have

• 5+ years BI/data analytics; enterprise reporting; strong relational DB background; Agile experience 
• Power BI (advanced DAX), data modeling (star/snowflake), report optimization 
• SQL Server (advanced queries, stored procedures, indexing) 
• ETL: SSIS or Azure Data Factory preferred; data warehouse concepts 
• Power Automate (cloud/desktop flows), REST/JSON integrations, orchestration logic 
• Azure data services (Azure SQL, ADF, Synapse) + governance (RBAC/RLS, privacy/compliance) 

Authority / constraints

• Owns KPI modeling and automation framework principles; cannot redefine KPIs without PO/business alignment; cannot bypass governance/access policy 

Certs

• PL-300 mandatory; DP-203 recommended