Senior Technical Analyst - Data Warehouse Developer

YVR is a place of connection, bringing together people, places and cargo while ensuring a safe and efficient experience for everyone. As part of our Innovation and Technology Group, your work will help deliver industry-leading travel technology to transform the passenger experience. From strategic planning to project execution, the work you do matters and will help improve our processes to make our airport work better for our communities.

Position overview

We have a full-time opportunity for an innovative Senior Technical Analyst – Data Warehouse Developer. This role will be part of the Advanced Analytics team, seeking a skilled Data Warehouse Developer with expertise in Azure Databricks technologies. If you are passionate about data, enjoy hands-on experience in data modelling, and have a successful track record of migrating from on-premises data warehouses to the cloud, we want to hear from you.

Key responsibilities include:  

• Lead the design and development of scalable, high-performance data warehouse and Lakehouse solutions using Azure Databricks, Microsoft Fabric, and hybrid/on-premises environments, leveraging best practices in data modeling and architecture.
• Design and implement end-to-end data pipelines (batch and streaming) using modern ELT frameworks, including medallion architecture (bronze/silver/gold), ensuring data quality, reliability, and scalability.
• Develop and maintain data architecture roadmaps, align platform capabilities with evolving enterprise architecture, governance standards, and business objectives.
• Collaborate with business and technical stakeholders to gather requirements and translate them into robust, maintainable data solutions, effectively communicating complex concepts to diverse audiences.
• Establish and enforce data governance, security, and quality standards, including data lineage, access controls, and compliance with organizational policies.
• Optimize data processing and storage performance, including cost management and query tuning across cloud and on-prem platforms.
• Implement and support CI/CD pipelines and DevOps practices for data engineering workflows, including version control, automated testing, and deployment.
• Prepare and maintain comprehensive technical documentation, including architecture diagrams, data models, and operational procedures.

Key qualifications include:

• Minimum bachelor’s degree in computer science, or equivalent, or comparable education with minimum 10 years’ post degree experience working with data warehouse and developing business intelligence solutions. 
• Knowledge and expertise with virtual server platforms, storage devices, cloud computing, relational databases and Data and Analytics. 
• Good experience with data prep, data integration (ETL), data modelling, along with proficiency in working with Azure Databricks, experience with SQL and Python
• Experience in project, vendor and relationship management including mentoring junior resources.
• Excellent English verbal and written communication skills, including ability to communicate at all levels of the organization, from end users to senior leaders.
• Expert level knowledge of technologies underlying assigned systems as well as expert level of critical thinking, analytical skills and troubleshooting capability.

Although not required, French language skills are an asset as we are committed to providing bilingual services to our visitors and passengers. This helps us meet federal language obligations while ensuring welcoming experience. Candidates who do not speak French are still strongly encouraged to apply. 

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 : $102,693 to $134,213 per annum, based on 37.5-hour work week. This is individually tailored to reflect your unique experience, qualifications, and internal equity.

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.