Job description

Summary MITER Brands is a residential window and door manufacturer that provides a leading portfolio of window and door brands for the new construction and replacement segments. MITER Brands, also known as Milgard, MI Windows & Doors and PGTI is one of the nation’s largest suppliers of vinyl windows and patio doors, with plants across the country.We are seeking an initiative-taking Data Engineer to join our growing BI team and have a key role in ensuring our data infrastructure scales seamlessly. The successful candidate will contribute to the development of our enterprise Business Intelligence (Power BI) platform with experience in Azure Date Factory, Azure Data Lake, Azure Synapse Analytics, Azure DevOps, and Microsoft Fabric. The ideal candidate will be responsible for designing, building, and maintaining scalable data solutions and will collaborate closely with the BI Development and Data Analytics teams to ensure data accuracy, accessibility, and visualization for business intelligence needs.This position is available ON-SITE in Venice, Florida; Tacoma, Washington; and Harrisburg, Pennsylvania. Compensation is based on cost-of-living adjustments for the following states: Tacoma, WA with a pay range of $91,715–$114,643. Responsibilities Data Pipeline Development: Design, develop, and maintain scalable and automated data pipelines to enable Reporting, data visualization, advanced analytics, and machine learning solutions.Data Integration: Integrate data from multiple sources, including databases, APIs, flat files, and third-party vendors, into a centralized data lake. Write SQL queries to extract, transform, and load data from sources.Data Quality: Implement data validation, cleansing, and monitoring processes to ensure the accuracy, consistency, and completeness of our data.Data Storage: Work with data storage solutions such as Azure Data Factory, Azure Data Lake, OneLake, and Data Warehouses to optimize performance and accessibility.Develop and maintain semantic data models, ensuring data accuracy, consistency, and securityPartner with development team to build and optimize Power BI reports, dashboards, and visualizations to support business intelligence needs.Monitor and manage Fabric Capacity Metrics to optimize data infrastructure performance.Leverage Microsoft solutions for data governance and metadata management.Maintain data security and integrity, ensuring compliance with organizational and industry standards.Work with data Subject Matter Exprts (SMEs) to translate business needs into data solutions.Continuously improving data processes, identifying opportunities for automation and efficiency. Qualifications 3+ years of experience in BI data engineering preferably in manufacturing or a related field.Strong proficiency with Microsoft Fabric solutions (Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Synapse Pipelines, Azure DevOps).Firsthand experience with Power BI, including DAX, Power Query (M), and Power BI Service.Expertise in SQL and data modeling, with experience designing efficient and scalable data structures.Ability to develop and maintain ETL/ELT pipelines for data ingestion and transformation.Knowledge of data governance best practices with an understanding of data security and access controls.Experience collaborating with stakeholders to define reporting and analytics requirements.Strong analytical, excellent trouble shooting and programming skills. Good oral and written communication skills. Promotes a cooperative and productive team environment.Recent Experience with the migration from Azure Synapse Analytics to Microsoft One Lake and familiarity with Microsoft Fabric architecture is desired.Microsoft DP-600 or DP-700 certification (Fabric Analytics Engineer or Data Analyst) and experience with Microsoft Fabric AI/ML tools experience is a plus. About Us Our benefits package includes coverage of your health, wealth, and wellness for you and your eligible spouse/dependents. We offer a competitive salary and benefits package, including a 401k with company match and generous paid time off to help you balance your life. Below is a list of benefits you will enjoy while working with our company.Three comprehensive Medical plan optionsPrescriptionDentalVisionCompany Paid Life InsuranceVoluntary Life InsuranceSupplemental Hospital Indemnity, Critical Illness, and Accident InsuranceCompany-paid Short-Term DisabilityCompany-paid Long-Term DisabilityPaid time off (PTO), including Vacation, Personal, and paid Holidays401k retirement plan with company matchEmployee Assistance ProgramTeladocLegal InsuranceIdentity Theft ProtectionPet InsuranceTeam Member Discount ProgramTuition ReimbursementYearly Wellness ClinicMITER Brands, also known as MI Windows and Doors, Milgard and PGT Industries are an equal-opportunity employer. The company does not discriminate based on religion, race, creed, color, national origin, sex, age, disability, handicap, veteran status, sexual orientation, genetic information, or any other applicable legally protected category. Summary MITER Brands is a residential window and door manufacturer that provides a leading portfolio of window and door brands for the new construction and replacement segments. MITER Brands, also known as Milgard, MI Windows & Doors and PGTI is one of the nation’s largest suppliers of vinyl windows and patio doors, with plants across the country.We are seeking an initiative-taking Data Engineer to join our growing BI team and have a key role in ensuring our data infrastructure scales seamlessly. The successful candidate will contribute to the development of our enterprise Business Intelligence (Power BI) platform with experience in Azure Date Factory, Azure Data Lake, Azure Synapse Analytics, Azure DevOps, and Microsoft Fabric. The ideal candidate will be responsible for designing, building, and maintaining scalable data solutions and will collaborate closely with the BI Development and Data Analytics teams to ensure data accuracy, accessibility, and visualization for business intelligence needs.This position is available ON-SITE in Venice, Florida; Tacoma, Washington; and Harrisburg, Pennsylvania. Compensation is based on cost-of-living adjustments for the following states: Tacoma, WA with a pay range of $91,715–$114,643. Responsibilities Data Pipeline Development: Design, develop, and maintain scalable and automated data pipelines to enable Reporting, data visualization, advanced analytics, and machine learning solutions.Data Integration: Integrate data from multiple sources, including databases, APIs, flat files, and third-party vendors, into a centralized data lake. Write SQL queries to extract, transform, and load data from sources.Data Quality: Implement data validation, cleansing, and monitoring processes to ensure the accuracy, consistency, and completeness of our data.Data Storage: Work with data storage solutions such as Azure Data Factory, Azure Data Lake, OneLake, and Data Warehouses to optimize performance and accessibility.Develop and maintain semantic data models, ensuring data accuracy, consistency, and securityPartner with development team to build and optimize Power BI reports, dashboards, and visualizations to support business intelligence needs.Monitor and manage Fabric Capacity Metrics to optimize data infrastructure performance.Leverage Microsoft solutions for data governance and metadata management.Maintain data security and integrity, ensuring compliance with organizational and industry standards.Work with data Subject Matter Exprts (SMEs) to translate business needs into data solutions.Continuously improving data processes, identifying opportunities for automation and efficiency. Qualifications 3+ years of experience in BI data engineering preferably in manufacturing or a related field.Strong proficiency with Microsoft Fabric solutions (Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Synapse Pipelines, Azure DevOps).Firsthand experience with Power BI, including DAX, Power Query (M), and Power BI Service.Expertise in SQL and data modeling, with experience designing efficient and scalable data structures.Ability to develop and maintain ETL/ELT pipelines for data ingestion and transformation.Knowledge of data governance best practices with an understanding of data security and access controls.Experience collaborating with stakeholders to define reporting and analytics requirements.Strong analytical, excellent trouble shooting and programming skills. Good oral and written communication skills. Promotes a cooperative and productive team environment.Recent Experience with the migration from Azure Synapse Analytics to Microsoft One Lake and familiarity with Microsoft Fabric architecture is desired.Microsoft DP-600 or DP-700 certification (Fabric Analytics Engineer or Data Analyst) and experience with Microsoft Fabric AI/ML tools experience is a plus. About Us Our benefits package includes coverage of your health, wealth, and wellness for you and your eligible spouse/dependents. We offer a competitive salary and benefits package, including a 401k with company match and generous paid time off to help you balance your life. Below is a list of benefits you will enjoy while working with our company.Three comprehensive Medical plan optionsPrescriptionDentalVisionCompany Paid Life InsuranceVoluntary Life InsuranceSupplemental Hospital Indemnity, Critical Illness, and Accident InsuranceCompany-paid Short-Term DisabilityCompany-paid Long-Term DisabilityPaid time off (PTO), including Vacation, Personal, and paid Holidays401k retirement plan with company matchEmployee Assistance ProgramTeladocLegal InsuranceIdentity Theft ProtectionPet InsuranceTeam Member Discount ProgramTuition ReimbursementYearly Wellness ClinicMITER Brands, also known as MI Windows and Doors, Milgard and PGT Industries are an equal-opportunity employer. The company does not discriminate based on religion, race, creed, color, national origin, sex, age, disability, handicap, veteran status, sexual orientation, genetic information, or any other applicable legally protected category.

Requirements