Description

You will build and maintain data pipeline architectures and infrastructure to support large-scale data warehousing and analytics.

Responsibilities

• Design and maintain ETL/ELT pipelines into structured data formats using AWS and big data technologies.
• Develop multi-dimensional models including Star and Snowflake schemas, normalization, and de-normalization.
• Automate data ingestion, streaming, job scheduling, and monitoring to ensure connectivity between Lambda, Glue, S3, Redshift, and Power BI.
• Optimize data delivery and infrastructure scalability by automating manual processes and implementing data compression into Parquet.

Required Skills

• 5+ years of hands-on experience in data warehousing and OLAP systems.
• Expert-level SQL knowledge for query authoring, creating views, and writing stored procedures.
• Proven experience with AWS services, specifically 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 that meet functional and non-functional business requirements.
• Strong skills in job scheduling and automation.

Key Skills

Education

ANY GRADUATE