Data Solution Architect

TransLink; Vancouver; On-site; CAD 90,000 - 120,000; Full time

Job summary

A public transportation agency in Metro Vancouver seeks a Data Solution Architect to design and implement data solutions. The role includes responsibilities for data management and collaboration with stakeholders, and requires a bachelor's degree and significant experience in the field. The ideal candidate has advanced knowledge of data architectures and leadership skills.

Qualifications

• Seven years of experience in a client-facing Data Solution Architect role.
• Ability to communicate complexities of technical programs.
• Advanced knowledge of coaching and mentoring teams.

Responsibilities

• Design and maintain customized data warehouse solutions.
• Collaborate on data management and architecture strategies.
• Lead the definition of enterprise standards for data solutions.

Skills

Advanced knowledge of Data Warehouse & Business Intelligence Architecture

Advanced experience with Microsoft Data Warehouse technologies

Advanced data modeling and design skills

Advanced interpersonal and communication skills

Advanced analytical and problem-solving skills

Solid leadership skills

Agile implementation experience

Education

Bachelor’s degree in Computer Science, Information Systems or related field

Tools

Microsoft SQL Server

SSIS

SSAS

SSRS

Power BI

Azure Synapse

Databricks

Data Factory

Erwin

Visio

Job description

Data Solution Architect

TransLink is 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.

Responsibilities

• 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.
• 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, anticipating 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, leading the team toward 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 – Bachelor’s degree in Computer Science, Information Systems or related field plus seven (7) years of progressive experience in a client‑facing Data Solution Architect role, ideally within IT services.
• Other Requirements –
  • Advanced knowledge of 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 with 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.

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. Accommodations are available on request for candidates taking part in all aspects of the selection process. For a confidential inquiry, simply email us at [e-mail].