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