Key Responsibilities

Act as sr engineer to build, maintain and extend data warehousing for SSGA's business function which includes sales & marketing of its advisory products.

Develop, maintain, and support ETL processes for loading data from multiple data sources into a Redshift data warehouse

Maintain large, multi-terabyte data warehouse which includes performance tuning and data retention / purge processes

Research and troubleshoot data quality issues, providing fixes and proposing both short- and long-term solutions

Represents the team in planning and product meetings, effectively communicating the available platform features and constraints

Ability to participate in major incident management, production stability, etc as and when required.

Ability to lead a team of 5-6 engineers and act as a guide and mentor in the team

Primary & Secondary Skills

12 + years of overall IT experience with minimum 7+ years of experience as Data Engineering in Data warehousing (AWS preferred) and full life cycle implementation of Data Pipelines using Informatica and similar tools.

Strong design and development skills of Data Engineering with experience on AWS Glue Pipeline

Strong SQL skills to perform Data analysis exploration and transformation.

Strong hands-on Python skills to support data engineering process.

Strong Analytical skills to understand the business requirements and translate them into Technical specifications

Good exposure to AWS Data storage products like AWS S3 and AWS Redshift.

Good Understanding of Data Lake systems preferably with DataBricks

Good to have Business Intelligence / Analytics skills preferably with Tableau

Prior experience in the leading the Data Engineering team with size of 5 / 10.

Excellent verbal and written communication and should be able to work with all the stakeholders.

Experience on working in Agile project management practices

Exposure to code versioning tool GIT and project collaboration platform JIRA

Qualification & Certifications

B.E / BTech degree in Computer Science or related field

USP of the Role

The role would require the person to have a good function knowledge and a strong technical knowledge required to design ,develop and maintain the Data Engineering solution for a modern Datawarehouse.

Join us if you want to grow your technical skills, solve real problems and make your mark on our industry.