Data Solution Architect

Join to apply for the Data Solution Architect role at Trans Link

This range is provided by Trans Link. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

CA$/yr - CA$/yr

A career at Trans Link and our family of companies means working with people with a wide range of skills and perspectives, all teaming up towards a common goal: preserving and enhancing the region's world‑envied quality of life. Together, we connect the region and enhance its livability by providing a sustainable transit and transportation network, embraced by our communities and people.

At Trans Link we are dedicated to building a workforce that reflects the diversity of the communities in which we live. We’re committed to fostering an inclusive, equitable and accessible workplace, recognizing the unique value and skills every individual brings. Looking for a great place to work where your contributions are valued and you can make a difference in a vibrant city?

At Trans Link, one of BC’s Top Employers, you'll help make Metro Vancouver a better place to live, built on transportation excellence. Put your future in motion!

Primary Purpose

The Data Solution Architect designs and maintains Data Warehouse, Business Intelligence and Analytics solution and data architecture to meet Trans Link’s business needs and strategy for data driven decision making to align with Enterprise IT strategy, plans and business goals and wider Enterprise Architecture.

• Designs, implements and maintains customized data warehouse, business intelligence and analytics (DW/BI&A) technical solutions for clients by focusing on architecture-level decisions and analysis of their impact on the overall business goals and outcomes.
• Ensures DW/BI&A solutions are a fit for purpose and align with standards, policies and Enterprise Architecture direction and guidelines for technology solutions.
• Maintains and develops a scalable enterprise DW/BI&A data architecture, following best practices and Enterprise standards, balancing immediate short-term and long-term benefits.
• Consults and collaborates with business and technology stakeholders on data management and data architecture strategies, governance, practices and policies, so data can be leveraged as a strategic asset for decision making and innovation.
• Leads the definition of Enterprise standards and adoption of best practices for DW/BI&A solution design and development and data architecture.
• Collaborates with development and support teams to plan and implement DW/BI&A solutions.
• Performs quality assurance and acceptance of technical project deliverables.
• Provides technical leadership to the enterprise with regards to DW/BI&A program strategy, planning and decision making, advising on buy versus build, and outsource versus insource.
• Provides input on the dependency and sequencing of projects.
• Works with BI & Analytics management in maintaining technology and product roadmaps to judiciously manage the DW/BI&A platforms and solutions, managing technical debt, anticipate future needs and optimizing total cost of ownership.
• Works with Enterprise Architects, Solution Architects, Security Architects and Data Architects to contribute to technology architecture standards, practices, plans and governance.
• Stays abreast on new techniques, technologies and industry trends.
• Leads the team towards modern practices and techniques; establishes and participates in design reviews, regular or ad‑hoc architectural reviews ensuring correct interpretation of the data architecture framework.

Education and Experience

The requirements for this job are acquired through bachelor’s degree in Computer Science, Information Systems or related field plus seven (7) years of progressive experience in client‑facing Data Solution Architect role, ideally within IT services.

• Advanced knowledge of the theories, principles, practices and techniques pertaining to Data Warehouse & Business Intelligence Architecture, with demonstrated ability to communicate the complexities of technical programs (e.g. Microsoft Azure…