Data Architect Manager - Program Symphony

Do you want to be part of a business that genuinely values entrepreneurialism, innovation and individual accountability? We focus on our customers and are proud of the difference our technology makes. We partner with some of the biggest manufacturing companies in the world and our technical innovations are used to enhance well-known brands across multiple industries.

Particle Measuring Systems (PMS) sets the standard for cleanroom contamination monitoring. With more than 60 patents, we create the technology that enables our customers to make fact-based decisions, improve process yields and comply with ever-changing regulatory requirements.

About Program Symphony

Symphony is a business-led transformation program strategically aimed at transforming the PMS ways of working and improving end-to-end processes enabled by technology. It is a multi-phased program consisting of the following components: Master Data Management, migrating to a modern ERP platform, SAP S4HANA in a Rise environment, Salesforce Service Management, and Experience Cloud with Salesforce.

The Role

As the Data Architect Manager for Symphony, you will be responsible for delivering high quality data for all Program projects, particularly for the successful launch and deployment of our ERP system, SAP S4HANA. Reporting to the Transformation Director, you will define the data migration strategy and deliver a detailed plan that covers Strategy, Preparation, Source to Target Mapping, Cleansing, Data Extraction, Transformation, Loading (ETL), Testing, and Cutover. You will collaborate with department heads, managers, vendors, and other stakeholders to understand the PMS data environment and advise on opportunities and limitations of the SAP S4 data model to drive appropriate solutions.

Specific Job Responsibilities:

• Collaborate with the selected third-party implementation partner to define the data architecture strategy and detailed plan that will be delivered within the Integrated Programme Plan.

• Drive the development of the data architecture roadmap, migration plans, checklists, and timelines, ensuring adherence to project milestones.

• Ensure third-party partner and PMS accountabilities are clear and delivered in accordance with the Programme plan, across the phases of Strategy, Preparation, Source to Target Mapping, Cleansing, Data Extraction, Transformation, Loading (ETL), Testing and Cutover.

• Collaborate with process owners, subject matter experts, data analysts, and other stakeholders to define, establish, and communicate application and data architecture standards, policies, and directions.

• Design high quality architectures and drives architecture activities that are aligned to organization requirements and are consistent with enterprise architectural standards.

• Lead the design and implementation of advanced data collection and ingestion frameworks.

• Architect and maintain scalable, high-performance data pipelines and storage solutions.

• Prepare accurate database design and architecture reports for management and executive teams.

• Document data related change management process/system impacts and work with Communications Specialist to share change to end user community.

• Develop and implement data cleansing strategies and reconciliation plans.

• Evaluate the integrity and validity of data elements, ensuring accuracy throughout the data remediation process.

• Collaborate with data owners to validate cleansed data and ensure compliance with established standards.

• Lead and mentor a team of data quality analysts, defining their roles and responsibilities.

• Establish data migration security controls to safeguard sensitive information.

• Design and execute comprehensive migration test plans, including unit and end-to-end integration testing.

• Document migration activities and outcomes, providing insights and recommendations for continuous improvement.

• Ensure compliance with relevant regulations, audit controls, and data security policies.

• Provide technical guidance and support to development team members, fostering a collaborative environment.

• Establish an accountability and approval framework for all functions and Global Process Owners operating within the data strategy and migration plan.

Qualifications:

• BS degree in Computer Science, Information Systems, or a related field; Master's preferred

• 5-7 years of experience in supporting large data migration/conversions for ERP applications

• 5-7 years supervisory experience

• Experience in data platform architecture, data engineering, master data management and modern data practices

• Strong SAP S4 Hana data architecture knowledge

• Strong knowledge of database design principles and best practices

• Proficiency in relevant tools (Apache Hive, Big Data technologies, Spark, VBA, etc.)

• Experience in writing SQL * Loader, SQL, PLSQL

• Excellent analytical skills with the ability to analyze complex datasets

• Strong communication skills, both oral and written, with the ability to effectively communicate technical concepts to non-technical stakeholders

• Attention to detail and a strong commitment to data accuracy and integrity

• Ability to work independently as well as collaboratively in a team environment

The Nuts and Bolts

Location

• This is a Remote position with periodic travel to our Boulder HQ's may be required. Local candidates preferred.

2024 Benefits At-a-Glance

Our benefit package is provided through our parent company, Spectris.

• Medical

• Health Advocate

• This confidential service can help you; your spouse, dependent children, parents, and parents-in-law resolve health care and insurance-related issues, manage chronic conditions and improve your health and well-being.

• Dental

• Delta Dental PPO; DeltaCare USA

• Vision

• VSP Vision Plan

• 401(k)

• Flexible Spending Account

• Onsite Wellness Clinic

• Onsite physician for basic health and wellness consultations.

Pay Range

$106,000 - 145,000 depending upon experience

How we determine what we pay (compensation philosophy)

Particle Measuring Systems determines pay for positions using local, national, and industry-specific survey data, for the Boulder, Colorado area. We will evaluate external equity, which is the relative marketplace job worth of jobs directly comparable to jobs within our company.

For new hires, we try to make competitive offers between the minimum and around the midpoint of the range. This allows the new employee room for future merit increases during review cycles. There may be times when we will offer above the midpoint. The decision to do so will be based on the applicant's level of experience, education, and specialized knowledge and skills. Additionally, we consider the external market rate, the amount we have budgeted internally, and the compensation rates of the employees within the company doing the same position.

Particle Measuring Systems is proud to be an Equal Opportunity Employer