Data Solution Architect

Marketing Statement
A career at TransLink 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 TransLink 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 TransLink, 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

Responsibilities
PRIMARY PURPOSE

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

Key Accountabilities
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.

Qualifications
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.

Other Requirements
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 technologies, Kimball methodology, modern data warehousing).

Advanced experience implementing Microsoft Data Warehouse and BI technologies, both Cloud and on-prem (SQL Server, SSIS, SSAS, SSRS, Power BI, Azure Synapse, Databricks, Data Factory, etc.)

Advanced experience of data modeling and design software, such as Erwin and Visio.

Advanced knowledge of coaching and mentoring teams on Data Warehouse & Business Intelligence Architect concepts and methodology.

Advanced interpersonal and communication skills to provide specialized guidance and expertise to managers, staff and customers; and to develop and manage critical relationships at all levels in the enterprise.

Advanced analytical and problem-solving skills to handle conflict resolution, facilitating discussion and alternatives of different approaches.

Solid leadership skills with ability to manage and influence direct or indirect reporting staff, and to provide specialized guidance and expertise to all levels of the organization.

Solid planning, organization, and time management skills with strong ability to organize competing priorities.

Agile implementation experience and azure certification is an asset.

Industry recognized certifications are assets.

Other Information
Recruitment Process: An applicant will be required to demonstrate their suitability for this position by meeting the minimum level of qualifications and experience in order to be invited into the selection process. A standard interview format will be used including general, scenario and behavioural descriptive interview questions.

This position will be participating in the HRDT (HR Digital Transformation) Program and the replacement of our Human Resource Management System (HRMS). The HR Digital Transformation Program will transform HR services through the redesign of business processes, enabled by the implementation of a new fully integrated HRMS for self-service, automated workflows, and real-time data analytics. This program will re-envision and redesign HR business practices and processes to modernize HR services and improve the end user experience.

Work Schedule
37.5 hours per week.

Work Designation
Hybrid

This position offers the flexibility of working both on-site and remotely within B.C.

Rate of Pay
The salary for this position ranges from $107,200 - $160,800 per annum. Actual salary offered will be based on education, experience, skills, and qualifications as they relate to the role.

We aim to provide competitive pay that reflects your professional background and expertise. We want to ensure our offer will align with your strengths considering experience, skills, and internal equity to offer a fair and equitable salary. The Total Compensation Package, which includes Extended Health, Dental, Transit Pass and enrollment in the Public Service Pension Plan as well as other employment offerings will be discussed in detail as your application progresses.

How To Apply
Please click the 'Apply' button at the top right corner of the page or go to to apply for this position and view instructions on the process.

INSTRUCTIONS: Please save your (1) cover letter, and your (2) resume as one pdf document prior to uploading your application on-line.

Posting Date: July 09, 2025

Closing Date: Open until filled

Please note that only those short listed will be contacted.

Having trouble applying? Please view the System Requirements & FAQ's by going to

Equal Employment Opportunity
TransLink is committed to employment equity and building a diverse workforce, representative of the customers we serve and the many communities in the Metro Vancouver region. We welcome and encourage Indigenous applicants, people of colour, all genders, 2SLGBTQ+ and persons with disabilities to apply. Learn more about TransLink's commitment to equity, diversity and inclusion.

Accommodations are available on request for candidates taking part in all aspects of the selection process. For a confidential inquiry, simply email us