Senior Technical Analyst (Data Engineer)

Vancouver Airport Authority; Vancouver; On-site; CAD 99,000 - 131,000; Full time

Job summary

An innovative organization seeks a Senior Technical Analyst specializing in Advanced Analytics to enhance operational efficiency and passenger experience. This role involves defining strategies, leading technical projects, and collaborating with various teams to develop data products. The ideal candidate will have extensive experience in data architecture and analytics, with strong technical skills in SQL and cloud services. Join a dynamic work environment that values personal growth and well-being, offering competitive benefits and a commitment to diversity and inclusion.

Benefits

Generous vacation

Health benefits

Retirement matching

Wellness programs

Community engagement

Commuting support

Learning opportunities

Qualifications

• 10+ years in enterprise data architecture with 5+ years in advanced analytics.
• Experience with cloud computing and project management.

Responsibilities

• Build data pipelines for extraction, transformation, and loading.
• Collaborate with data science teams for product development.

Skills

SQL

Data Engineering

Python

Project Management

Communication Skills

Education

Bachelor's in Computer Science

Equivalent Experience

Tools

Azure Databricks

Azure Data Factory

Azure Data Lake Storage

SQL Server Data Tools

Denodo

Snowflake

Qlik

Job description

YVR is a place of connection, bringing together people, places, and cargo while ensuring a safe and efficient experience for everyone.

Position overview

We have an opportunity for a permanent, full-time Senior Technical Analyst - Advanced Analytics (Data Engineer) in the Innovation and Technology Group. Reporting to the Manager, Enterprise Advanced Analytics, the Senior Technical Analyst - Advanced Analytics (Data Engineer) is responsible for defining strategy and technical architecture, leading technical decisions and projects, managing daily operations, guiding internal and external resources, managing vendors, identifying improvement opportunities, and presenting to senior management. The candidate should possess broad and deep technical and analytical skills and strong communication abilities.

Key responsibilities include:

1. Building pipelines and processes for data extraction, transformation, and loading from various sources using SQL and Azure cloud services (e.g., Azure Databricks, Azure Data Factory, Azure Data Lake Storage). Developing data products with analytics tools to utilize enterprise datasets for actionable insights to improve passenger experience and operational efficiency.
2. Creating processes and documentation for data collection, integration, and consumption, and contributing to the design and development of RESTful APIs to enhance operational applications with additional data sources and insights.
3. Collaborating with the data science team to deliver data products that support the development of digital products and machine learning models.
4. Providing technical support and expertise to technical and non-technical teams, working with stakeholders to resolve operational data issues, and supporting data infrastructure operations.
5. Designing and implementing internal process improvements through automation, optimizing data delivery, and ensuring scalability, resilience, and performance of data pipelines and processes.
6. Working with the Information Security team to implement best practices for data security.

Key qualifications include:

1. 10+ years of experience in designing and supporting enterprise data architectures, with at least 5 years in advanced analytics and project management, complemented by a Bachelor's degree in Computer Science or related field, or equivalent experience.
2. Experience with virtual server platforms, storage, networking, cloud computing, project and vendor management, and mentoring. Familiarity with Azure Functions, Infrastructure as Code, and SQL Server Data Tools is advantageous.
3. Advanced SQL skills and experience with relational databases.
4. Background in data engineering, data warehousing, or software development, aiming to transition into big data environments.
5. Programming skills in Python, Java, JSON, HTML, SQL, with experience in API data integration, and familiarity with Azure, Databricks, Denodo, Snowflake, and Qlik is preferred.
6. Excellent communication, project management (waterfall and agile), and documentation skills.

This position is open to both internal and external applicants. Previous performance will be considered for internal candidates.

Short-listed candidates may be asked to participate in assessments.

Salary Range: $99,945 to $130,621 per year, based on a 37.5-hour work week, tailored to experience and qualifications.

At YVR, we support your personal and professional growth, well-being, and a positive work culture through benefits like generous vacation, health benefits, retirement matching, wellness programs, community engagement, commuting support, and learning opportunities. Learn more at [website].

Who We Are

YVR connects our province to the world and fosters innovation and change. We value diversity and inclusion and are committed to accessibility and support for all applicants.