Sr. Business Intelligence Engineer; Power BI Specialist

Location: Downtown Chicago, hybrid (3 days onsite)

Compensation: $100,000 to $150,000

Type: Full-time, W2

We're hiring a hands‑on Power BI specialist for an established international law firm modernizing its reporting onto Power BI and Databricks. This is a builder’s role for someone who lives in the tool every day, not a management or strategy seat.

• Build and maintain Power BI dashboards, reports, and semantic models end to end
• Write advanced DAX measures and Power Query transformations
• Design star schema data models and tune report performance
• Manage Power BI Service work spaces, deployment pipelines, and row‑level security
• Partner with business stakeholders to define KPIs and turn requirements into deliverables
• Support migration of legacy reporting (Cognos, SSRS) into Power BI

• 5+ years delivering enterprise BI solutions, with heavy hands‑on Power BI development
• Deep, current Power BI skills: DAX, semantic modeling, Power Query, performance tuning
• Strong SQL across relational and cloud‑native sources
• Experience with Databricks or a comparable cloud platform (Snowflake, Synapse)
• Bachelor’s degree in a related field
• Strong communication and the ability to work directly with business teams

• Legal or professional services background
• BI migration experience (legacy to Power BI)