Description

You will design and maintain large-scale data warehousing infrastructure and ETL/ELT pipelines.

This role is on-site.

Responsibilities

• Build and maintain data pipeline architectures using AWS big data technologies.
• Develop multi-dimensional models including Star and Snowflake schemas, normalization, and de-normalization.
• Automate data ingestion, streaming, job scheduling, and monitoring across Lambda, Glue, S3, Redshift, and Power BI.
• Optimize data delivery and scalability by implementing data compression into Parquet and automating manual processes.

Required Skills

• 5+ years of hands-on experience in data warehousing and OLAP systems.
• Expert-level SQL knowledge for query authoring, views, and stored procedures.
• Proven experience with AWS services: Glue, Redshift, S3, and Lambda.
• Deep understanding of data model development, including Fact and Dimensional tables.
• Experience building and optimizing big data pipelines and architectures.
• Ability to assemble complex datasets meeting functional and non-functional requirements.
• Strong skills in job scheduling and automation.

Key Skills

Education

ANY GRADUATE