BSCO - Data Development(Guidewire Data Migration/Conversion) - Senior Associate

Job Description

At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives. As a Guidewire developer at PwC, you will specialise in developing and customising applications using the Guidewire platform. Guidewire is a software suite that provides insurance companies with tools for policy administration, claims management, and billing. You will be responsible for designing, coding, and testing software solutions that meet the specific needs of insurance organisations. 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. Skills 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. The Opportunity Joining PwC Acceleration Centers (ACs) places you at the heart of innovation, where you?ll actively contribute to services across Advisory, Assurance, Tax, and Business Services. In these dynamic hubs, you?ll tackle challenging projects and deliver distinctive client support through enhanced quality and innovation. You?ll also benefit from digitally enabled training designed to elevate your technical and professional capabilities. As part of the Business Application Consulting team, you?ll focus on software development for Guidewire applications. In the Senior Associate role, you?ll solve complex problems, mentor junior team members, and uphold high standards to deliver impactful solutions while cultivating strong client relationships. Responsibilities Design, develop, and optimize ETL processes using SSIS to support Guidewire data migration and integration initiatives. Perform data analysis, profiling, and validation to ensure data quality and consistency across PolicyCenter, BillingCenter, ClaimCenter, and related systems. Lead and support data conversion activities using Guidewire Policy Migration Tool (PMT) and Claim Migration Tool (CMT). Collaborate with functional, technical, and client stakeholders to define data mapping, transformation, and migration strategies. Troubleshoot and resolve data migration issues during SIT, UAT, and production cutover. Provide hyper-care support post-implementation to ensure smooth transition and client satisfaction. Adhere to data governance, compliance, and security standards while delivering migration solutions. Mentor junior team members and contribute to best practices in data development. What You Must Have Bachelor?s degree in Computer Science, Information Technology, or related field (or equivalent work experience). 4?6 years of experience in data development, ETL, and data migration, with at least 2+ years on Guidewire data conversion projects. Solid understanding of Guidewire Core data models (Policy, Billing, Claims, and Contact Manager). Proven ability to handle large-scale data migration and transformation projects. Strong hands-on experience with SSIS (SQL Server Integration Services) and SQL development. Experience in Guidewire data conversion projects with PMT (Policy Migration Tool) and CMT (Claim Migration Tool). What Sets You Apart Exposure to other ETL/ELT tools (Informatica, ADF, Talend, etc.). Knowledge of Medallion architecture (Bronze/Silver/Gold layers) and Enterprise Data Warehousing (EDW) concepts. Experience with Agile/Scrum project delivery. Insurance industry domain knowledge.