IT Data Science Principal (Data Warehouse)

The IT Data Science Principal provides leadership for enterprise data warehouse and artificial intelligence capabilities ensuring the organization delivers trusted insights and scalable Data and AI solutions aligned with business strategy. This role leads people platforms and delivery practices across analytics engineering BI data science/ML and GenAI enablement.

The Data Warehouse Engineer partners closely with Data & Analytics leadership Information Security Risk/Compliance and business leaders to define priorities manage teams and vendors and embed governance for data models and AI use cases. This role drives measurable outcomes through roadmap execution operating rhythms and continuous improvement across Data Warehouse analytics and AI delivery.

WHAT YOULL DO

• Partner in developing enterprise analytics and AI roadmap aligning use cases and investments to business strategy value and feasibility.
• Establish outcome-based prioritization intake and funding recommendations for analytics ML and GenAI initiatives.
• Define success metrics and benefits tracking for analytics/AI products and services (adoption quality cycle time and business impact).
• Lead coach and partner with multi-disciplinary teams (analytics engineers BI developers/analysts data scientists/ML engineers) including vendor/partner resources.
• Set clear expectations for delivery quality documentation testing and responsible AI practices; build development plans and career pathways.
• Build a high-performing organization focused on customer value operational excellence and continuous learning across analytics and AI.
• Partner with business and functional leaders to identify shape and deliver analytics and AI use cases; translate needs into a clear product backlog and release plan.
• Serve as a trusted advisor on KPI design experimentation model performance and adoption considerations (process change management training).
• Communicate priorities timelines risk and decisions clearly; establish operating rhythms and executive-ready status reporting.
• Define and enforce standards for data products semantic models KPI definitions model documentation and lifecycle management.
• Ensure analytics and AI solutions comply with enterprise security privacy data retention and regulatory requirements; partner with InfoSec and Risk on controls.
• Establish responsible AI practices (use-case review human-in-the-loop where needed monitoring for drift/bias and incident response) and drive audit-ready evidence.
• Identify and lead opportunities to modernize the analytics and AI platform (cloud data stack self-service BI feature/model stores and GenAI tooling).
• Implement scalable delivery and operations (CI/CD automated testing observability cost management) to improve reliability speed and reuse across analytics and AI products.
• Bring a strong understanding of the manufacturing domain preferably windows manufacturing to align data models and analytics solutions with plant product and order-management processes.
• Apply advanced dimensional modeling (Kimball Inmon Data Vault) to design star schemas snowflake models fact/dimension tables and enterprise data models.
• Lead end-to-end ETL/ELT pipeline development including ingestion transformation reconciliation and loading pipelines using tools such as SSIS ODI and Matillion.
• Drive data governance data quality and Master Data Management (MDM) including trust rules match/merge logic lineage analysis DQ dashboards reconciliation processes and MDM rule sets.
• Apply strong SQL engineering skills writing complex SQL PL/SQL stored procedures materialized views and CTEs with a focus on performance tuning.
• Maintain data lineage metadata management and documentation including data dictionaries mapping documents lineage tracking and metadata-driven data warehouse frameworks.
• Provide leadership on data warehouse projects and cross-functional collaboration leading data engineering teams managing stakeholders gathering requirements and delivering enterprise data warehouse solutions across multiple business units.
• Bring cloud data warehousing exposure (Snowflake) including hands-on experience modernizing legacy warehouses implementing Medallion architecture and managing cloud-native data platforms.

Qualifications :

• Bachelors degree in Information Technology Data Analytics Business or a related field.
• 8 plus years of experience across enterprise analytics business intelligence and/or data science/ML delivery in a medium-to-large enterprise environment.
• Proven experience leading teams and portfolios delivering analytics products and AI solutions including vendor management roadmap execution and stakeholder governance.
• Hands-on experience with Snowflake as an enterprise platform including Cortex Analyst / Snowflake Intelligence for semantic-layer-driven natural language analytics warehouse cost/performance tuning and role-based access governance.
• Experience designing and operating a medallion architecture (Bronze/Silver/Gold) with clear separation between raw replication single-source-of-truth business definitions and consumer-specific customizations.
• Experience consolidating data from multiple heterogeneous ERP and legacy source systems (e.g. JDE EBS SAP based systems and similar) into a governed enterprise platform including reconciliation across inconsistent business definitions and buying-group/customer hierarchies.
• Strong people leadership coaching and stakeholder management skills.
• Ability to translate business strategy into analytics and reporting solutions.
• Ability to manage multiple priorities in a fast-paced matrixed environment.
• Experience delivering AI/ML or GenAI solutions in production environments including MLOps practices and cross-functional delivery. 
• Exposure to responsible AI/model risk management enterprise data governance and Agile/DevOps delivery methodologies.
• Demonstrates practical AI literacy and the ability to thoughtfully use AIenabled tools to enhance productivity decisionmaking and quality of work.

Additional Information :

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 :

No

Employment Type :

Full-time