Data Engineer

Manulife - Waterloo, ON (30+ days ago)

Apply Now

Are you looking for unlimited opportunities to develop and succeed? With work that challenges and makes a difference, within a flexible and supportive environment, we can help our customers achieve their dreams and aspirations.

Job Description

Data Engineer

We’re looking for someone who knows data: big data (but not necessarily “Big Data”), little data, clean data, messy data and all sorts of data in between. You’ve seen a little bit of everything and you enjoy working with it.

That’s not to say this is an analytics role, though. We’re not looking primarily for someone with experience analyzing or modeling data (though that wouldn’t be a bad thing to bring to the table) as much as someone with experience moving it around, tidying it up and pulling it all together so that people can make use of it. We have data spread all over the place and in all sorts of different formats, and we want you to help us do something about that.

Maybe you’ve worked as a Database Architect, a DBA, a Developer or an ETL Designer. In fact, bonus points to you if you’re able to check off more than one of those boxes. What’s most important, though, is that you’re willing and able to help us design, implement and populate data models that make it possible for us to get our most important data into a single location and into a consistent format. Come help us evolve in a data-driven powerhouse!

What Will I Be Doing?

You will become a key part of the life cycle of our data
You will become a Manulife data expert; you will know where our data is, how it moves around and who is using it
You will help with (and eventually lead) the design, development and implementation of new data processes, models and flows
You will work with business partners and subject matter experts to understand the context of our data; not just how it’s structured, but how real people use it (or should not use it) to make informed decisions
You will soon know better than anyone what sorts of headaches the users of our data may have and will be instrumental in brainstorming solutions to help make their lives better
You will be involved in many different things: today you might be doing some quick coding to generate a bunch of sample data, tomorrow you might be building data flows in Apache NiFi, building stored procedures for an SQL Server database, participating in a Proof of Technology session or locked in a room with a small “tiger team” tasked with solving an issue that’s just flared up
Does that sound a little vague? Good, because life is a little vague and so are the best jobs. We can’t guarantee you’ll be using a specific set of tools or techniques day to day because this isn’t that kind of job. You’ll need to be self-motivated, resilient and comfortable with uncertainty. You’ll have to learn on your feet from time to time, and occasionally even teach others as you’re learning. No one is going to ask you to be an expert in something you’ve never done before, but you’ll need to be the kind of person who gets excited about becoming an expert in something they’ve never done before. Show us what you’re capable of and learn a lot along the way!


This isn’t a junior role, so we’re looking for someone with at least 3-5 years of related work experience. You should have specific experience in some of these areas and the willingness to be trained (and to some extent train yourself) in any areas you’re lacking:

Databases: traditional (SQL Server/Azure SQL) or NoSQL - designing/modeling, administering, writing complex queries/stored procedures, SQL best practices
Coding/scripting (not necessarily as a Developer) –C#, Python
ETL/ELT/Data integration – SSIS, Sqoop, NiFi, Kafka, Storm, Spark, REST API
Data Streaming formats – JSON, Avro, XML
Various SLDC methods (i.e. agile, iterative, waterfall, etc.)

Bonus points for any experience with:
DevOps or Continuous Integration/Delivery tools and processes
cloud (IaaS/PaaS), Azure, PCF
data profiling and analysis
Hortonworks Data Platform / DataFlow
Am I Right for the Job?

We're looking for a passionate, motivated individual to join our team. Experience with any or all the tools and technologies mentioned is a huge plus, but don't let one or more of those list items deter you! If you're excited by this posting, we want to hear from you!

What about Perks?

Manulife has lots of perks including, but not limited to:
Competitive compensation
Retirement Savings Accounts including a RPP (Pension Plan), RRSP (Retirement Savings Plan), and TFSA (Tax Free Savings account)
Manulife Share Ownership Program with employer matching
Customizable Benefits Package including Health, Dental, Vision, and 100% of Mental Health expenses
Financial support for ongoing training, learning, and education
Monthly Innovation Days (Hackathons)
Wearing jeans to work every day
An abundance of career paths and opportunities to advance
A flexible work environment with flex hours, work from home arrangements, distributed teams, and condensed work week arrangements

If you are ready to unleash your potential, it’s time to start your career with Manulife/John Hancock.

About Manulife
Manulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better. We operate primarily as John Hancock in the United States and Manulife elsewhere. We provide financial advice, insurance, as well as wealth and asset management solutions for individuals, groups and institutions. At the end of 2018, we had more than 34,000 employees, over 82,000 agents, and thousands of distribution partners, serving almost 28 million customers. As of June 30, 2019, we had over $1.1 trillion (US$877 billion) in assets under management and administration, and in the previous 12 months we made $29.4 billion in payments to our customers. Our principal operations in Asia, Canada and the United States are where we have served customers for more than 100 years. With our global headquarters in Toronto, Canada, we trade as 'MFC' on the Toronto, New York, and the Philippine stock exchanges and under '945' in Hong Kong.

Manulife is an equal opportunity employer. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention and advancement and we administer all of our practices and programs based on qualification and performance and without discrimination on any protected ground. It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will consult with applicants contacted to participate at any stage of the recruitment process who request any accommodation. Information received regarding the accommodation needs of applicants will be addressed confidentially.