Intermediate Data Analyst

Are we right for you...

We’re passionate about people and creating sustainable, safe and affordable public transit solutions to residents across BC. We are an organization that has a people-first approach and considers people first in every business decision that we make. We are part of the solution and what we do matters; from fighting climate change with battery electric buses, to affordability through cost effective transportation, to connecting remote communities, we bring the heart, soul and innovation to public transportation.

It’s an exciting time to be in the public transportation sector and we’re looking for a creative and passionate leader to join our team. Not only would you be joining an engaged organization, but you’d also get to enjoy flexible work arrangements, extended benefits and a pension plan as just a few of the benefits BC Transit employees are eligible for. Keep reading to find out if this role is meant for you!
 

What you'll be doing...

Reporting to the Manager, Enterprise Data & Analytics, the Intermediate Data Analyst supports and enhances the ability of business users across the organization to generate insights from data.

This is accomplished through the execution of tasks in several domains of data management including data governance, data architecture, data engineering, business intelligence and advanced analytics. The Intermediate Data Analyst is a strong data generalist and with support from senior members on the team, performs a key role in everything from designing and creating self-serve reports and BI models, to developing and sustaining secure and reliable data pipelines. The Intermediate Data Analyst is a champion for professional data management and promotes best practices, security, governance, and innovation across the enterprise data community.

This role requires a considerable level of professional data management experience, analytical ability and technical engineering knowledge. The Intermediate Data Analyst role also requires the ability to collaborate well, cover a broad spectrum of use cases and support business users from diverse subject areas with varying needs. 

To be successful in this role the Intermediate Data Analyst will have demonstrated previous successes in multiple areas of data management such as business intelligence, data engineering, data warehouse design, data operations and data governance. They should have technical proficiency in Python and or R in the context of data and analytics. In addition, they will be well versed in data governance and architecture concepts, including how to capture and manage real world entities and measures in digital analytical models. Experience with or understanding how to work with spatial data would be considered an asset.

For additional information about the full accountabilities of this position please review the Intermediate Data Analyst Job Description. 

What you'll bring to the table...

• Experience in one or more data management disciplines including, analytics, business intelligence, data architecture, data engineering, or data governance.
• One year to be proficient in the role. 
• Demonstrated experience using SQL or analytical languages (Python, R, Scala …) to ingest, manipulate, clean and prepare data for business intelligence, data mining, machine learning or other analytical processes.
• Experience designing and implementing data models for sustainable and scalable use in could data warehouses, data lakes, and business intelligence reporting.
• Demonstrated experience with distributed computing and cloud data platform technology, such as Spark, MS Synapse, MS Fabric, etc.
• Ability to support to project and initiative implementations from the lens of a technical data professional.
• Experience with GIS mapping software or spatial datasets would be an asset.
• Experience with analytics, reporting and data management in a public transit context would be considered an asset.
• Exposure to implementing and maintaining AI/ML models in production and how to manage their deployment using CI/CD and version control would be an asset.

We value lifelong learners and have found that a mix of any of the following credentials have set people up for success in this role in the past:

• Cloud Data Analytics or Engineering certification (Azure, Google, AWS, Cloudera, PowerBI) or equivalent
• GIS certification (GISP, ESRI) or equivalent
• Certified Data Management Professional certification (CDMP) or equivalent

What we'll bring to the table...

• Comprehensive medical and dental benefits to support you and your family, regardless of what life throws at you
• Membership in a “gold plated” defined benefit pension plan, meaning it’s the best in the Province and one of the best in the country; putting you in a strong position when it comes time to retire 
• Access to fitness and lifestyle centers to help you take care of your physical fitness and health
• Various programs that support employees such as an Employee Assistance Program and health and wellness initiatives and events aimed at fostering your mental health
• A complimentary employee bus pass (plus taxable dependent passes)
• A corporate learning and development program to help you in continuous career growth
• An employee recognition program where we all recognize each other's successes (not just your Leaders!)
• A social club that gives you access to events throughout Victoria
   

What next steps could look like...

• Interviews will be conducted in February, 2025. An assessment will be sent to shortlisted applicants in conjunction with their interview invitations
• An eligibility list for future full time regular and temporary full time vacancies may be established
• The position requires the completion of a Criminal Record Check or Vulnerable Sector Search.
• If you have a disability that requires an accommodation during any stage of our recruitment process, please let us know how we can assist you
• BC Transit is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities. If the organization identifies this position as a reasonable accommodation for an existing employee, all candidates will be notified as soon as reasonably possible