Data warehouse engineer Jobs in Richmond, BC

Aviso:

At Aviso, we are dedicated to improving the financial well-being of Canadians. As a leading wealth management organization, we are committed to leadership, innovation, partnership, responsibility, and community. Working with talented and energetic professionals who exemplify our values every day, you will quickly notice that our people and dynamic ‘oneaviso’ culture sets us apart. If you are looking for interesting and challenging work, at a company committed to its people, find out more about what Aviso has to offer at www.aviso.ca.

The Opportunity:

We’re looking for a Data Engineer to join our Data and Analytics Group within the Technology Services Partners (TSP) department for 12 months.

Reporting to the Sr Director, Data Platform Delivery and Engineering, the Data Engineer is responsible for designing, building, and collaborating with Development, Security, and TSP Ops teams to deploy data and software products both on-premise and in the cloud.

Impact and Engagement: This role is pivotal in driving our data strategy forward, transforming raw data into actionable insights that will shape the future of our organization. As a Data Engineer, you will help in advancing our data maturity, ensuring that our data infrastructure is robust, scalable, and secure. Your work will directly impact our ability to make data-driven decisions, enhance operational efficiency, and deliver innovative solutions to our clients. By leveraging cutting-edge technologies and best practices, you will help us build a modern data and analytics practice that sets us apart in the industry. This is an exciting opportunity to make a significant impact and be at the forefront of our data transformation journey.

This can be a remote role, however for those who would like to come into the office our offices are at 1111 West Georgia Street, Vancouver B.C. and 151 Yonge St, Toronto, ON.

Who you are:

• Service – You put your clients’ needs first. You advocate service excellence, and work to deliver client-centric solutions, and proactively develop strategic partnerships that allow Aviso Wealth to become a trusted advisor and partner
• Execution – You are committed to achieving your goals and to succeed. This includes focusing on “getting things done”, as well as recognizing and taking advantage of opportunities as they arise. You are consistently looking for ways to improve your personal best and see value in continuous improvement. You take accountability for your actions and learn from mistakes
• Collaboration – You work collaboratively with others with the common goal of driving positive results. Making meaningful contributions to your team to achieve organizational goals is a priority. You proactively encourage collaboration, build trust and inclusion, and work to establish effective relationships both inside and outside of the organization

What your day looks like:

• Contribute technical expertise and collaborate with peers on solution design and implementation
• Participate in the data engineering lifecycle and support project delivery
• Apply architectural and design principles to improve performance, capacity, and scalability of data systems
• Collaborate with clients, stakeholders, and data engineers to determine data requirements and system impacts
• Contribute to cloud viability analysis, detailed work planning and estimation for major projects and complex assignments with broad scope and long-term technology and business implications
• Promote best practice and contribute to continuous improvement
• Create and maintain solution design documents, diagrams, and other materials related to the solutions deployed on premise and the Cloud
• Implement modern data and analytics practices using tools such as Databricks, Snowflake, Salesforce, Python, and SQL
• Design, develop, build, and maintain cloud-based applications and services on Azure

Requirements

Your experience and skills:

• Degree in Computer Science, Engineering, technical diploma, or other applicable software development work experience
• Knowledge and understanding of Software Engineering Concepts and Methodologies is required
• 3+ years of experience in data engineering or software development, ideally with exposure to technical leadership or mentorship
• Experience with designing and implementing highly available, scalable, and resilient solutions for cloud-native and non-cloud environments that meet Enterprise service level, security, and business continuity requirements
• Hands-on experience with various Azure Platform services including Azure Integration Services (Logic Apps, API Management, Service Bus & Event Grid), Application/Data Services (Service Fabric, Azure Functions, Azure SQL), Azure Active Directory and Azure Monitor / Application Insights
• Understanding of Azure IaaS, PaaS and Container based deployment models, configuration, and migration experience (including Azure Container instances and Kubernetes)
• Understanding of DevSecOps practices and tools, including Azure DevOps, Docker CI/CD, and Infrastructure-as-Code models
• Strong problem-solving, decision making, and conflict-resolution abilities
• Excellent written and oral communication skills, with the ability to establish and maintain effective working relationships with various levels of management, staff, and external clients
• Experience or Certification with AWS or Databricks an asset
• Experience in supporting wealth management and/or credit unions business would be an asset
• Fluent communication skills in English are required and bilingual skills in French are an asset

Benefits

Why Aviso?

At Aviso, you will find a dynamic and inclusive culture that rewards innovation and celebrates success.

Your Information

By submitting your application, you consent to the collection, use, and disclosure of your provided personal information for the purposes of assessing your qualifications and suitability for employment with Aviso. Your information will be handled in accordance with applicable Canadian privacy laws, including the Personal Information Protection and Electronic Documents Act (PIPEDA) and relevant provincial legislation. Your data may be shared with authorized personnel involved in the recruitment process and retained only as long as necessary to fulfill these purposes or as required by law.

Further information is available on the Privacy link on our Career Page – Privacy Policies

Equal Employment Opportunity

Aviso welcomes and encourages applications from all qualified individuals including persons with disabilities. If you require an accommodation, we will work with you to meet your needs in all stages of the hiring process.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.

No recruiters or agencies, please.

Company Overview:

Aviso is a leading wealth management and investment services provider for the Canadian financial industry, with approximately $145 billion in total assets under administration and management, and over 1,000 employees. We’re building a comprehensive, technology-enabled, client-centric wealth services ecosystem. Our clients include our partners, advisors, and investors. We’re a trusted partner for nearly all credit unions across Canada, in addition to a wide range of portfolio managers, investment dealers, insurance and trust companies, and introducing brokers. Our partners depend on Aviso for specific solutions that give them a competitive edge in a rapidly evolving, highly competitive industry. Our investment dealer and mutual fund dealer and our insurance services support thousands of investment advisors. Our asset manager, NEI Investments, specializes in investing responsibly. Our online brokerage, Qtrade Direct Investing®, empowers self-directed investors, and our fully automated investing service, Qtrade Guided Portfolios®, serves investors who prefer a hands-off approach. Aviso Correspondent Partners provides custodial and carrying broker services to a wide range of firms. We have offices in Toronto, Vancouver, Montreal, and Winnipeg. Aviso is backed by the collective strength of our owners: the credit union Centrals, Co-operators/CUMIS, and Desjardins. We’re proud to power businesses that empower investors.

A career with Aviso means being part of a group of talented, energetic professionals who live their values every day, and belonging to an organization dedicated to your success and career development. If you’re looking for interesting and challenging work, at a company committed to its people, apply to join our team.

Salary

This position is posted with an expected salary range of $80-100CAD per hour. Individual compensation packages are based on various factors unique to each candidate and the requirements of the position.