BI Engineer at Therma-Tru Doors in Deerfield, IL | USD85,000-110,000 | Kablio

Role

Description

data modeling

bi development

etl processes

dashboard design

data governance

data quality

Collaborate with stakeholders to understand analytical requirements and provide actionable insights.
Ensure compliance with data governance policies and data security standards.
Create visually appealing and user-friendly reports, dashboards, and data visualizations using BI tools.
Perform data analysis and mining to uncover patterns and trends.
Create specifications for data models to support business use cases.
Design, develop, and implement BI solutions using SQL, ETL tools, and data visualization platforms.
Collaborate with data stewards and IT teams to establish and enforce governance standards.
Ensure data quality through cleansing, validation, and error handling.
Collaborate with users to understand reporting needs and provide self-service reporting capabilities.
Enhance and optimize existing reports and dashboards.
Conduct data profiling and analysis to identify and resolve data quality issues.
Partner with Data Engineers to ensure effective ETL processes.
Gather requirements, define data models, and ensure data accuracy and integrity.
Develop statistical models and predictive analytics for decision support.
Optimize database structures, queries, and ETL processes for improved performance.

Requirements

etl

bi engineer

tableau

sql

data modeling

bachelor's

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

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

$400M

Annual Sales

Reported annual sales figure under Fortune Brands Home & Security ownership.

25%

US Market Share

Market share at the time of acquisition by Fortune Brands Home & Security.

70M

Doors Produced

Cumulative number of doors manufactured.

Their history began in 1962 from a bold remnant of a building-supply salvage in Toledo, pioneering the first wood-look fiberglass door in 1983.
By the ’80s and ’90s, they scaled production with plants in Indiana and Mexico, launching iconic lines like Classic-Craft and Smooth-Star.
Today they boast state-of-the-art facilities including an Innovation Center in Ohio and manufacturing in Butler, Indiana, and Matamoros, Mexico.
They manufacture both fiberglass and steel exterior door systems, plus glass sidelites, transoms, and complete door systems.
Their doors are rigorously tested for durability, insulation, and weather-proofing.
Popular among builders and remodelers, their typical projects include residential entryways and patio doors with decorative glass.
Known for blending high performance and curb appeal, they offer bold wood-grain aesthetics and paint-ready smooth fiberglass.
Their innovation hub launched tools like the DoorWays app and immersive virtual showcases to help customers visualize home upgrades.

Culture + Values

Customer Focused - We are dedicated to delivering an exceptional experience for our customers through a commitment to quality and service.
Innovation - We continuously seek innovative ways to improve our products and processes.
Integrity - We act with honesty and transparency in all our actions and decisions.
Collaboration - We work together as one team to achieve our goals and deliver value.
Accountability - We take ownership of our actions and results.

Environment + Sustainability

Targeting Net Zero by 2050

Net Zero Carbon Emissions Target

Aim to achieve net zero carbon emissions by 2050, demonstrating commitment to long-term sustainability goals.

Committed to sustainability and environmental responsibility through product design and operational practices.
Continuing to reduce energy consumption and water usage in manufacturing processes.
Use of recycled materials in products to minimize waste.
Focus on developing energy-efficient products, such as insulated doors, to help reduce carbon footprints for homeowners.

Inclusion & Diversity

Focused on creating an inclusive workplace through recruitment and development practices.
Measuring diversity across gender, ethnicity, and roles.
Supportive of equal pay and advancement opportunities for all employees.

Articles

Tools & Resources For Professionals

Project Center

Certified Door System Installer Program

Role

Description

data modeling

bi development

etl processes

dashboard design

data governance

data quality

Collaborate with stakeholders to understand analytical requirements and provide actionable insights.
Ensure compliance with data governance policies and data security standards.
Create visually appealing and user-friendly reports, dashboards, and data visualizations using BI tools.
Perform data analysis and mining to uncover patterns and trends.
Create specifications for data models to support business use cases.
Design, develop, and implement BI solutions using SQL, ETL tools, and data visualization platforms.
Collaborate with data stewards and IT teams to establish and enforce governance standards.
Ensure data quality through cleansing, validation, and error handling.
Collaborate with users to understand reporting needs and provide self-service reporting capabilities.
Enhance and optimize existing reports and dashboards.
Conduct data profiling and analysis to identify and resolve data quality issues.
Partner with Data Engineers to ensure effective ETL processes.
Gather requirements, define data models, and ensure data accuracy and integrity.
Develop statistical models and predictive analytics for decision support.
Optimize database structures, queries, and ETL processes for improved performance.

Requirements

etl

bi engineer

tableau

sql

data modeling

bachelor's

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

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

$400M

Annual Sales

Reported annual sales figure under Fortune Brands Home & Security ownership.

25%

US Market Share

Market share at the time of acquisition by Fortune Brands Home & Security.

70M

Doors Produced

Cumulative number of doors manufactured.

Their history began in 1962 from a bold remnant of a building-supply salvage in Toledo, pioneering the first wood-look fiberglass door in 1983.
By the ’80s and ’90s, they scaled production with plants in Indiana and Mexico, launching iconic lines like Classic-Craft and Smooth-Star.
Today they boast state-of-the-art facilities including an Innovation Center in Ohio and manufacturing in Butler, Indiana, and Matamoros, Mexico.
They manufacture both fiberglass and steel exterior door systems, plus glass sidelites, transoms, and complete door systems.
Their doors are rigorously tested for durability, insulation, and weather-proofing.
Popular among builders and remodelers, their typical projects include residential entryways and patio doors with decorative glass.
Known for blending high performance and curb appeal, they offer bold wood-grain aesthetics and paint-ready smooth fiberglass.
Their innovation hub launched tools like the DoorWays app and immersive virtual showcases to help customers visualize home upgrades.

Culture + Values

Customer Focused - We are dedicated to delivering an exceptional experience for our customers through a commitment to quality and service.
Innovation - We continuously seek innovative ways to improve our products and processes.
Integrity - We act with honesty and transparency in all our actions and decisions.
Collaboration - We work together as one team to achieve our goals and deliver value.
Accountability - We take ownership of our actions and results.

Environment + Sustainability

Targeting Net Zero by 2050

Net Zero Carbon Emissions Target

Aim to achieve net zero carbon emissions by 2050, demonstrating commitment to long-term sustainability goals.

Committed to sustainability and environmental responsibility through product design and operational practices.
Continuing to reduce energy consumption and water usage in manufacturing processes.
Use of recycled materials in products to minimize waste.
Focus on developing energy-efficient products, such as insulated doors, to help reduce carbon footprints for homeowners.

Inclusion & Diversity

Focused on creating an inclusive workplace through recruitment and development practices.
Measuring diversity across gender, ethnicity, and roles.
Supportive of equal pay and advancement opportunities for all employees.

Articles

Tools & Resources For Professionals

Project Center

Certified Door System Installer Program