Sr. Data Analyst

Description

The Senior Data Analyst is a pivotal role responsible for leading the development and maintenance of complex business intelligence solutions that drive critical decision-making for the National Shipbuilding Strategy and the Canadian Coast Guard and Royal Canadian Navy vessel construction projects at Seaspan Vancouver Shipyards. This role demands a high level of expertise in data modeling advanced querying and robust reporting to maximize the accessibility and business value derived from diverse organizational data. The Senior Data Analyst is also responsible for developing innovative analytics supporting advanced users and optimizing the entire data lifecycle from source to visualization within a cutting-edge data warehouse environment.

Note : Due to business needs this position is required to be fully on-site at 2 Pemberton Avenue North Vancouver.

What youll do

• Designs develops and maintains highly complex Power BI reports and dashboards incorporating advanced data modeling techniques to integrate data from disparate shipbuilding systems
• Works extensively with Databricks and Delta Lake developing optimized gold level SQL queries for Power BI models and performing advanced transformations directly within the data warehouse where appropriate.
• Identifies maps and implements data lineage and transformation strategies determining the optimal stage for data manipulation (data warehouse vs. Power BI data model) to ensure data quality performance and scalability.
• Leads the integration of data from various core shipbuilding systems including ARAS (PLM) Oracle P6 (Scheduling) IFS / JD Edwards (ERP / MRP) and future Oracle Cloud ERP ensuring a unified and coherent data model for comprehensive reporting.
• Develops sophisticated Power BI data models leveraging advanced DAX expressions and Power Query (M language) to create robust measures calculated columns and tables that meet complex business requirements.
• Collaborates closely with business stakeholders to understand complex requirements translate them into impactful data visualizations and iteratively refine reports to ensure maximum user adoption and actionable insights.
• Validates data sources complex transformations and analytical outputs against business rules and reference data to guarantee the accuracy completeness and integrity of all derived reports.
• Creates comprehensive documentation for business requirements data sources infrastructure complex data models and reporting governance processes to provide clarity and context for all data consumers.
• Acts as a Subject Matter Expert (SME) in Business Intelligence providing guidance training and knowledge transfer to team members and business users on advanced Power BI functionalities data best practices and data interpretation.
• Optimizes all stages of the data analysis process from data extraction and advanced querying to data modeling and visualization ensuring high performance and efficiency of all BI solutions.

What youll bring

Why youll love working here

The estimated salary for this position is $112500 - $137500. In determining final salary Seaspan considers many factors including the successful Candidates skillset and experience as well as position location and internal equity. The final base salary offer will be at the Companys sole discretion and presented as part of a competitive total compensation package.

#LI-MT1 #LI-ONSITE

Required Experience :

Senior IC

Key Skills

Data Analytics,Microsoft Access,SQL,Power BI,R,Data Visualization,Tableau,Data Management,Data Mining,SAS,Data Analysis Skills,Analytics

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 112500 - 137500