Job Description
Mandatory Skills:
- 8+ Years of experience as a Data Engineer
-
Strong technical expertise in SQL
-
Advanced SQL querying skills (joins, subqueries, CTEs, aggregation)
-
Strong knowledge of joins and common table expressions (CTEs)
- Strong experience with Python
- Experience in Snowflake, ETL, SQL, CI/CD
-
Strong expertise in ETL process and with various data model concepts
-
Knowledge of Star Schema and snowflake schema
-
Good to know about AWS services such as S3, Athena, Glue, EMR/Spark with a
major emphasis on S3 and Glue.
Nice to Have:
-
Experience with Big Data Tools and technologies
-
Good understanding of data structures and data analysis
-
Knowledge of Insurance Domain is an addition.
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)
Responsibilities for Internal Candidates
- Design and implement data pipelines
- Optimize data processing and storage
-
Ensure data solutions meet performance standards
- Provide technical support
- Collaborate with stakeholders
Qualifications for Internal Candidates
Bachelor's/Master's in Engineering
2-5 year