SSE- AWS Data Engineer Lead

Position Description

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.

Must have: Python/PySpark, AWS (Lambda, Glue), SQL, Snowflake, CI/CD, light DataStage knowledge and SQL development, Data warehousing experience, Azure Datalake

Experience working in multi-platform environments.

Must demonstrate strong analytical and troubleshooting skills.

Must demonstrate the ability to balance both development and support roles.

Must demonstrate strong interpersonal skills, focus on customer service, and the ability to work well with other IT, vendor, and business groups.

Description

Huntington Bank is looking for a Lead ETL Developer Lead in our Enterprise Data Warehouse. In this role you will be part of a team working to develop solutions enabling the business to leverage data as an asset at the bank. As a Lead ETL Developer, you will be leading teams to develop, maintain and enhance code ensuring all IT SDLC processes are documented and practiced, working closely with multiple technologies teams across the enterprise. The Lead ETL Developer should have extensive knowledge of data warehousing cloud technologies.

If you consider data as a strategic asset, evangelize the value of good data and insights, have a passion for learning and continuous improvement, this role is for you.

Key Responsibilities

à Translate requirements and data mapping documents to a technical design.

à Develop, enhance and maintain code following best practices and standards.

à Create and execute unit test plans. Support regression and system testing efforts.

à Debug and problem solve issues found during testing and/or production.

à Communicate status, issues and blockers with project team.

à Support continuous improvement by identifying and solving opportunities.

Your future duties and responsibilities

must have skill:

Bachelor s degree or military experience in related field (preferably computer science) and 5 years of experience in ETL development within a Data Warehouse.

à Deep understanding of enterprise data warehousing best practices and standards.

à Strong experience in software engineering comprising of designing, developing and operating robust and highly-scalable cloud infrastructure services.

à Strong experience with Python/PySpark, DataStage ETL and SQL development.

à Proven experience in cloud infrastructure projects with hands on migration expertise on public clouds such as AWS and Azure, preferably Snowflake.

à Knowledge of Cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.

à Understand Authentication & Authorization Services, Identity & Access Management.

à Strong communication and interpersonal skills.

à Strong organization skills and the ability to work independently as well as with a team.

Preferred Qualifications

Required qualifications to be successful in this role

Good to have:

AWS Certified Solutions Architect Associate, AWS Certified DevOps Engineer Professional and/or AWS Certified Solutions Architect Professional

Experience defining future state roadmaps for data warehouse app

Experience leading teams of developers within a project.

Experience in financial services (banking) industry.

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team—one of the largest IT and business consulting services firms in the world.