Senior Data Engineer (Glue/ETL/Data Modelling)

  • Hamilton
  • Sun Life
Job Description :We are looking for an experienced and high-performing individual to join our Data Engineering team in Corporate IT as a Sr Data Engineer. This senior technical role is responsible for the building, deployment, and support of data integration for BI reporting and analytic solutions, and application integration solutions. The Data Solutions & Engineering team in Corporate IT is an evolving group leading SLF in the application of leading-edge solutions against SLF business opportunities. Our team is diverse and inclusive and value the variety of background and experience in all aspects of the role. The team is involved in exciting projects using leading-edge technologies and leveraging our PWC, IICS and AWS Cloud based data platform for advanced analytics and data science.What will you do? Support and contribute to the construction and maintenance of robust and efficient data applications and reusable frameworksParticipate in all aspects of the development cycle from design and development to release planning and implementation of data systems.Apply best practices to all data engineering areas, including on premise, AWS, or a combination. This includes areas such as Operational Excellence, Security, Reliability, Performance Efficiency, and Cost OptimizationCollaborate with other data developers across various locations to ensure all code follows applicable standards and is efficient and easily maintainableSupport development of high-level solution options and estimates for project proposals, and detailed work estimates in support of assigned workDeliver solutions according to Systems Development Life Cycle (SDLC) methodology for either waterfall or agile projectsDevelop and manage effective working relationships with other departments, groups or personnel with whom work must be coordinated.What do you need to succeed?   Minimum 5 years of experience in developing solutions for data warehouse and system integrations using ETL tools and demonstrated experience using AWS-GLUEExperience designing and building development framework for python and GLUEExperience with data modeling using ERwin or PowerDesigner and the Data Model Driven ApproachExperience working with Oracle, DB2, MS-SQL server and essential to have demonstrated strong core competency in SQLExperience with full end-to-end data solutions, from data assessment needs to data structure building, to data modelling, and data visualizationsStrong understanding of AWS core data services and data service design patterns, or a proven desire and ability to learn AWS services (AWS Glue, S3, Lambda, Step Functions, RedShift etc.)Experience with Business Intelligence and Data Warehouse overall designExcellent collaboration skills and proven ability to adapt to challenges, coaching and mentoringAbility to work in a global multi-site environment and working in a matrix environment, onshore/offshore IT modeAbility to engage with a team of diverse skill sets and interface with peripheral technical teamsPreferred SkillsExperience with production implementation change management processesExperience with project management and software development life cycle/SDLC; Agile and Lean (3+ years)Excellent documentation skills including technical writing, Visio, PowerPoint, flowcharting (3+ years)Strong communication and analytical skills, including conceptual, requirements interpretation, solution creation and problem-solving abilitiesExperience with Big Data technologies (Hadoop, Cassandra, Redshift, etc.)What’s in it for you? A flexible work schedule, so long as it includes core working hoursCompetitive salaryBeing part of our journey in developing the next greatest digital experienceFlexible Benefits from the day you join to meet the needs of you and your family.Wellness programs that support the three pillars of your health – mental, physical, and financial.Membership in a highly collaborative, supportive, and productive teamAn extensive support system for continual learning including company-run courses and access to online learning platforms*Candidates must be eligible for Reliability Status Clearance which requires that they have lived and worked in Canada for the previous 5 consecutive years.