Sql dba Jobs in Kitchener, ON

Join us at Manulife and be part of a team that strives for excellence, where your efforts will directly contribute to our success. Here, your work will have an important impact, andyou’llbe empowered to make decisions that improve our marketing strategies and customer experience.

As a Data Engineer at Manulife, youwouldplay a critical role in the development and maintenance of the company's data systems and architecture. You would collaborate with other highly skilled data engineers, dataarchitectsand governanceteamin designing, developing, and deploying data pipelines, ETL processes, and other data integration solutions to extract, transform, and load data from various sources into Manulife's data warehouse.

This Data Engineer role is essential for driving efficiency and innovation within our organization. By developing andmaintainingautomation, this position helps streamline operations and improve efficiency, contributing to our mission of delivering high-quality products and platform services. This role is integral to our goal of continuous improvement and operational excellence.

Position Responsibilities:

• Design, develop, andmaintainscalable ETL/ELT pipelines using Azure Data Factory, Azure Databricks, and other relevant services

• Develop andmaintainthe company's data architecture, including data models, schemas, and data dictionaries.

• Integrate data from various sources, ensuring data quality and consistency, and prepare it for analytical and operational use

• Follow consistency of data governance policies and processes to ensure data security, privacy, and compliance.

• Collaborate with other data professionals, including data scientists, analysts, and business team members, to understand data requirements and develop solutions to meet those needs.

• Stay up to date with the latest tools and technologies and see opportunities to enhance Manulife's data infrastructure.

• Ability to learn and implement best practices of big data and cloud computing to ensure solutions are scalable, efficient, and effective.

Required Qualifications

• 4 or more years of relevant industry experience as a Data Engineer.

• Experience building and operationalizing data pipelines in Microsoft Azure using Azure Data Factory and Azure Databricks.

• Experience implementing and supporting data governance solutions using Databricks Unity Catalog, including metadata management, data lineage, auditing, fine-grained access controls, data discovery, and secure data sharing across enterprise data environments.

• Experience automating data pipelines and familiarity with DevOps and CI/CD pipelines.

• Strong knowledge of Microsoft Azure services (SQL, ADLS Gen2, ADF, Databricks, Synapse, SQL Server) and designing scalable data ecosystems.

• Strong understanding of data warehousing concepts and relational data modeling.

• Experience withprogramming languages such as Python, SQL, Java, and/or Scala.

• Understanding ofAgile Scrum methodologies and experience working within Agile teams.

• Experience in data processing, performance tuning, monitoring, and capacity planning.

Preferred Qualifications:

• Excellent communication and interpersonal skills

• Excellent analytical, problem solving and solutioning skills

• A capacity for constant learning from both success and failure,remainingopen to change and continuous improvement

• Familiarity with production release and operational support model

• We’llempower you to learn and grow the career you want.

• We’llrecognize and support you in a flexible environment where well-being and inclusion are more than just words.

• As part of our distributed team,we’llsupport you in crafting the future you want to see!

The role being advertised is an existing vacancy.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit .

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. 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, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact .

Referenced Salary Location

Waterloo, Ontario

Working Arrangement

Hybrid

Salary range is expected to be between

$86,100.00 CAD - $136,100.00 CAD

Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are applying for this role outside of the primary location, please contact for the salary range for your location.

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact for more information about U.S.-specific paid time off provisions.

We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our .