Senior IT Data Science Engineer

Senior IT Data Science Engineer 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.

DUTIES AND RESPONSIBILITIES:
Database Management

• 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

System Configuration

• Monitor hardware and software performance: Ensure smooth operation (J Preserve data integrity: Regularly validate and maintain data accuracy

Collaboration and Documentation

• 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

Foundational Rapid Response Requirements

• 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

ADDITIONAL RESPONSIBILITIES

• 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