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.