Lead Data Engineer

Andersen Corporation • Oak Park Heights, MN

22h

About The Position

At Andersen, we see possibility everywhere, every day and in everything we do. The possibility for our employees to achieve their full potential, for our communities to be stronger and for everyone to have a healthier, happier place to live. Our portfolio of brands — Andersen Windows & Doors, Renewal by Andersen and Fenetres MQ — is crafted to serve customers across the new residential, home improvement and light commercial building sector. Join our more than 13,000 employees who are inspired every day to deliver exceptional experiences that turn possibility into reality. The Enterprise Data Engineering team at Andersen Corporation is seeking an experienced Data Engineer to drive and elevate technical execution and provide architectural leadership across distributed onshore and offshore engineering teams. This role serves as the primary technical point of contact, ensuring complex data requirements are translated into scalable, resilient, and high performing solutions within a modern cloud-based analytics ecosystem centered on Azure and Snowflake. The ideal candidate will shape engineering standards, influence best practices across teams, and help drive operational excellence. This position collaborates closely with data delivery teams, solution architects, and platform partners to deliver world-class data products that fuel critical business priorities and support analytical, AI/ML, and data driven innovation.

Requirements

• Bachelor’s or Master’s degree in technology (or equivalent experience).
• Minimum 10 years of experience designing, building, and optimizing large‑scale data solutions.
• Advanced proficiency in modern data architecture, performance tuning, and pipeline optimization with technologies such as Fivetran, Snowflake, and dbt.
• Experience with traditional and modern data warehousing technologies and cloud platforms (AWS/Azure/Cloud, Informatica, BOBJ, CI/CD tools, PowerBI).
• Strong understanding of agile methodologies (Scrum, Kanban) and collaboration tools (Jira, Confluence).
• Knowledge of Data Ops practices, automated release pipelines, and automated QA solutioning.
• Strong proficiency in Azure services across storage, compute, and DevOps/CI/CD.
• Exposure to functional programming such as python, scala for distributed processing.
• Proven experience engineering layered data frameworks using Kimball and Data Vault 2.0 modeling methodologies.
• Demonstrated leadership experience, including guiding engineering teams and performing technical code reviews.

Nice To Haves

• Experience with Azure Data Services (ADO, Blob Storage, Azure Functions).
• Experience with configuration or framework driven pipelines.
• Experience enabling AI/ML through robust data foundations for predictive analytics and generative AI use cases.
• Experience with advanced data governance, including automated privacy controls and metadata cataloging.

Responsibilities

• Serve as the primary technical leader for distributed engineering teams, translating business needs into detailed technical specifications while ensuring consistent adherence to engineering standards across teams located in multiple time zones.
• Design and engineer a robust layered data framework using modern modeling techniques—including Data Vault 2.0 and Kimball—to optimize storage, resilience, and processing efficiency within a cloud-based analytics ecosystem.
• Build scalable, purpose-built datasets optimized for reporting, analytics, ML/AI, cross platform integration, and data product interoperability.
• Ensure adherence to data governance policies by implementing and validating data lineage, quality controls, classification, and other applicable governance standards.
• Drive platform reliability through automated data workflows, end-to-end observability, proactive data health monitoring, and rigorous data quality enforcement.
• Partner with solution architects, product owners, stakeholders, and business analysts to design and implement high quality data solutions that serve as foundational blueprints for broader engineering initiatives.
• Present complex technical concepts, architectural decisions, and methodologies to non‑technical business partners with clarity and precision.
• Identify and champion opportunities to enhance development methodologies, tools, technologies, and technical processes—driving measurable improvements and fostering a culture of innovation.

Benefits

• 401 (k) Plan, Employer Fixed Contributions & Company Matching
• Profit Sharing
• Medical, Dental and Vision Coverage
• Flexible Spending Accounts (FSAs), Health Savings Account (HSA) and Health Reimbursement Account (HRA)
• Life Insurance
• Paid Time Off & Paid Holidays
• Paid Maternity Leave & Paid Parental Leave
• Career Growth Planning & Nationwide Career Opportunities

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 5,001-10,000 employees