Data Analyst

Location: New Westminster, BC, Hybrid, minimum 40% on-site with occasional travel to other Greater Vancouver locations
Language: English, strong written and spoken communication skills for stakeholder collaboration and technical documentation
Duration: 6-month contract, full-time, with possible extension
Background Check Requirement: Not specified

About the Opportunity
Join a major public-sector transportation organization undergoing a large-scale enterprise asset management transformation. As a Data Analyst, you’ll help modernize how data is structured, governed, validated and used across operational systems, enterprise reporting and analytics platforms.

Reporting to a Reports Lead, you’ll work closely with business stakeholders, data engineers, architects, developers and project teams. Your work will directly support trusted reporting, stronger data quality and scalable analytics capabilities that enable better operational and strategic decision-making.

What’s In It for You
You’ll gain hands-on exposure to a complex enterprise data environment and a broad Microsoft Azure technology stack. This is an opportunity to contribute to meaningful transformation work while collaborating with experienced cross-functional teams and strengthening your expertise in enterprise data architecture, modelling, governance and analytics.

Your Responsibilities
• You’ll analyze enterprise data, business processes and data flows to identify anomalies, duplication and opportunities for improvement.
• You’ll design and maintain conceptual, logical, physical, dimensional and semantic data models.
• You’ll assess impacts of system and business changes across data warehouses, lakehouses, reports, dashboards and downstream data products.
• You’ll define data quality rules, monitoring processes, metadata, source-to-target mappings and enterprise data definitions.
• You’ll collaborate with business, architecture, development and analytics teams to translate requirements into scalable data structures.
• You’ll support data QA through mapping validation, transformation testing, reconciliation, UAT and defect root cause analysis.

Skills and Qualifications
• Hands-on enterprise data analysis and data modelling experience, including logical and physical modelling.
• Strong SQL knowledge is mandatory, with experience designing data warehouses.
• Hands-on experience with Azure Data Factory, Azure Databricks, Delta Lake, Azure Data Lake Storage, Azure Synapse, Spark, Power BI and Microsoft Fabric.
• Experience with data governance, stewardship, metadata repositories, data quality frameworks and enterprise data architecture.
• Knowledge of database design, systems analysis, SDLC methodologies and enterprise data standards.
• Experience preparing data test cases and scripts is highly desirable.
• Experience working in Scrum Agile environments and collaborating across business and technical teams.

Why Partner with Altis
If you’ve never worked with a staffing agency before, we make it easy. We work with top employers across Canada who have great jobs to fill, each vetted and verified by our team. When you apply for a job with Altis, we get to know you as a candidate and learn what your strengths are. Then, if you’re a solid match, we handle all the logistics, advocating for you as a candidate for the role, providing access to coaching and connecting you directly with the hiring manager. And rest assured, all our services are free of cost for candidates.

We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals.All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.