Senior Technical Analyst – Advanced Analytics (Data Engineer)

YVR is made up of a team of diverse people who are working collaboratively to Connect BC Proudly to the World. Safety is at the core of everything we do; we’re innovative, fun, and we invest in our people. We’re a BC Top Employer for 14 years standing, with high engagement scores, an abundance of learning and development opportunities, and a holistic approach to wellness. And we’re looking for someone to join our team.

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 Analytic (Data Engineer) is responsible for determining the required strategy and technical architecture, leading technical decisions, leading projects, managing day to day operational activities, guiding other internal and external resources in project tasks and issue resolution, managing vendors, identifying opportunities for improvement, and presenting to senior management. The incumbent is expected to have broad and deep technical and analytical ability within their area of responsibility as well as strong communication skills.

Key responsibilities include: 

• Building the pipelines and processes required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure cloud services (e.g., Azure Databricks, Azure Data Factory, Azure Data Lake Storage) as well as building data products with analytics tools that utilize enterprise datasets to unlock actionable insights to enhance passenger experience and increase operational efficiencies.
• Developing processes and documentation for data collection, integration, and consumption as well as contributing to design and development of RESTful APIs that enrich operational applications with additional data sources and insights.
• Collaborating and delivering data products for advanced analytics and data science team members that enable them to build and optimize our digital products and machine learning models.
• Providing day-to-day support and technical expertise to both technical and non-technical teams including working with stakeholders at all levels to resolve operational issues with data products, and support operation of our data infrastructure.
• Identifying, designing, and implementing internal process improvements by automating manual processes, optimizing data delivery, and ensuring data infrastructures, pipelines, and processes are scalable, resilient, and performant.
• Collaborating with the Information Security team to implement best practices and recommendations that ensure security of our data sources and data platform.

Key qualifications include: 

• At least 10 years’ post degree experience designing, implementing, and supporting enterprise-data architecture and environments for medium to large sized organizations, with at least 5 years of advanced analytics and project management experience (senior level) supplemented by a Bachelor’s degree in Computer Science or a related field; or an equivalent combination of training and experience.
• Experience with virtual server platforms, storage devices, computer network resources, cloud computing, project, and vendor management, as well as mentoring junior resources. Familiarity with any of: Azure Functions, Infrastructure as Code, and SQL Server Data Tools is a plus.
• Advanced working SQL knowledge and experience working with relational databases.
• A strong background in technology with experience in data engineering, data warehouse development, or software development looking to move into the big data environment.
• Computer programming skills, Python, Java, JSON, HTML, SQL with experience with data integration using APIs as well as working experience with Azure, Databricks, Denodo, Snowflakes and Qlik would be preferred.
• Strong written and oral communication skills, strong project management skills (using waterfall and agile methodologies) and excellent documentation skills, including workflow documentation.

This position is open to both Vancouver Airport Authority employees and external applicants. Previous job performance will be taken into consideration for all internal candidates that apply for this position.

As part of our recruitment process, short-listed candidates may be required to participate in an assessment process.

Salary Range : $97,599 to $127,555 per annum, based on 37.5 hours per week. This is individually tailored to reflect your unique experience, qualifications and internal equity.

At YVR, your work experience goes beyond the paycheck. We support your personal and professional development, well-being, and a thriving work culture with generous vacation days, extensive health benefits, retirement savings matching, wellness programs, community engagement, commuting support, and continuous learning opportunities. Learn more at https://careers.yvr.ca/benefits.

YVR is more than just an airport. We connect our beautiful province and all it has to offer to the world. We are all leaders and trailblazers for change and innovation, so no matter the department or team you’re a part of, the work you do matters.

At YVR, we are flexible in everything we do. We will work together to find ways to deliver customer excellence that helps us all thrive.

Whatever your background and wherever you’re from, you belong at YVR. If you have any questions about accessibility or require any assistance applying, please reach out at careers@yvr.ca.