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)