Senior Data Engineer (AWS Glue/ETL/Data Modelling)
- Seniority: Senior (openness for Intermediate)
- Type: Remote or Hybrid across Canada
- FTE preferred, or 6 month Contract to start with FTE conversion after 6 months
- Location: Toronto, Waterloo/Kitchener, Montreal and surrounding areas strongly preferred
Our Client
Our client is a global leader within FSI, offering a comprehensive range of financial solutions, including insurance and benefits services tailored to individuals, families, and businesses worldwide. They emphasize comprehensive coverage, flexible options, and personalized solutions to meet the evolving needs of their clientele. Our client is committed to providing reliable insurance protection, including life, health, disability, and critical illness coverage, along with robust employee benefits packages for businesses. Their dedication to innovation, customer service, and financial stability makes them a trusted partner for insurance and benefits solutions, and a supportive workplace catering to accessibility and remote work options across Canada.
The Role
Our client is seeking an experienced and high-performing individual to join their Data Engineering team 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 is an evolving group leading in the application of leading-edge solutions against 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 frameworks
- Participate 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 Optimization
- Collaborate with other data developers across various locations to ensure all code follows applicable standards and is efficient and easily maintainable
- Support development of high-level solution options and estimates for project proposals, and detailed work estimates in support of assigned work
- Deliver solutions according to Systems Development Life Cycle (SDLC) methodology for either waterfall or agile projects
- Develop 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-GLUE
- Experience designing and building development framework for python and GLUE
- Experience with data modelling using ERwin or PowerDesigner and the Data Model Driven Approach
- Experience working with Oracle, DB2, MS-SQL server and essential to have demonstrated strong core competency in SQL
- Experience with full end-to-end data solutions, from data assessment needs to data structure building, to data modelling, and data visualizations
- Strong 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 design
- Excellent collaboration skills and proven ability to adapt to challenges, coaching and mentoring
- Ability to work in a global multi-site environment and working in a matrix environment, onshore/offshore IT mode
- Ability to engage with a team of diverse skill sets and interface with peripheral technical teams
- ASCII (American Standard Code for Information Interchange)
Preferred Skills
- Experience with production implementation change management processes
- Experience 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 abilities
- Experience with Big Data technologies (Hadoop, Cassandra, Redshift, etc.)