Manager, Data Engineering

Cornerstone Building Brands is a leading manufacturer of exterior building products for residential and low-rise non‑residential buildings in North America. Headquartered in Cary, N.C., we serve residential and commercial customers across the new construction and Repair & Remodel (R&R) markets. Our market‑leading portfolio of products spans vinyl windows, vinyl siding, stone veneer, metal roofing, metal wall systems and metal accessories. Cornerstone Building Brands’ broad, multi‑channel distribution platform and expansive national footprint includes more than 18,800 team members at manufacturing, distribution and office locations throughout North America.

Corporate stewardship and Environmental, Social and Governance (ESG) responsibility are embedded in our culture. We are committed to contributing positively to the communities where we live, work and play. For more information, visit us at .

We're looking for a hands‑on data engineer to own, maintain and expand the data infrastructure behind our Siding & Accessories commercial analytics function. This is not a business analyst role that touches data occasionally — it's a technical role that puts you in the database every day, writing queries, building and maintaining pipelines, curating the master and reference data everything joins to, and guaranteeing the integrity of the data that sales, product, customer, and market reporting depend on.

You will own the commercial database from day one. You'll manage the SQL Server environment, keep data flowing cleanly from our source systems into the models and dashboards the business runs on, and build the pipelines that bring together sales, product, customer, and external market data into one trusted commercial dataset. Just as important, you'll own the master and reference data — the customer, product, and territory definitions everything reconciles to — so the numbers tie out no matter who's asking.

If you've owned a production database, built and troubleshot data pipelines end to end, and can write SQL in your sleep, this role is for you.

Primary Responsibilities:

• Own and maintain the commercial SQL Server database — tables, views, stored procedures, data integrity, and performance.
• Write, optimize, and troubleshoot SQL queries daily. This is hands‑on work, not oversight.
• Own the end‑to‑end data flow: source systems (JDE and others) → SQL Server commercial database → Power BI. Ensure data moves correctly, transformations are accurate, and outputs are validated before they reach stakeholders.
• Build and maintain ingestion for external, third‑party market data (industry, competitive, and share sources) and join it cleanly to internal sales, product, and customer data — reconciling keys, grain, and definitions across sources.
• Monitor and respond to production incidents independently — pipeline failures, file failures, data quality issues. You triage, engage the right teams, and communicate status. You don't wait for someone to tell you what to do.
• Own the data validation and quality assurance process. If data goes out wrong, it's on you to catch it first.
• Own the master and reference data behind commercial reporting — customer, product, and sales‑hierarchy / territory (e.g., TSM / RSM) masters — so every downstream model joins to one consistent, trusted set of definitions.
• Build and maintain the crosswalks and mapping tables that reconcile codes and hierarchies across source systems, and between internal data and external market data.
• Standardize, de‑duplicate, and validate reference data, and enforce clear definitions and naming so the same entity means the same thing everywhere it's used.
• Manage changes to master and reference data with an eye to history — version or effective‑date…