Data Analyst

Altis Technology; New Westminster; On-site; CAD 70,000 - 100,000; Full time

Job summary

Altis Technology in New Westminster, BC, is seeking a Data Analyst for a 6-month contract (full-time) as part of a large enterprise asset management transformation. You will analyze enterprise data, model data structures, and support trusted reporting across operational systems and analytics platforms.

Reporting to a Reports Lead, you will collaborate with data engineers, architects, developers and project teams to improve data quality and enable scalable analytics.

Qualifications

• Hands-on enterprise data analysis and data modelling experience.
• Strong SQL knowledge and data warehouse design experience.
• Experience with Azure data services and analytics tools.
• Experience with data governance and metadata repositories.
• Familiarity with SDLC and enterprise data standards.
• Experience in Scrum/Agile environments.

Responsibilities

• Analyze enterprise data, business processes and data flows to identify anomalies, duplication and opportunities for improvement.
• Design and maintain conceptual, logical, physical, dimensional and semantic data models.
• Assess impacts of system and business changes across data warehouses, lakehouses, reports, dashboards and downstream data products.
• Define data quality rules, monitoring processes, metadata, source-to-target mappings and enterprise data definitions.
• Collaborate with business, architecture, development and analytics teams to translate requirements into scalable data structures.
• Support data QA through mapping validation, transformation testing, reconciliation, UAT and defect root cause analysis.

Skills

SQL

Data modelling

Data governance

SDLC

Agile/Scrum

Tools

Azure Data Factory

Azure Databricks

Delta Lake

Azure Data Lake Storage

Azure Synapse

Spark

Power BI

Microsoft Fabric

Job description

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, youll help modernize how data is structured, governed, validated and used across operational systems, enterprise reporting and analytics platforms.

Reporting to a Reports Lead, youll 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.

Whats In It for You

Youll 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

• Youll analyze enterprise data, business processes and data flows to identify anomalies, duplication and opportunities for improvement.
• Youll design and maintain conceptual, logical, physical, dimensional and semantic data models.
• Youll assess impacts of system and business changes across data warehouses, lakehouses, reports, dashboards and downstream data products.
• Youll define data quality rules, monitoring processes, metadata, source-to-target mappings and enterprise data definitions.
• Youll collaborate with business, architecture, development and analytics teams to translate requirements into scalable data structures.
• Youll 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.

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.