Senior Associate

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.

Creating business intelligence from data requires an understanding of the business, the data, and the technology used to store and analyse that data. Using our Rapid Business Intelligence Solutions, data visualisation and integrated reporting dashboards, we can deliver agile, highly interactive reporting and analytics that help our clients to more effectively run their business and understand what business questions can be answered and how to unlock the answers.

Sun Life Financial
Job Description of the Cloud Data Engineer Role
The role is of Cloud data engineer who has hands-on experience AWS DMS, Glue and
Athena. The candidate must be familiar at least in one Data ware housing concepts such as
ODS/Marts and must have done at least one end to end data processing pipeline designing.
Nice to have familiarity with AutoSys (job scheduler) and MDM (master data management).
He/she should be capable of handling the ETL design and implementation solely and would
work towards creating a positive and innovation friendly environment. The incumbent
would be responsible to create new capabilities.
Roles & Responsibilities
 Collaboration & coordination with multiple business partners.
 Develop pipelines to ingest data from different sources such as Database, delimited
files etc, do complex transformation and loading data into the S3.
 Develop Glue mapping and create Glue data catalogue.
 Implementation of Athena.
 Can optimize Informatica for performance improvements.
 SQLs capability for data analysis.
 Able to handle the end-to-end ETL or ELT pipeline solely.
 Ensuring the work is delivered on time and with quality.

Requirements
 Extensive practical experience in Information Technology and software development
projects of with at least 5+ years of experience in developing data warehouse
systems.
 Extensive experience in on cloud data technologies – in particular on AWS.
 Strong understanding of ETL and data warehouse concepts processes and best
practices.
 Good understanding of Big data and cloud technologies
 Possess a combination of solid business knowledge and technical expertise with
strong communication skills.
 Demonstrate excellent analytical and logical thinking.
 Good verbal & written communication skills and ability to work independently as
well as in a team environment providing structure in ambiguous situation.
Good to have
 Understanding of Insurance Domain
 Good understanding of Master Data Management and Data Governance.
 Basic understanding of data visualization tools like SAS VA, Tableau

 Good understanding of implementing & architecting data solutions using the AWS
components.

Mandatory Skill Set-AWS, Data Engineering
Preferred Skill Set-AWS, Data Engineering
Year of experience required-4 - 8
Qualifications-B.E / B.Tech / MBA

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date