Job Description
Designing BI solutions using SQL and ETL tools turns raw data into actionable insights, enabling businesses like Fortune Brands to optimize operations in home and security markets. Engineers create reports and dashboards with BI platforms such as Tableau or Power BI, gathering requirements from stakeholders to support decision-making processes. Their efforts involve data modeling, cleansing, and validation to ensure accuracy in transformed datasets.
Fortune Brands Innovations produces home, security, and digital products, focusing on transformations in home and commercial spaces. The company includes brands in water, outdoors, and security, generating revenue through innovative designs and processes. Fortune Brands employs global teams to deliver high-growth products, emphasizing sustainability and trust in client partnerships.
Engineers design ETL processes, define data models, and create specifications for business cases using relational databases. They develop reports, dashboards, and visualizations in platforms like Qlik Sense, partnering with Data Engineers for integration. Tasks include performing data analysis for trends, profiling for quality issues, and enforcing governance policies shared through documentation. A challenge includes managing multiple projects while translating complex data concepts to non-technical audiences.
The role allows a hybrid schedule with three days per week in Deerfield, Illinois, transitioning to a new campus in fall 2025. Salary ranges from $85,000 to $110,000 USD annually, with participation in annual bonus or incentive plans. Benefits include health plans, market-leading 401(k) with company contribution, product discounts, flexible time off, adoption benefits, ERGs, and well-being resources, along with tuition reimbursement for professional development.
Responsibilities
- Design and implement BI solutions using SQL, ETL tools, data visualization platforms
- Gather requirements and define data models
- Create visually appealing reports, dashboards, data visualizations
- Collaborate with users for reporting needs
- Optimize ETL processes for performance
- Perform data analysis and mining for patterns
- Partner with Data Engineers for ETL processes
- Ensure data quality through cleansing and validation
- Conduct data profiling and analysis for issues
Requirements
- Bachelor’s or master’s degree in Computer Science, Data Science, Information Systems or similar
- 3+ years experience as BI Engineer or similar
- Strong focus on data analysis, reporting, BI solution development
- Proficiency in SQL and relational databases
- Hands-on experience with ETL tools and processes
- Familiarity with Tableau, Power BI, Qlik Sense or similar
- Solid understanding of data warehousing and best practices
- Strong analytical problem-solving skills
- Excellent communication and collaboration skills