2 months ago
Gurgaon, IndiaStaff+
Responsibilities
- Lead the design and development of scalable ETL/ELT data pipelines using Azure Data Factory, Snowflake, DBT, and Azure data services.
- Design and manage integrations from Guidewire applications and insurance data platforms into Snowflake and Azure environments.
- Analyze Guidewire data models and insurance datasets covering policy, claims, billing, underwriting, customer, and producer information.
- Develop optimized SQL queries for extraction, transformation, validation, and reporting.
- Lead technical discussions and translate business requirements into scalable data solutions.
- Provide technical leadership to data engineering team members and review code, data models, and pipeline designs.
- Monitor, troubleshoot, and optimize pipelines for performance, reliability, scalability, and availability.
- Implement data quality, governance, metadata, lineage, reconciliation, and documentation standards.
- Develop reusable data engineering frameworks and best practices.
- Collaborate with architects, analysts, DevOps, QA, cloud engineering, Guidewire, and business teams.
- Support modernization and migration of legacy insurance data platforms into Azure and Snowflake.
- Implement and support CI/CD processes for data engineering workflows.
- Ensure data solutions meet enterprise security, governance, and regulatory requirements.
Requirements
- At least 8 years of experience in data engineering, data integration, or related roles.
- Strong hands-on experience with Azure Cloud Platform, Azure Data Factory, and Azure Data Lake Storage.
- Extensive SQL experience, including complex queries, performance optimization, and data transformation.
- Hands-on experience with Snowflake and SnowSQL for cloud data warehousing and engineering.
- Strong working knowledge of DBT for data transformation, testing, and documentation.
- Experience with large-scale enterprise datasets and cloud data integration architectures.
- Strong understanding of Guidewire InsuranceSuite, Guidewire data models, and Guidewire-based integrations.
- Experience with Guidewire PolicyCenter, ClaimCenter, and/or BillingCenter data is highly preferred.
- Ability to work with Guidewire APIs, extracts, events, or other applicable integration mechanisms.
- Experience designing downstream pipelines and analytics solutions for Guidewire-generated data.
- Knowledge of insurance data governance, reconciliation, and data quality requirements.
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
- Demonstrated experience leading data engineering teams or providing technical leadership on enterprise data projects.
- Experience with Azure Synapse Analytics, Azure Functions, Python, PySpark, Databricks, DataStage, Netezza, Power BI, Tableau, or similar tools is preferred.
- Strong understanding of cloud data architecture, ETL/ELT, data warehousing, data governance, and DevOps practices.
- Excellent communication, collaboration, stakeholder management, and problem-solving skills.
About EXL
EXL provides data analytics, AI, and digital operations services for enterprises in insurance, healthcare, banking, and other regulated industries. It delivers consulting, managed services, and technology platforms to improve decision-making, risk management, and operational efficiency. Founded in 1999 and headquartered in New York, EXL is a public company listed on the NASDAQ (ticker: EXLS).