Data warehouse engineer Jobs in Ottawa, ON

Job Description

As a Senior Data Engineer at Assent, you will play a critical role in advancing our data engineering practices and serving as a hands-on technical expert. You will contribute significantly to the vision and execution of our data engineering efforts, ensuring the development of secure, robust, scalable, and high-performing data platforms. Your role will involve driving key technical initiatives, collaborating on architectural decisions, and executing complex data engineering tasks to align our data infrastructure with Assent's business goals.

You will actively participate in the design, development, and implementation of sophisticated data solutions while offering mentorship and technical guidance to other engineers. Your contributions will have a broad impact across the organization as you champion best practices, innovate to enhance our data engineering capabilities, and work directly on the technical solutions required to advance our data systems.

Key Requirements & Responsibilities:

• Contribute to the strategic vision for data engineering and participate in the architectural design and development of new and complex data solutions, focusing on scalability, performance, and hands-on implementation.
• Design and implement new data systems and infrastructure to ensure the reliability and scalability of data systems by actively contributing to day-to-day engineering tasks.
• Influence key decisions regarding the data technology stack, infrastructure, and tools while actively engaging in hands-on engineering efforts in the creation and deployment of new data architectures and workflows.
• Set coding standards and best practices for the Data Engineering & Operations team, conducting and participating in code reviews to maintain high-quality, consistent code.
• Work closely with database developers, software development, product management, and AI/ML developers to align data initiatives with Assent’s organizational goals.
• Collaborate with team members to monitor progress, adjust priorities, and meet project deadlines and objectives.
• Identify opportunities for internal process improvements, including automating manual processes and optimizing data delivery.
• Proactively support peers in continuous learning by providing technical guidance and training on data engineering development, analysis, and execution.
• Be familiar with corporate security policies and follow the guidance set out by processes and procedures of Assent.

This is not an exhaustive list of duties. Responsibilities may be altered and/or added from time to time to meet business needs.

Qualifications

We strongly value your talent, energy and passion. It will also be valuable to Assent if you have the following qualifications:

• Degree in a related field and 7+ years of data engineering experience.
• Strong project management skills.and the ability to communicate complex concepts effectively.
• Proficiency in tools and languages, such as AWS, dbt, Snowflake, Git, R, Python, SQL, SQL Server, and Snowflake.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Adept at conveying complex data insights through a robust understanding of data management systems, warehouse methodologies, data quality standards, data modeling techniques, governance protocols, and advanced analytics.
• Familiarity with agile work environments and scrum ceremonies.
• Strong business acumen and experience in aligning data initiatives with business objectives.

Reasonable Accommodations Statement: To perform this job successfully, an individual must be able to perform the aforementioned duties and responsibilities satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform these essential functions. Assent is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Additional Information

Life at Assent

Wellness: We believe that you and your family’s well being is important. As a result, we offer vacation time that increases with tenure, comprehensive benefits packages (details vary by country), life leave days and more.

Financial Benefits: It’s not all about the money – well, it’s a little about the money. We understand that financial health is important and we offer a competitive base salary, a corporate bonus program, retirement savings options and more.

Life at Assent: There is purpose beyond your work. We provide our team members with flexible work options, volunteer days and opportunities to get involved in corporate giving initiatives.

Lifelong Learning: At Assent, curiosity is not only valued but encouraged. You will receive professional development days that are available to you the day you start.

At Assent, we are committed to growing and sustaining an environment where our team members feel included, valued, and heard. Our diversity and equal opportunity practices are guided and championed by our Diversity and Inclusion Working Group and our Employee Resource Groups (ERGs).

Our commitment to diversity, equity and inclusion includes recruiting and retaining team members from diverse backgrounds and experiences, and fostering a culture of belonging where all team members are included, treated with dignity and respect, promoted on their merits, and placed in positions to contribute to business success.

If you require assistance or accommodation throughout any part of the interview and selection process, please contact talent@assent.com and we will be happy to help.

We use AI to support parts of our recruitment process, such as note-taking and initial shortlisting based on job-related qualifications. AI does not make hiring decisions. All candidates will speak with a real person, and final decisions are always made by our recruitment team.