Key Role and Responsibilities:Understand and translate business needs into data models supporting long-term solutions.Perform reverse engineering of physical data models from databases and SQL scripts. Analyze data-related system integration challenges and propose appropriate solutions.Assist with and support setting the data architecture direction (including data movement approach, architecture/technology strategy, and any other data-related considerations to ensure business value)Design and implement data pipelines, Optimize data processing and storage, Ensure data solutions meet performance standards, Provide technical support, Collaborate with stakeholders.Must Have:8+ Years of experience as a Data EngineerStrong technical expertise in SQL Advanced SQL querying skills (joins, subqueries, CTEs,
aggregation)Solid knowledge of joints and common table expressions (CTEs)Strong experience with PythonExperience in Snowflake, ETL, SQL, CI/CDStrong expertise in ETL process and with various data model conceptsKnowledge of Star Schema and snowflake schemaGood to know about AWS services such as S3, Athena, Glue, EMR/Spark with a major emphasis on S3 and Glue.Good-to-Have Skills:Experience with Big Data Tools and technologiesGood Understanding of data structures and data analysisKnowledge of Insurance Domain is an addition.Qualifications:Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.7+ years of experience in data engineering roles using AWS and Snowflake.Strong problem-solving, communication, and collaboration skills.
📌 Senior Data Engineer (Mumbai)
🏢 EXL
📍 Mumbai