Data Migration Analyst [US Client]

Industry/Sector

Not Applicable

Specialism

Advisory - Other

Management Level

Associate

Job Description & Summary

At PwC, our people in software and product innovation focus on developing cutting-edge software solutions and driving product innovation to meet the evolving needs of clients. These individuals combine technical experience with creative thinking to deliver innovative software products and solutions.

Those in software engineering at PwC will focus on developing innovative software solutions to drive digital transformation and enhance business performance. In this field, you will use your knowledge to design, code, and test cutting-edge applications that revolutionise industries and deliver exceptional user experiences.

Driven by curiosity, you are a reliable, contributing member of a team. In our fast-paced environment, you are expected to adapt to working with a variety of clients and team members, each presenting varying challenges and scope. Every experience is an opportunity to learn and grow. You are expected to take ownership and consistently deliver quality work that drives value for our clients and success as a team. As you navigate through the Firm, you build a brand for yourself, opening doors to more opportunities.

Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:

• Apply a learning mindset and take ownership for your own development.
• Appreciate diverse perspectives, needs, and feelings of others.
• Adopt habits to sustain high performance and develop your potential.
• Actively listen, ask questions to check understanding, and clearly express ideas.
• Seek, reflect, act on, and give feedback.
• Gather information from a range of sources to analyse facts and discern patterns.
• Commit to understanding how the business works and building commercial awareness.
• Learn and apply professional and technical standards (e.g. refer to specific PwC tax and audit guidance), uphold the Firm's code of conduct and independence requirements.

Required Qualifications 

• University studies in Information Systems, Computer Science, Engineering, or related technical field. 

• 5+ years of hands-on experience in data migration, data conversion, or system transformation programs (mandatory). 

• Advanced SQL experience working directly with relational databases (mandatory). 

• Hands-on experience with enterprise ETL tools (mandatory). 

• Practical experience using Python for data transformation and validation (mandatory). 

Mandatory Technical Skills

Candidates must demonstrate professional experience working with: 

Databases & SQL Platforms 

At least one of the following: 

• Oracle 

• DataBricks 

• PostgreSQL 

• Snowflake 

• Redshift 

• BigQuery 

• Azure SQL 

SQL Capabilities 

• Complex joins, CTEs, window functions 

• Data reconciliation queries 

• Performance optimization 

• Data quality validation scripts 

ETL / Data Integration Tools 

• Informatica 

• Talend 

• Matillion 

• DBT 

• Azure Data Factory (ADF) 

• SSIS or similar enterprise-grade ETL tools 

Python & Development Environments 

• Python (Pandas, NumPy) 

• Jupyter Notebook / JupyterLab 

• VS Code 

• PyCharm 

• Anaconda environments 

Data Formats 

• Flat files (CSV, fixed-width) 

• XML 

• JSON 

Preferred Certifications 

• SQL or database certifications 

• ETL tool certifications (Informatica, Talend, ADF, etc.) 

• Snowflake SnowPro or cloud data platform certifications 

Preferred Skills and Experience 

• Experience migrating data across ERP, CRM, finance, HR, supply chain, or other enterprise platforms. 

• Strong understanding of data modeling concepts (relational, dimensional). 

• Familiarity with cloud data platforms and modern data architectures. 

• Experience working in large-scale, multi-phase migration programs. 

• Strong analytical and problem-solving skills with high attention to data integrity and reconciliation accuracy. 

• Excellent communication skills and experience working in cross-functional and global teams. 

General requirements 

• Understand the importance of have a correct information management 

• Knowledge of Information Security and Data Protection  

• Correct Information Security Management 

All qualified applicants will receive consideration for employment at PwC without regard to ethnicity; creed; color; religion; national origin; age; disability; neurodiversity; sexual orientation; gender identity or expression; marital; or any other status protected by law. PwC is proud to be an inclusive organization and equal opportunity employer.  

Travel Requirements

Not Specified

Job Posting End Date