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. They are seeking a hands-on data engineering and database management professional to own the pricing data infrastructure for their Siding & Accessories division, managing SQL Server environments and leading data migrations.

Responsibilities:

• Own and maintain the pricing 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
• Manage the end-to-end data flow: source system (JDE) → pricing database → PriceFx. Ensure data moves correctly, transformations are accurate, and outputs are validated before they reach stakeholders
• Monitor and respond to production incidents independently — database outages, 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
• Lead the data requirements for the PriceFx implementation — attend design sessions, answer data questions from the vendor, and own the data architecture decisions
• Document and reverse-engineer the existing transformation logic in the pricing database
• Lead the migration of that logic to Boomi (or similar ETL/integration platform), ensuring data quality is maintained through the transition
• Manage the eventual retirement of the legacy pricing database once the Boomi pipeline is validated and PriceFx is receiving clean data
• Serve as the data expert for the Pricing team — translate business needs into data requirements and explain data outputs in business terms
• Partner with the Pricing Director and stakeholders to ensure the data infrastructure supports pricing operations and business decisions
• Manage one direct report (Pricing Analyst) who maintains pricing data in the source system (JDE). Her work feeds your database — you need to understand what she does and ensure alignment
• Coordinate with the development team (.NET developers) during the transition period for legacy platform knowledge transfer

Requirements:

• 5+ years of hands-on SQL Server experience
• Experience managing and maintaining a production database
• Strong understanding of data flow and integration between systems
• Experience with data validation and quality assurance
• Independent problem-solving and operational ownership
• Experience with ETL tools or integration platforms (Boomi, Informatica, SSIS, or similar)
• Experience with PriceFx or other pricing platforms
• Experience with ERP systems (JDE/JD Edwards, SAP, Oracle)
• Experience leading or contributing to a platform migration — moving from a legacy system to a modern architecture
• Familiarity with Power BI, Tableau, or other BI tools for data visualization
• People management experience, even if informal (mentoring, leading projects, managing a small team)
• Experience in manufacturing, building products, or B2B distribution industries
• Familiarity with Python, R, or other scripting languages for data automation
• Experience with cloud platforms (AWS, Azure, Snowflake)