Data Migration Analyst at AMETEK O'Brien

Sydney, New South Wales, Australia -

Full Time

Start Date

Immediate

Expiry Date

25 Jun, 26

Salary

0.0

Posted On

27 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Migration, Data Analysis, Data Mapping, Data Transformation, Data Validation, ETL/ELT, SQL, Data Integrity, Cutover Planning, Source-to-Target Mapping, Data Profiling, Reconciliation, ERP, CRM, MDM, Stakeholder Engagement

Industry

Motor Vehicle Manufacturing

Description

Are you wanting to work for an organisation that values their people, invests in communities and has a commitment to our environment? Do you share a passion for maintaining a continual focus on Making a Difference with Real Care to customers and employees? If this sounds like you, then we have your next opportunity. -- Be part of a major transformation journey with one of Australia’s most iconic brands. O’Brien Glass is seeking an experienced Data Migration Analyst to play a critical role in migrating high‑value data from legacy systems into modern enterprise platforms. This role is ideal for a hands‑on data professional who enjoys working at the intersection of technology, business, and large‑scale transformation programs. Why Join O’Brien? At O’Brien, we combine iconic brand strength with industry‑leading transformation capability. You’ll join a collaborative, high‑performing IT & Transformation environment where your expertise directly impacts business continuity, customer experience, and operational success across Australia. In this role, you’ll: Work on enterprise‑wide transformation programs (ERP, CRM, scheduling, finance, supply chain & field service) Partner with senior leaders, project teams, and global transformation stakeholders Play a key role in reducing business risk and safeguarding data integrity Be trusted as a subject matter expert during critical cutover periods About the Role As a Data Migration Analyst, you will be accountable for planning, mapping, transforming, validating, and migrating data from legacy systems into target platforms such as ERP, CRM, and Master Data Management (MDM) systems. You’ll ensure data accuracy, integrity, and compliance while supporting multiple migration cycles including mock conversions, test loads, dress rehearsals, and production cutovers. This is a high‑impact role within O’Brien’s transformation landscape. Key Responsibilities Data Analysis & Mapping Analyse ERP and MDM data import templates, structures, and validation rules Identify required source systems and datasets (primarily ERP) Produce detailed source‑to‑target mapping documentation, including: Field‑level mappings Transformation, translation, and derivation rules Business rules, defaults, and data quality assumptions Data Extraction & Transformation Design and develop repeatable data extraction solutions Transform and cleanse data to meet target system requirements Perform data standardisation, code/value translations, and master data alignment Support multiple migration cycles across test and cutover phases Data Load & Validation Prepare and validate ERP and MDM import files Support data loads across non‑production and production environments Perform reconciliations and validation to confirm completeness and accuracy Troubleshoot and resolve data load issues within tight timeframes Project & Stakeholder Engagement Partner with functional consultants, technical teams, and business SMEs Support cutover planning and execution from a data perspective Provide clear updates on status, risks, and issues related to migration activity What You’ll Bring Essential Experience & Skills Bachelor’s degree in Information Systems, Computer Science, Data/Analytics, or equivalent experience 3–5+ years’ experience in data migration, data engineering, or data analysis roles Strong SQL skills (T‑SQL / PL‑SQL) Hands‑on ETL/ELT experience (e.g. Azure Data Factory, Synapse, SSIS, Informatica, Talend, dbt, Pentaho) Proven experience delivering source‑to‑target mappings and transformation logic Data profiling, quality rules, reconciliation, and audit controls experience Experience supporting SIT/UAT testing, defect management, and cutover activities Strong documentation skills and ability to communicate with both technical and non‑technical stakeholders Desirable Experience ERP, CRM, or Field Service migrations (e.g. Dynamics 365, SAP, Oracle, Salesforce) Exposure to Power Platform / Power BI, Azure DevOps, Git, or CI/CD pipelines Experience with Master Data Management (MDM) and data governance frameworks Knowledge of Australian privacy legislation and data security requirements Background in contact centre, field workforce, inventory, or supply chain data domains Python or PowerShell scripting for automation and validation Certifications such as Azure Data Engineer, Informatica, Talend, PRINCE2, Agile, or ITIL Your Impact In this role, you will help ensure O’Brien’s data is accurate, trusted, and migration‑ready, directly supporting business continuity and successful platform transformation across the organisation. -- If you meet the above criteria and you’re seeking a rewarding career with a nationally recognised household brand, then we would love to hear from you. Apply Now! At O'Brien®, we put our customer at the heart of everything that we do, serving more than 360,000 Customers each year, 24 hours a day, 7 days a week, 365 days a year. O'Brien is also part of Belron®, worldwide leader in vehicle glass repair, replacement and recalibration services, operating in 40 countries across 6 continents Privacy: To review and consider your application, O'Brien® collects personal information. To understand what is collected and why, carefully review the Applicant Privacy Notice presented during your online application and/or review our Privacy Policy and Terms of Use. Agencies: O'Brien® does not accept unsolicited resumes or outreach from recruiting agencies. Absent a signed agreement and approval from O'Brien® to submit candidates to a specific requisition, we will not approve payment to any third party. Didn't find the right job? Upload your CV/resume for ongoing consideration! Founded in February 1924 by Frank G. O’Brien on Allen Street, Waterloo, O’Brien® began as a silvering business with a strong commitment to customer satisfaction and employee well-being. Over the years, we’ve grown to become Australia’s leading vehicle glass repair and replacement company. Today, O’Brien® operates nationwide, offering a wide range of automotive care products and services to both retail and wholesale customers. Each year, we serve over 360,000 motorists, 24 hours a day, 7 days a week, 365 days a year. Our expertise extends beyond vehicles - since 1924, O’Brien® has also been a trusted provider of quality glass products and services for Australian homes and businesses. Our tailored glazing solutions are designed to meet the unique needs of every customer. In 2018 O'Brien® and Laser & Electrical Plumbing untied their expertise, giving rise to O'Brien Plumbing and Electrical enabling O'Brien® to offer a complete range of a complete range of products and services across Australia. O'Brien® is also part of Belron®, a global leader in vehicle glass repair, replacement, and recalibration, operating in over 40 countries across 6 continents. At O'Brien®, we put our customer at the heart of everything that we do, maintaining a continual focus on Making a Difference with Real Care to our customers and employees.

Responsibilities

The Data Migration Analyst is accountable for planning, mapping, transforming, validating, and migrating high-value data from legacy systems into target platforms like ERP, CRM, and MDM systems. Key duties involve analyzing data structures, designing extraction solutions, cleansing data to meet target requirements, and supporting multiple migration cycles through validation and cutover execution.