HYBRID onsite North Van - Senior Data Analyst to develop optimized Databricks Lake "gold" level SQL queries Power
Job in
Delta, BC, Canada
Listing for:
S.i. Systems
Full Time, Contract
position
Listed on 2026-02-13
Job specializations:
-
IT/Tech
Data Analyst, Data Engineer, Data Warehousing, Business Systems/ Tech Analyst
Salary/Wage Range or Industry Benchmark: 53.12 CAD Hourly
CAD
53.12
HOUR
Job Description & How to Apply Below
Position: HYBRID onsite North Van - Senior Data Analyst to develop optimized Databricks Lake "gold" level SQL queries for Power
S.i. Systems enterprise client is seeking a HYBRID onsite North Van - Senior Data Analyst to develop optimized Databricks / Delta Lake "gold" level SQL queries for Power BI models. You will be supporting their shipbuilding programs, including JSS, Polar, and MPI
. This requires you to work with S.i. Systems to get Reliability Status and potentially Controlled Goods clearance.
12 month contract, 40 hours / week
First 3 months - onsite every day in North Vancouver
3-12 months - hybrid work schedule to be negotiated
Candidate MUST be Cad citizen or have PR - and have lived in Canada nonstop for last 5 years - for Reliability status and Controlled Goods clearance requirements
Max rate $53.12 / hr as T4 contractor
MUST HAVE SKILLS
7+ years of business intelligence / data analytics experience with complex report development in large-scale enterprise environments.Power BI expert
: advanced data modeling,
DAX
, Power Query (M), RLS, and performance tuning for complex enterprise reports.Databricks / Delta Lake (Gold): build and optimize reusable Gold views; apply medallion patterns, views for BI consumption.SQL mastery
: author and tune complex SQL (incl. procs/functions) over large datasets; push heavy logic upstream to the warehouse.Data modeling & lineage: star/snowflake design, SCDs & historical snapshots; define where to transform (warehouse vs. Power BI) with documented lineage.Environment & governance: follow EA Dev → Test → Prod promotion, controlled Dev access, and change control/peer review on Gold objects.Certified datasets & performance: build Power BI datasets from Gold with agreed SLAs (refresh windows/page render), adopting EA patterns.Documentation: provide BRDs, source mappings, model diagrams, KPI definitions, and run‑books as per EA process templates.NICE TO HAVE
Azure analytics stack familiarity (Azure SQL DW / Azure Analysis Services);
Python/Spark helpful for transformations
Job 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.
What you'll do
Designs, develops, and maintains highly complex Power BI reports and dashboards, incorporating advanced data modeling techniques to integrate data from disparate shipbuilding systemsWorks 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.
Position Requirements
10+ Years
work experience
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
