• Shape the pipelines and integrations feeding our RCT platform and our foundational voter datasets: the APIs, replication, federation layers, experiment randomization, and the failure modes that come with running data systems for hundreds of partner organizations on a non-negotiable political calendar • Extend our data platform and orchestration layer, and optimize it for cost, runtime, and reliability so it holds up during the elections, with millions of outreach attempts • Lead projects that span multiple systems and teams — scoping, designing, and driving them to real milestones • Hold the bar on quality — test and validate your own work, review teammates' code, and mentor through that review • Document and communicate — make your systems understandable to teammates, stakeholders, and non-engineers • Rotate through on-call and rapid response, including evenings and weekends during high-stakes moments like election cycles

• Define and maintain data architecture standards, principles, patterns, and best practices across key business and data domains. • Assess and rationalize critical data sources based on business value, quality, ownership, usage, sensitivity, lifecycle, and strategic importance. • Design conceptual, logical, and physical data models that support operational systems, analytical platforms, reporting, data products, and integration needs. • Establish reusable data structures, canonical data models, reference data patterns, and integration approaches to improve consistency across systems. • Define architecture patterns for data ingestion, transformation, storage, consumption, sharing, retention, and lifecycle management. • Partner with data engineering teams to translate architecture into scalable pipelines, curated datasets, data marts, reusable services, and platform-ready data assets. • Drive standards for metadata, lineage, business definitions, data ownership, data quality rules, documentation, and data observability. • Support governance practices by helping define how data should be classified, secured, cataloged, retained, and accessed. • Work with application and platform teams to improve interoperability across source systems, APIs, data warehouses, data lakes, lakehouses, and cloud platforms. • Guide teams in designing reusable and trusted data assets that can serve multiple consumption patterns, including reporting, analytics, automation, machine learning, and AI-enabled solutions. • Provide architecture guidance during solution design, data quality investigations, platform modernization, and data integration initiatives. • Communicate architecture decisions, tradeoffs, standards, and design recommendations clearly to technical teams and senior stakeholders. • All other duties as assigned

Role Description 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. 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. Qualifications - Degree in Computer Science, Engineering, technical diploma, or other applicable software development work experience - Knowledge and understanding of Software Engineering Concepts and Methodologies - 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 - Hands-on experience with various Azure Platform services - Understanding of Azure IaaS, PaaS and Container based deployment models - Understanding of DevSecOps practices and tools - Strong problem-solving, decision making, and conflict-resolution abilities - Excellent written and oral communication skills - 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; bilingual skills in French are an asset Requirements - 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 - 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 Benefits - A dynamic and inclusive culture that rewards innovation and celebrates success Company Description 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 partners, advisors, and investors. - We’re a trusted partner for nearly all credit unions across Canada. - Our investment dealer and mutual fund dealer and our insurance services support thousands of investment advisors. - Aviso Correspondent Partners provides custodial and carrying broker services to a wide range of firms. - We have offices in Toronto, Vancouver, Montreal, and Winnipeg.

• Own performance investigations across the product and data stack, moving from slow queries or poor user experiences to measurable root causes and production improvements • Design and evaluate data architecture changes • Partner with Product, frontend, and backend engineers to adapt product behavior to the characteristics of the underlying data through techniques such as request batching, debouncing, caching, pagination… • Develop representative benchmarks for important combinations of filters, datasets, and product workflows • Measure query latency, throughput, concurrency, and infrastructure consumption, with particular attention to datastore performance and cost (we use ClickHouse Cloud) • Evaluate the likely performance impact of upstream dataset changes before they reach production • Assess future product requests and recommend technical or product approaches that balance functionality, responsiveness, scalability, and cost • Prototype competing solutions, clearly communicate their tradeoffs, and validate the selected approach in production • Improve performance instrumentation, monitoring, and regression detection across data-powered product experiences • Establish reusable patterns and capabilities as the Data Product platform becomes a supporting layer for additional products and teams