IT Data Science Principal

Cornerstone Building Brands•Rocky Mount, VA

22h•$110,000 - $130,000

About The Position

IT Data Science Principal role is dedicated to maintaining and improving the Kinaxis Rapid Response data environment for Cornerstone Building Brands Apertures division. This role will focus on the security and integrity of key data elements of the system. and the subsequent scenario publishing of core collaboration segments for the Rapid Response environment. This role will be a stakeholder in support of the broader adoption and usability of the Rapid Response system and will be a trusted expert within the system by obtaining Author Level 1 certification as a requirement of accepting the role.

Requirements

Bachelor's degree in Computer Science, Information Technology or related field required, Master's degree preferred
5 plus years of previous work experience in a Data Engineering, IT support, or Systems Administration role
2 plus years of experience working for a manufacturing business
Kinaxis Rapid Response experience preferred
Must have previous experience deploying new software systems
Proficiency in SQL
IT Governance experience

Nice To Haves

CPIM and CSCP are preferred certifications

Responsibilities

Monitor database performance: Conduct regular performance tuning and optimize queries for maximum efficiency
Install, configure, and upgrade database software: Ensure databases are up-to-date.
Core scenario dataset maintenance and governance
Develop and implement backup and recovery strategies: Ensure data reliability and minimize downtime
Perform routine maintenance tasks: This includes database backups, index rebuilding, and statistics gathering
Monitor hardware and software performance: Ensure smooth operation (J Preserve data integrity: Regularly validate and maintain data accuracy
Collaborate with stakeholders: Work with developers. system administrators, and other teams
Document database structures and procedures: Maintain clear records.
Develop processes and procedures to create, maintain, and update data within Rapid Response inclusive of cross functional workflow
Act as SME for Kinaxis Rapid Response system in support of S&OP and S&OE teams
Update and maintain integrity of baseline enterprise data scenario within the Kinaxis Rapid Response system
Create and maintain dashboards, workbooks, worksheets, task flows, forms. scorecards
Manage premier support requests to Kinaxis
Assist with initial configuration of Kinaxis Rapid Response system to support Demand Planning, Supply Planning, Constraint Management. Master Production Scheduling, Inventory Management. etc.
Support initial configuration of system BOMs (Planning and Feature)
Collaborate with Product Management and Product Engineering to maintain Planning BOMs and Feature BOMs
Routine updates of planning characteristics by product series
Routine updates of disaggregation percentages across planning BOMs
Routine updates of planning characteristics by product series
Routine updates of quantities within Feature BOMs to align with configured BOMs
Develop, maintain, and execute weekly audit plan to ensure system data accuracy
Develop and manage routines (daily/weekly/monthly) for maintaining data security and integrity within the Kinaxis Rapid Response system
Documentation of database structures and procedures for clear records
Assume Authorship role within Rapid Response