Senior Data Engineer (Full-Time, Term)

Senior Data Engineer

Location: This position will be located in our Winnipeg, Toronto, or Calgary office.

Type: This is a Full-Time, 12-months Term position.

Our organization:

Founded in 2017, Wellington-Altus Financial Inc. (Wellington-Altus) is the parent company to Wellington-Altus Private Counsel Inc., Wellington-Altus USA Inc., Wellington-Altus Insurance Inc., Wellington-Altus Group Solutions Inc., and Wellington-Altus Private Wealth Inc.—the top-rated* investment dealer in Canada and one of Canada’s Best Managed Companies. With more than $35 billion in assets under administration and offices across the country, Wellington-Altus identifies with successful, entrepreneurial advisors and portfolio managers and their high-net-worth clients. 

*Investment Executive 2024 Brokerage Report Card. 

The opportunity:

Reporting to the Senior Manager, Data Engineering, the Senior Data Engineer will have a company-wide view of the Data Engineering solutions that they build in this role, and they will consistently think in terms of automating or expanding the results company-wide.

The incumbent will have opportunity to help design and build our data application and infrastructure, while working with emerging technologies and associated AWS cloud services and influencing business intelligence solutions end-to-end: business requirements, workflow instrumentation, data modeling and ETL.

Additionally, the Senior Data Engineer will be an expert at designing, implementing, and operating stable, scalable, low-cost solutions to flow data from production systems into the data lake and into end-user facing applications. The incumbent will understand enterprise information systems, possess a strong business sense, and will lead a team to put these skills into action.

At Wellington-Altus, we’re proud to stand at the forefront of building out multi-platform solutions. The ideal candidate should be highly skilled in all aspects of Mobile solutions, including APIs, security and visualization.

Key responsibilities include:

• Designing, building and maintaining data pipelines in collaborating with the design team.
• Designing and maintaining data infrastructure and ETL processes based on industry standards and best practices.
• Recognizing and adopting best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
• Fostering an environment that emphasizes trust, open communication, creative thinking, and cohesive team effort.
• Designing architecture and Migrate Microsoft/SQL data systems to AWS cloud.
• Designing data models and automate manual processes.
• Maintaining AWS data infrastructure.
• Maintaining and enforcing quality and service standards, analyzing and resolving issues, identifying trends, and recommending improvements.
• Collaborating with the design tea
• Combine your technical expertise and problem-solving passion to work closely with project teams, turning complex ideas into end-to-end solutions that transform our clients’ business
• Contributing to the design, developing and delivering large-scale data for mobile adoption and transformation projects that delivers business value for clients.
• Conducting technical feasibility assessments, providing project estimates for the design, and development of the solution
• Providing technical inputs to agile processes, such as epic, story and task definition to resolve issues and remove barriers throughout the lifecycle of client engagements
• Creating and maintaining multi-platform solutions including hybrid environments using tools such as AWS/ DevOps/ Visual Studio and Cloud services
• Supporting team members in challenging situations (resource / release challenges, cross-team communication)
• Scheduling ad-hoc meetings to solve for disagreements or ambiguities in order to reduce risk of jeopardizing milestones and or artifacts
• Scheduling and chairing scrum ceremonies.
• Performing other duties as assigned.

The ideal candidate will possess:

• A bachelor's degree in computer science, information management or equivalent experience in a related filed(s).
• A minimum of 5-7 years' experience with data infrastructure in AWS cloud.
• A minimum of 4 years of experience and working knowledge of AWS stack such as S3, DMS, Glue, Lambda, Airflow. 
• A minimum of 4  years of experience with data engineering, including DevOps, APIs, DataOps, and MLOps.  
• Demonstrable experience with one or more of SQL, R, Python, Spark.
• Experience in building logical and physical design of data, relational/non-relational databases such as Snowflake/Redshift.
• Preferable to have experience with Pandas Libraries, Kafka or AWS Kinesis. Handling streaming data.
• Databricks, DBT or CI/CD tools like Git, CodeCommit,  Jenkins experience is an asset.
• Knowledge of database systems static data and real time with advanced troubleshooting skills.
• Demonstrate a high level of accountability, reliability, adaptability, and innovation in accomplishing day to day work and long-term goals.
• Excellent attitude and commitment to providing extraordinary service.
• Exemplary interpersonal and influencing skills; an ability to communicate effectively and work collaboratively, across multiple mediums (in-person, over the phone, and virtually).
• Excellent problem-solving, attention to detail, and organizational skills.
• A high tolerance for ambiguity; highly adaptive and able to manage a large volume of competing priorities.
• Strong critical thinking and written and verbal communication skills.

Conditions of employment:

• Must be legally eligible to work in Canada.
• A background check, satisfactory to the employer, may be required of the successful applicant prior to commencing employment.

Wellington-Altus is strongly committed to equity and diversity within its community and welcomes applications from women, racialized persons, Indigenous peoples, persons with disabilities, and persons of all sexual orientations and genders. All qualified individuals who would contribute to the further diversification of our organization are encouraged to apply.

If you require accommodation for the recruitment process, please let us know at the point of application.

To apply:

Click the Apply For This Job button to submit your resume, cover letter and salary expectations. You will be contacted if you are selected for an interview. More information about working at Wellington-Altus can be found on our website at www.wellington-altus.com.