Data Analyst II

Seaspan ULC; North Vancouver; On-site; CAD 91,000 - 104,000; Full time

Job summary

A prominent shipbuilding company in North Vancouver is seeking a Data Analyst II to develop key business intelligence metrics supporting defense vessel construction. Responsibilities include data validation, documentation development, and collaboration with end-users. The ideal candidate will have a degree in computer science and experience with business analytics tools. Competitive salary and comprehensive benefits included.

Benefits

Annual bonus

Health and wellness benefits

Pension plan matching

Qualifications

• Minimum 2 years of experience in business analytics or similar roles.
• Demonstrated experience with analytics solutions from data sourcing to end-user reporting.
• Strong knowledge of database structures and data processing techniques.

Responsibilities

• Validate data sources and ensure data quality.
• Develop documentation for business requirements and data sources.
• Build dataflows and datasets using Power Query, M, DAX & SQL.

Skills

Data validation

Data analysis

KPI development

Problem-solving

Communication skills

Education

Bachelor's degree in computer science or relevant field

Tools

Power BI

SQL

Azure Analytics Services

Microsoft Power Query

Databricks

Job description

Join to apply for the Data Analyst II role at Seaspan ULC

Join to apply for the Data Analyst II role at Seaspan ULC

Job Description

Data Analyst II

The Data Analyst II is responsible for developing and maintaining critical business intelligence metrics in support of the National Shipbuilding Strategy and the Canadian Coast Guard and Royal Canadian Navy vessel construction projects underway at the Seaspan Vancouver Shipyards. This position focuses on maximizing the accessibility of and business value derived from key organizational data. This includes both development of new analytics, and support of analytics users throughout the business as well as the development of innovative new methods of collecting, analyzing, presenting, or actioning data.

Note : Due to business needs, this position is required to be fully on-site based at 2 Pemberton Avenue, North Vancouver, BC V7P 2R2

What You’ll Do

• Validate data sources, transformations, and analysis against reference data to ensure quality, accuracy, and completeness of derived reports.
• Complete data discovery and mapping of shipyard enterprise applications alongside shipbuilding new construction teams.
• Develops documentation of business requirements, data sources, infrastructure, and reports to provide clarity and context for data consumers throughout the shipyard.
• Develop dataflows and datasets using Power Query, M, DAX & SQL
• Build dataset requirements, metrics, data / report definitions, and establish reporting governance processes.
• Optimizes and standardizes all stages of the data analysis process, from extraction through to modeling and visualization.
• Collects, validates, interprets, and organizes various types of data into relevant metrics and reports and / or summaries for designated business objectives.
• Supports ad hoc and other unplanned analysis and reporting needs as determined by management priority and business changes.
• Collaborates with and provides training and knowledge transfer to business end-users of reports and data sources.
• Coordinates with Functional Department and Program Resources to define, collect and report departmental, program and shipyards level metrics.
• Acts as a Business Intelligence Subject Matter Expert (SME) by supporting team members in the use and interpretation of data and understanding of metrics and reporting requirements.
• Understanding business objectives and providing ad hoc data extracts by working with business partners
• Effectively utilize the main data sources for reporting purposes within the business unit and maintain expert knowledge of all of these data sources

What You’ll Bring

Minimum 2 years of experience with business analytics, statistical analytics, KPI development and metrics reporting in a New Construction Shipbuilding & Project Management environment with quantitative, financial or metric analysis on multiple large-scale data warehouses.

Minimum bachelor's degree in computer science, Statistics, Business or a relevant field.

Demonstrated work experience with ground-up / full stack analytics solutions is an asset, including development of data sources, loading / transformation, analysis / modelling, reporting, and end user experiences.

Demonstrated work experience with Microsoft Power Query, M, DAX & SQL

Demonstrated work experience working with Databricks Data warehouse integration with Deltek Cobra, IFS MRP, Oracle Cloud MRP.

Proven experience working with data and databases, including working experience with programming languages and business intelligence tools such as SQL and Power BI, to build dataflows, datasets and analytical solutions and create visual insights and dashboards

Experience with Azure Analytics Services, including Azure Analysis Services

Experience with the Microsoft Power Platform, including Power Apps and Power Automate (Flow) is an asset

Well-developed understanding of database structure, business object models, and large-scale data processing techniques.

Familiarity and understanding of KPI analysis, performance measurement, financial systems and project scheduling / controls systems

Demonstrated understanding of heavy manufacturing operations and related data relationships

Demonstrated data analytic skills including proven ability to merge multiple data sources into meaningful information, review incomplete data, problem solve to fill in gaps and provide recommendation for meaningful solutions

Strong technical communication ability, including the ability to clearly and concisely document and communicate complex data structures and process maps.

Strong analytical and problem-solving skills

Excellent verbal / written communication and interpersonal skills for effective communication

Well-developed organizational skills, including ability to prioritize a variety of work assignments

Ability to work independently with minimal supervision and superior time management skills.

Why you'll love working here

This is a full-time, permanent position. With multiple operations and long-term projects, Seaspan employees enjoy job stability as we look ahead to build ships for decades to come .

In addition to an annual bonus and pension plan matching, this role provides you with a very competitive salary in line with the successful candidate’s experience.

We also provide the best-in-class health and wellness benefits package for this position, including things such as extended health care (i.e. paramedical services for massage therapy, speech therapy, mental health coverage, physiotherapy, and more), dental care, vision care, life insurance, medical leave coverage, parental leave coverage, childcare benefit partnership, $500 personal spending account, and an Employee Family Assistance Program (EFAP).

The estimated salary for this position is $91,437 -$103,400. In determining final salary, Seaspan considers many factors including the successful Candidate’s skillset and experience as well as position location and internal equity. The final base salary offer will be at the Company’s sole discretion and presented as part of a competitive total compensation package.

Language Requirement : English

NOC : 21223

For more information, please contact [e-mail]

About Us

Seaspan Shipyards is one of North America’s most modern shipyards and unique in its ability to provide a complete range of services including new construction, conversion, refit, repair and life-cycle maintenance work for Canada’s Coast Guard and Navy as well as commercial vessels including cruise-ships and deep-sea vessels. Seaspan Shipyards operations include Vancouver Shipyards, Vancouver Drydock and Victoria Shipyards.

To learn more, visit our website : www.seaspan.com

This position may involve defense articles and / or technical data regulated by the U.S. International Traffic in Arms Regulations (“ITAR”) and the U.S. Arms Export Control Act. In compliance with ITAR, the successful candidate will be subject to a security clearance through the Canadian Controlled Goods Program as regulated by the Controlled Goods Regulations and Defense Production Act. The successful candidate will be required to maintain their security clearance throughout their employment in this position.

Seaspan is committed to Employment Equity, supports diversity in the workplace, and encourages applications from all qualified individuals including, women, members of visible minorities, Indigenous persons, and persons with disabilities. If you require any accommodations at any stage of the recruitment process, please reach out to our Talent Acquisition team at [e-mail] for confidential support. We are committed to providing an inclusive and accessible environment.

Seniority level

Seniority level

Entry level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Industries

Shipbuilding

Referrals increase your chances of interviewing at Seaspan ULC by 2x

Burnaby, British Columbia, Canada $68,000.00-$85,000.00 2 weeks ago

Surrey, British Columbia, Canada 1 week ago

Coquitlam, British Columbia, Canada 1 week ago

Burnaby, British Columbia, Canada 3 days ago

City of Langley, British Columbia, Canada 3 days ago

Online Data Analyst (Work from Home / Freelance)

Surrey, British Columbia, Canada 4 days ago

Online Data Analyst (Work from Home / Freelance)

Burnaby, British Columbia, Canada 5 hours ago

Freelance Online Data Analyst - Canada (English)

Burnaby, British Columbia, Canada 2 weeks ago

Freelance Online Data Analyst - Canada (English)

Freelance Online Data Analyst - Canada (English)

Richmond, British Columbia, Canada 2 weeks ago

Freelance Online Data Analyst - Canada (English)

Surrey, British Columbia, Canada 2 weeks ago

Burnaby, British Columbia, Canada 5 days ago

Langley, British Columbia, Canada 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr