Manager, Data Engineering
Job Summary
Were looking for a hands-on data engineering and database management professional to own the pricing data infrastructure for our Siding & Accessories division. This is not a business analyst role that touches data occasionally this is a technical role that requires you to be in the database every day writing queries managing data pipelines and ensuring the integrity of the systems that drive pricing across the organization.
You will own the pricing database from day one. Youll manage the existing SQL Server environment lead data requirements for our PriceFx implementation and eventually drive the migration of data transformation logic from the legacy database to Boomi ultimately retiring the legacy platform. If youve managed a database led a platform migration and can write SQL in your sleep this role is for you.
Responsibilities:
Database & Data Engineering (Primary 60%)
- 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 dont wait for someone to tell you what to do.
- Own the data validation and quality assurance process. If data goes out wrong its on you to catch it first.
Platform Migration & Future State (25%)
- 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.
Business Partnership & People Management (15%)
- 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.
Qualifications :
- 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).
Additional Information :
The US base salary range for this full-time position is $145000 - $165000 bonus medical dental vision benefits starting day 1 401k and PTO. Our salary ranges are determined by role level and location. Individual pay is determined by work location and additional factors including job-related skills experience and relevant education or training. Your recruiter can share more about the specific salary range for your preferred location during the hiring process. (Full-time is defined as regularly working 30 hours per week.)
All your information will be kept confidential according to EEO guidelines.
Why work for Cornerstone Building Brands
Our teams are at the heart of our purpose to positively contribute to the communities where we live work and play. Full-time* team members receive** medical dental and vision benefits starting day 1. Other benefits include PTO paid holidays FSA life insurance LTD STD 401k EAP discount programs tuition reimbursement training and professional development.
*Full-time is defined as regularly working 30 hours per week. **Union programs may vary depending on the collective bargaining agreement.
Cornerstone Building Brands is an Equal Opportunity Employer.
All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin age pregnancy genetic information disability or status as a protected veteran. You can find the Equal Employment Opportunity Poster here. You can also view Your Right to Work Poster here along with This Organizations Participation in E-Verify Poster here. If youd like to view a copy of the companys affirmative action plan for protected veterans or individuals with disabilities or policy statement please contact Human Resources at or If you have a disability and you believe that you need a reasonable accommodation in order to search for a job opening or to submit an online application please contact Human Resources at or This email is used exclusively to assist disabled job seekers whose disability prevents them from being able to apply online. Only emails received for this purpose will be returned. Messages left for other purposes such as following up on an application or technical issues not related to a disability will not receive a response.
All your information will be kept confidential according to EEO guidelines.
California Consumer Privacy Act (CCPA) of 2018
Must be at least 18 years of age to apply.
Note to External Recruiters
Cornerstone Building Brands does not accept unsolicited resumes and will not pay fees for any candidate submissions that were not expressly authorized.
Notice of Recruitment Fraud
We have been made aware of multiple scams whereby unauthorized individuals are using Cornerstone Building Brands name and logo to solicit potential job-seekers for some cases job-seekers are being contacted directly both by phone and other instances these unauthorized individuals are placing advertisements for fake positions with both legitimate websites and fabricated ones. These individuals are typically promising high-paying jobs with the requirement that the job-seeker send money to pay for things such as visa applications or processing fees. Please be advised that Cornerstone Building Brands will never ask potential job-seekers for any sort of advance payment or bank account information as part of the recruiting or hiring process.
Remote Work :
Yes
Employment Type :
Full-time
About Company
Cornerstone Building Brands is a premier exterior building solutions provider serving both the residential and commercial markets across North America. The building products we manufacture are the cornerstone of the communities where people live, work and play -from homes to hospitals ... View more