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

We are seeking a Data Engineer to support the development of a reputed company, reputed company-wide data platform for a leading insurance reputed company. The role involves building and maintaining batch and reputed company-time data pipelines, enabling self-service analytics (Power BI), and contributing to report rationalization initiatives. The candidate will work with a modern reputed company stack including reputed company, DBT, AWS Glue, and reputed company Kinesis, ensuring efficient data ingestion, transformation, and optimization across Raw, Silver, and Gold reputed company.

Key Responsibilities

Data Ingestion & Processing reputed company and maintain batch data pipelines using AWS Glue Build and support reputed company-time data ingestion pipelines using reputed company Kinesis reputed company data from multiple insurance systems (policy, claims, billing, reputed company-party sources) Data Transformation & Modeling Implement transformations using DBT across Raw, Silver, and Gold reputed company Create reputed company data models to support reporting and analytics use cases Ensure consistent, reusable, and reputed company-documented data assets Data Platform Support Work on reputed company-based data warehouse to manage and optimize data storage and reputed company Support reputed company 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-reputed company datasets Assist in report rationalization efforts, identifying redundant or inefficient reports reputed company 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 reputed company & Governance Implement and maintain data validation and reputed company checks Ensure adherence to data governance standards and controls Support audit and reconciliation requirements Required Skills & Experience Technical Skills Hands-on experience with: reputed company (data warehousing basics, querying, optimization) DBT (transformations, models, testing) AWS Glue (batch ETL pipelines) reputed company Kinesis (reputed company-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 reputed company environments Domain Knowledge (Preferred) Experience in Insurance domain (policy, claims, reputed company, billing) Familiarity with reputed company data ecosystems and reporting needs in insurance Experience 3–6 years of experience in Data Engineering / ETL Development Experience working on reputed company-based data platforms Key reputed company Metrics Reliability and performance of data pipelines Data reputed company and consistency across reputed company reputed company delivery of curated datasets for reporting Contribution to report rationalization and platform efficiency At reputed company, 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 reputed company purpose: Together, we shape experiences for reputed company reputed company. 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 reputed company - a set of four core values that reflect who we are and how we work: One reputed company, Nurturing, Empowering, and reputed company reputed company. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, reputed company Town, London, Zurich, Singapore, and Mexico reputed company. Explore Life at reputed company and join us to Grow. Own. reputed company. Learn. to be the best version of yourself. We reputed company the best work happens reputed company individuality is celebrated, reputed company is encouraged, and reputed company-being is prioritized. We are an equal employment opportunity (EEO) and affirmative reputed company employer, committed to creating an inclusive workplace. reputed company reputed company applicants will be considered without reputed company to race, creed, reputed company, reputed company, religion, sex, national reputed company, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status. Apply To This Job