Senior Data Migration [US Client]

Industry/Sector

Not Applicable

Specialism

Advisory - Other

Management Level

Senior 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.

Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality. Embracing increased ambiguity, you are comfortable when the path forward isn’t clear, you ask questions, and you use these moments as opportunities to grow.

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

• Respond effectively to the diverse perspectives, needs, and feelings of others.
• Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems.
• Use critical thinking to break down complex concepts.
• Understand the broader objectives of your project or role and how your work fits into the overall strategy.
• Develop a deeper understanding of the business context and how it is changing.
• Use reflection to develop self awareness, enhance strengths and address development areas.
• Interpret data to inform insights and recommendations.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firm's code of conduct, and independence requirements.

Required Qualifications 

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related technical discipline. 

• 7+ years of hands-on experience in data engineering or large-scale data migration programs. 

• Advanced SQL expertise (mandatory). 

• Strong Python programming experience in production environments (mandatory). 

• Experience designing ETL/ELT pipelines in enterprise or cloud environments. 

Mandatory Technical Skills

Advanced SQL Engineering 

• Complex joins, CTEs, window functions 

• Stored procedures and scripting 

• Query optimization & indexing strategies 

• Handling datasets with millions+ records 

Python Development 

• Pandas, NumPy 

• File handling (CSV, JSON, XML, Parquet) 

• API integrations 

• Automation scripting 

• Experience in: 

• Jupyter Notebook 

• VS Code 

• PyCharm 

• Anaconda 

ETL / ELT Tools 

• DBT 

• Informatica 

• Talend 

• Matillion 

• Azure Data Factory 

• SSIS 

Databases / Warehouses 

• SQL Server 

• Oracle 

• PostgreSQL 

• Snowflake 

• Redshift 

• BigQuery 

Additional Engineering Practices 

• Git version control 

• CI/CD pipelines 

• Basic shell scripting 

• Performance tuning 

Preferred Skills 

• Experience with Change Data Capture (CDC) implementations. 

• Experience migrating data across ERP, CRM, Finance, HR, or other enterprise platforms. 

• Familiarity with data modeling concepts (dimensional and relational). 

• Exposure to containerization (Docker) is a plus. 

• Understanding of security best practices in data movement. 

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