Data Engineering Analyst

Reporting to the Manager, Data and Digital Enablement, the Data Engineering Analystwill collaborate closely with the Data Architect to ensure the technical support and high availability of Seaspan Marine Group's data infrastructure within Microsoft's Azure cloud platform.

This role will actively participate in maintaining and optimizing the organization’s data ecosystem. This includes a strong commitment to delivering exceptional client-centered service across all projects, spanning the creation, deployment, and implementation of new data products, as well as enhancements to existing infrastructure, solutions, and data operations processes.

Note : This position qualifies for an optional hybrid work schedule after 90 days of onsite work and onboarding. Employee will be subject to the terms of the Flexible Work Policy Agreement.

What you’ll do :

Data Infrastructure Support

• Assists in ensuring the technical support and high availability of Seaspan Marine Group's data infrastructure.
• Collaborates with the Data Architect in designing, implementing, and optimizing scalable data infrastructure solutions within Microsoft's technology stack.
• Contributes to monitoring, troubleshooting, and debugging issues affecting the performance of the data infrastructure and its assets.
• Actively participates in root-cause analysis for incidents and contribute to lessons learned.
• Supports the management and maintenance of the organization's data warehouse and lake house, ensuring its reliability, security, and operational efficiency.
• Contributes to enhancing existing infrastructure, solutions, and processes to meet technical standards and address business requirements.

ETL and Data Integration

• Assists in the development and implementation of end-to-end ETL processes for data procurement and integration.
• Collaborates with the team to continuously monitor, tune, and optimize the performance of data pipelines, databases, datasets, and their semantic layer.
• Participates in defining and implementing efficient data engineering workflows.

Data Modeling and Quality

• Supports best practices in data modeling methodologies for the design and implementation of effective datasets.
• Contributes to the establishment and enforcement of data quality standards and practices to ensure accuracy and reliability throughout the data life cycle.
• Assists in implementing data quality monitoring, alerting, and profiling processes.
• Collaborates with stakeholders to define and maintain data quality metrics and KPIs

Documentation and Communication

• Writes and maintain comprehensive documentation of the requirements collected, data infrastructure, data source catalogs, data models, ETL runbooks, and data quality standards.
• Works closely with stakeholders to understand use cases and ensure developed data products meet their needs.
• Assists in effective communication with technical and non-technical stakeholders, translating complex technical concepts into understandable terms.

Project Collaboration

• Supports the implementation of the Data and Digital Enablement Program’s roadmap.
• Participates in Scrum ceremonies as part of the Data and Digital Enablement team.
• Actively contributes on data engineering projects from conception to completion, ensuring alignment with business objectives.
• Works towards maintaining high standards in Seaspan Marine Group’s data engineering processes, aligning with industry best practices.

What you’ll bring :

• Bachelor’s degree in computer science, Engineering, Business Administration, or completion of a Post-secondary Diploma in Computer Science.
• Minimum 2-3 years of experience in cloud application implementation, application development, application integration, business analysis, or Relational Data modeling for OLTP and OLAP systems.
• Familiarity with designing and building ETL mechanisms in Azure.
• Proficiency in coding languages such as PowerShell, Python, SQL, Java, and Scala.
• Exposure to Spark and Databricks in Azure is an asset.
• Experience using IDEs such as VS or VS Code for development and Git for version control.
• Familiarity with Azure DevOps and version control practices.
• Understanding of data concepts, databases, data modeling, dimension modeling, change data capture, and star schema.
• Experience with physical and logical design of database architectures for relational databases, data warehouses, and data lakes.
• Knowledge of database optimization, data replication, database recovery, and performance tuning.
• Solid working knowledge in SQL Server and TSQL.

Why you’ll love working here :

• In addition to an annual bonus and pension plan matching, this role provides you a very competitive salary in line with the successful candidate’s experience.
• We also provide a best-in-class health and wellness benefits package for this position, including such things as full health care (.

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).

• Free on-site gym (insert in the benefits package sentence if this role is based out of Pemberton office)
• 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 $69,300 - $84,700. 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.

LI-JG1 #LI-HYBRID