Job Title

Senior Data Analyst The Senior Data Analyst is a pivotal role responsible for leading the development and maintenance of complex business intelligence solutions that drive critical decisionmaking 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 cuttingedge data warehouse environment. Note: Due to business needs, this position is required to be fully onsite 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. PowerBI 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 PowerBI 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 PowerBI 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 Bachelor's degree in Computer Science, Statistics, Data Science, Business Analytics, or a closely related quantitative field. Master's degree is an asset. 7 - 10 years of progressive experience in data analysis and business intelligence, with a strong emphasis on complex report development in largescale enterprise environments. Demonstrated expertlevel experience with Microsoft PowerBI, including advanced data modeling, DAX, Power Query (M), and custom visualizations. Proven expertlevel experience with SQL for complex query development, performance tuning, and data manipulation, ideally within a data warehouse environment like Databricks. Extensive handson experience working with Databricks and Delta Lake architectures, specifically in developing goldlayer queries for BI consumption. Demonstrated experience integrating data from diverse enterprise systems, particularly within a manufacturing or projectdriven industry (e.g., ERP, PLM, Scheduling systems). Experience with Azure Analytics Services, including Azure SQL Data Warehouse and Azure Analysis Services, is highly desirable. Experience in a shipbuilding, heavy manufacturing, or largescale project management environment is a significant asset. Expert Data Modeling Skills: Deep understanding and practical application of star schema, snowflake schema, and other advanced data modeling techniques within PowerBI and data warehouses. Advanced SQL & Query Optimization: Exceptional proficiency in writing and optimizing complex SQL queries, stored procedures, and functions for large datasets. DAX & M Language Mastery: Ability to write highly efficient and complex DAX measures, calculated columns, and tables, as well as advanced Power Query (M) transformations. Data Architecture Understanding: Strong conceptual and practical understanding of data warehousing principles, ETL/ELT processes, and data lake concepts. Analytical & ProblemSolving Acumen: Superior analytical and problemsolving skills, with the ability to dissect complex business problems, identify underlying data issues, and propose innovative BI solutions. Business Acumen: Strong understanding of shipbuilding operations, project management methodologies (e.g., Earned Value Management), and financial reporting, allowing for effective translation of business needs into technical solutions. Communication & Collaboration: Excellent verbal and written communication skills, with the ability to effectively interact with business stakeholders at all levels, explain complex technical concepts, and present datadriven insights clearly and concisely. Autonomy & Proactiveness: Proven ability to work independently with minimal supervision, manage multiple priorities in a dynamic environment, and proactively identify opportunities for BI improvement. Attention to Detail: Meticulous attention to detail in data validation, report development, and documentation to ensure the highest level of accuracy and reliability. Why youll love working here This is a fulltime, permanent position. With multiple operations and longterm 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 a very competitive salary in line with the successful candidates experience. We also provide a bestinclass health and wellness benefits package for this position, including such things as full health care (e.g. unlimited physiotherapy), dental, vision, life insurance, medical leave coverage, parental leave coverage, childcare benefit partnership, wellness/fitness reimbursement for memberships or registration fees, and an Employee Family Assistance Program (EFAP). While reporting directly to the Vice President, Business Technology Solutions, you will manage your own portfolio of work and projects as a senior member of the team. This position qualifies for an optional hybrid work schedule. Parking is included and to assist those that are using transit, we operate a complimentary shuttle bus Monday through Friday with various pick up and drop off points around North Vancouver. The estimated salary for this position is $112,500 - $137,500. 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. About Us Seaspan Shipyards is one of North Americas most modern shipyards and unique in its ability to provide a complete range of services including new construction, conversion, refit, repair and lifecycle maintenance work for Canadas Coast Guard and Navy as well as commercial vessels including cruise ships and deepsea vessels. Seaspan Shipyards operations include Vancouver Shipyards, Vancouver Drydock and Victoria Shipyards. 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. Seniority level MidSenior level Employment type Full-time Job function Information Technology Industries Shipbuilding To learn more, visit our website: 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 for confidential support. We are committed to providing an inclusive and accessible environment. #J-18808-Ljbffr