- 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.
- Minimum 5 years of experience in developing solutions for data warehouse and system integrations using ETL tools and demonstrated experience using Power Center and IICS
- Experience with data modeling using ERwin or PowerDesigner and the Data Model Driven Approach
- Experience designing and building development framework for Power Center and IICS
- 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 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
- 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.)
- A flexible work schedule, so long as it includes core working hours
- Competitive salary
- Being part of our journey in developing the next greatest digital experience
- Flexible 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 team
- An extensive support system for continual learning including company-run courses and access to online learning platforms
Senior Data Engineer - Windsor, Canada - Sun Life
Description
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?
What do you need to succeed?
Preferred Skills
What's in it for you?
*Candidates must be eligible for Reliability Status Clearance which requires that they have lived and worked in Canada for the previous 5 consecutive years.