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 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: 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 Bachelors 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