Etl Testing+Insurance+BI - Manager

PwC; Pune District, Gurugram District, Bengaluru; Hybrid; INR 350,000 - 520,000; Full time

Job summary

PwC in Pune, Maharashtra, invites an experienced data engineering leader to drive ETL automation and modern data platforms. You will oversee complex data pipelines, governance, and security, while mentoring a growing team and partnering with stakeholders to deliver analytics-ready data assets.

The role emphasizes strategic planning and execution of data transformation programs, with hands-on guidance on cloud data platforms and modern analytics practices.

Qualifications

• Bachelor's degree required.
• 9–14 years of experience expected.
• Proficient in written and spoken English.
• Experience in ETL automation and Guidewire Insurance management is a plus.

Responsibilities

• Leading ETL automation initiatives to improve data processing efficiency.
• Managing data engineering projects using Apache Airflow and Azure Data Factory.
• Developing and optimizing data pipelines and data architecture for seamless integration.
• Implementing database management and security best practices across AWS and Snowflake.
• Guiding teams in strategic planning and execution of data transformation strategies.
• Troubleshooting and validating data warehouse indexing and performance.
• Building and maintaining relationships with stakeholders to address data challenges.
• Promoting innovative technologies and leading practices in data engineering and analytics.
• Coaching and mentoring junior staff in data infrastructure and modeling.
• Ensuring data quality and validation processes to support reliable analytics.

Skills

ETL automation

Airflow

Azure Data Factory

Data pipelines

Data architecture

AWS

Snowflake

Databricks

Mentoring

Data quality

Data validation

Stakeholder management

Education

Bachelor's degree

Tools

AWS

Snowflake

Azure Databricks

Job description

• Leading ETL automation initiatives to enhance data processing efficiency
• Managing data engineering projects using platforms like Apache Airflow and Azure Data Factory
• Developing and optimizing data pipelines and data architecture for seamless integration
• Implementing database management and security best practices across AWS and Snowflake platforms
• Guiding teams in strategic planning and execution of data transformation strategies
• Utilizing analytical thinking to troubleshoot and validate data warehouse indexing and performance tuning
• Building and maintaining relationships with stakeholders to address data challenges and opportunities
• Promoting the use of innovative technologies and leading practices in data engineering and analytics
• Coaching and mentoring junior staff to develop skills in data infrastructure and modeling
• Confirming data quality and validation processes to support accurate and reliable analytics

What You Must Have

• - At least a Bachelor's degree
• - At least 9-14 years of experience
• - Oral and written proficiency in English required
• - ETL Automation + Guidewire Insurance - Manager

What Sets You Apart

• - Preference for at least one of the following fields of study: Management Information Systems, Computer and Information Science, Systems Engineering, Electrical Engineering, Chemical Engineering, Industrial Engineering, Mathematics, Statistics, Mathematical Statistics
• - Utilizing Amazon Web Services (AWS) and Microsoft Azure Databricks for data engineering
• - Developing data architecture and data integration strategies for cloud platforms
• - Implementing data anonymization and database security best practices
• - Excelling in coaching and mentoring junior staff in data analytics
• - Leading data transformation projects with strategic planning and execution
• - Embracing change and innovation in data modernization initiatives