DE&A - Core - Advanced Data Engineering - Advanced Data Engineering (Other)

We are seeking a Data Engineer to support the development of a scalable, enterprise-wide data platform for a leading insurance client. The role involves building and maintaining batch and real-time data pipelines, enabling self-service analytics (Power BI), and contributing to report rationalization initiatives.
The candidate will work with a modern cloud stack including Snowflake, DBT, AWS Glue, and Amazon Kinesis, ensuring efficient data ingestion, transformation, and optimization across Raw, Silver, and Gold layers.
Key Responsibilities
Data Ingestion & Processing
Develop and maintain batch data pipelines using AWS Glue
Build and support real-time data ingestion pipelines using Amazon Kinesis
Integrate data from multiple insurance systems (policy, claims, billing, third-party sources)
Data Transformation & Modeling
Implement transformations using DBT across Raw, Silver, and Gold layers
Create scalable data models to support reporting and analytics use cases
Ensure consistent, reusable, and well-documented data assets
Data Platform Support
Work on Snowflake-based data warehouse to manage and optimize data storage and access
Support medallion architecture implementation (Raw → Silver → Gold)
Collaborate with senior engineers and architects on platform enhancements
Reporting Enablement & Rationalization
Support Power BI self-service reporting by delivering curated, high-quality datasets
Assist in report rationalization efforts, identifying redundant or inefficient reports
Align data models to business KPIs and insurance domain requirements
Pipeline Optimization
Monitor and optimize data pipelines for performance, scalability, and cost efficiency
Troubleshoot data issues, bottlenecks, and failures in pipelines
Apply best practices in query tuning and data processing efficiency
Data Quality & Governance
Implement and maintain data validation and quality checks
Ensure adherence to data governance standards and controls
Support audit and reconciliation requirements
Required Skills & Experience
Technical Skills
Hands-on experience with: Snowflake (data warehousing basics, querying, optimization)
DBT (transformations, models, testing)
AWS Glue (batch ETL pipelines)
Amazon Kinesis (real-time streaming)

Strong proficiency in SQL and basic data modeling concepts
Programming knowledge in Python (preferred)
Analytics & Reporting
Exposure to Power BI for data consumption and reporting
Understanding of data structures for analytics use cases
Optimization & Troubleshooting
Ability to identify and resolve pipeline performance issues
Basic understanding of cost optimization techniques in cloud environments
Domain Knowledge (Preferred)
Experience in Insurance domain (policy, claims, underwriting, billing)
Familiarity with enterprise data ecosystems and reporting needs in insurance
Experience
3–6 years of experience in Data Engineering / ETL Development
Experience working on cloud-based data platforms
Key Success Metrics
Reliability and performance of data pipelines
Data quality and consistency across layers
Timely delivery of curated datasets for reporting
Contribution to report rationalization and platform efficiency

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.