Senior Business Intelligence Engineer

Senior Business Intelligence Engineer

Salary: Open + bonus

Location: Chicago, IL

Hybrid: 3 days onsite, 2 days remote

*We are unable to provide sponsorship for this role*

Qualifications

• Bachelor s degree
• 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.)

Responsibilities

• Design, develop, and maintain dashboards, reports, paginated reports, and interactive visualizations primarily in Microsoft Power BI, with the ability to support content built in other enterprise BI tools (e.g., Tableau, Cognos) as needed.
• Build and optimize semantic models, data models, and calculated measures to support accurate, performant, and reusable analytics content.
• Partner with business stakeholders to gather requirements, define KPIs, and translate analytical needs into effective reporting solutions.
• Connect Power BI and other BI platforms to modern cloud data sources including Databricks, Snowflake, Azure SQL, or equivalent lakehouse and warehouse environments, using appropriate connectivity patterns (DirectQuery, Import, composite models, gateways).
• Develop and enforce data visualization standards, naming conventions, and best practices to ensure consistency and usability across the BI portfolio.
• Support the migration and modernization of legacy reporting platforms (e.g., IBM Cognos, Crystal Reports) to modern BI solutions.
• Implement row-level security, data governance policies, and access controls within BI platforms to ensure data protection and compliance.