Data Warehouse Analyst - FTT

TransLink

TransLink, a leading organization committed to sustainability and diversity, seeks to connect the Metro Vancouver region with top-notch transit and transportation solutions. They aim to build a diverse workforce reflective of the communities they serve, offering a supportive and inclusive workplace. As a Data Warehouse Analyst, you will contribute to enriching the community's quality of life through efficient data management.

In this role you can expect to have the responsibilities:

• Collaborate with stakeholders to analyze business requirements.
• Design, develop, and implement enterprise data warehousing (EDW) solutions.
• Ensure data warehouse accessibility, functionality, integrity, and security.
• Support, maintain, and optimize the EDW process and related components.
• Research and apply new development technologies and tools for EDW strategies.

This role comes with the following benefits:

• Extended Health coverage.
• Transit Pass.
• Enrollment in the Public Service Pension Plan.
• Training and mentorship programs.
• Access to gym facilities.

This role requires you to have:

• Diploma in computer science or related field.
• Three years of recent experience in data warehousing, business intelligence, or analytics.
• Experience with various BI tools for information product development.

You would benefit from having:

• Experience with Spark (PySpark/Python) and Azure services.
• Proficiency in Power BI report creation and cloud exposure.
• Experience with data migration and ETL/ELT pipeline design.

TransLink champions employment equity and diversity, encouraging applications from Indigenous people, people of color, all genders, 2SLGBTQ+, and those with disabilities. Accommodations are available during the selection process.