Senior Business Intelligence (BI) Engineer

NO SPONSORSHIP - NO OPT

SENIOR BUSINESS INTELLIGENCE (BI) ENGINEER

SALARY: $100k - $150k plus discretionary bonus

LOCATION: Chicago, IL hybrid 3-4 days onsite 1-2 days remote

Looking for a candidate with 5 years Power BI, strong SQL data querying across relational and cloud native data sources. You will have hands on experience building semantic models calculated measures and KPIs using DAX and power query.

The team is driving a firm-wide BI transformation, consolidating reporting from Cognos, SSRS, and other legacy systems into a modern Power BI + Databricks ecosystem. Hence, needing a Power BI Specialist.

Designing and building Power BI dashboards and reports

Developing semantic/data models where needed

Translating business requirements into technical specifications

Partnering with stakeholders (Finance, Marketing, etc.) to define KPIs

Collaborating with data engineers when new data ingestion is required

Supporting migration from legacy tools (Cognos, SSRS)

Breakdown: ~80% hands-on development, ~20% stakeholder engagement

QUALIFICATIONA:

-5+ years of experience designing and delivering enterprise BI solutions

-Strong Power BI expertise (critical) - Experience with one or more additional enterprise BI platforms such as Tableau, Cognos, Looker, or Qlik is also acceptable, provided the candidate is willing and able to develop deep Power BI expertise.

-Strong SQL and Data querying skills

-Experience building semantic models, Advanced dashboards using DAX and Power Query data modeling, visualization best practices

-Experience working directly with business stakeholders

-Exposure to cloud data platforms (e.g., Databricks (preferred), Snowflake, Azure Synapse etc.)

A Power BI specialist (not a generalist) who can hit the ground running and operate between business and technical teams.