BI Engineer

Job Description

As a Business Intelligence (BI) Engineer, you will play a crucial role in the design, development, and maintenance of data‑driven solutions that enable effective decision‑making within the organization. Leveraging your technical expertise and analytical mindset, you will collaborate with stakeholders to understand their reporting and data analysis requirements and translate them into robust and scalable BI solutions. This position requires a strong foundation in data analysis, proficiency in BI tools and technologies, and a passion for transforming raw data into meaningful insights.

Hybrid schedule (3x per week) based out of Deerfield, IL. Effective fall 2025, Fortune Brands will transition to a new world‑class campus in Deerfield, bringing together associates from across our U.S. offices, brands, and functions. The campus will offer vibrant work spaces for collaboration, along with amenities for dining, onsite daycare, fitness and recreation.

• Design, develop, and implement BI solutions using SQL, ETL tools, and data visualization platforms.
• Gather requirements, define data models, and ensure data accuracy and integrity.
• Optimize database structures, queries, and ETL processes for improved performance.

• Create visually appealing and user‑friendly reports, dashboards, and data visualizations using BI tools.
• Collaborate with users to understand reporting needs and provide self‑service reporting capabilities.
• Enhance and optimize existing reports and dashboards.

• Create specifications for data models to support business use cases.
• Partner with Data Engineers to ensure effective ETL processes.
• Ensure data quality through cleansing, validation, and error handling.

• Perform data analysis and mining to uncover patterns and trends.
• Collaborate with stakeholders to understand analytical requirements and provide actionable insights.
• Develop statistical models and predictive analytics for decision support.

• Ensure compliance with data governance policies and data security standards.
• Collaborate with data stewards and IT teams to establish and enforce governance standards.
• Conduct data profiling and analysis to identify and resolve data quality issues.

• Bachelor’s or master’s degree in a relevant field (e.g., Computer Science, Data Science, Information Systems).
• Proven experience (3 years) as a BI Engineer or similar role, with a strong focus on data analysis, reporting, and BI solution development.
• Proficiency in SQL and experience with relational databases and data modeling.
• Hands‑on experience with ETL tools and processes, as well as data integration and transformation techniques.
• Familiarity with BI tools such as Tableau, Power BI, Qlik Sense, or similar platforms.
• Solid understanding of data warehousing concepts, methodologies, and best practices.
• Strong analytical and problem‑solving skills, with the ability to translate business requirements into technical solutions.
• Excellent communication and collaboration skills to interact effectively with stakeholders and convey complex concepts to non‑technical audiences.
• Detail‑oriented with a focus on data accuracy, quality, and integrity.
• Ability to work independently and manage multiple projects simultaneously.

Fortune Brands believes in fair and equitable pay. A reasonable estimate of the base salary range for this role is Hiring Pay Range: $85,000 USD – $110,000 USD. Please note that actual salaries may vary within the range, or be above or below the range, based on factors including, but not limited to, education, training, experience, professional achievement, business need, and location.

In addition to base salary, employees will participate in either an annual bonus plan based on company and individual performance, or a role‑based sales incentive plan.

At Fortune Brands, we support the overall health and wellness of our associates by offering comprehensive, competitive benefits that prioritize all aspects of wellbeing and provide flexibility for our teammates’…