Data Engineering Analyst

Reporting to the Manager, Data Digital Enablement, the Data Engineering Analyst will collaborate closely with the Data Architect to ensure the technical support and high availability of Seaspan Marine Group’s data operations and cloud platform. This role will actively participate in maintaining and optimizing the organization’s data ecosystem. The Data Engineering Analyst demonstrates exceptional professionalism, initiative, and a proactive approach to challenges. They bring strong creative and analytical problem-solving skills, consistently deliver high-quality work within deadlines, contribute positively to team success, and embrace opportunities for continuous learning and growth.

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.
• Monitors, troubleshoots, and debugs issues affecting the performance of the data infrastructure and its assets.
• Develops root-cause analysis for incidents and contributes to lessons learned.
• Supports the management and maintenance of the organization’s data warehouse and lake house, ensuring its reliability, security, and operational efficiency.
• Enhances existing infrastructure, solutions, and processes to meet technical standards and address business requirements.

ETL and Data Integration

• Develop and supports the 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, and datasets.
• Actively 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.
• Supports the establishment and enforcement of data quality standards and practices to ensure accuracy and reliability throughout the data life cycle.
• Develops data quality monitoring, alerting, and profiling processes.
• Collaborates with stakeholders to define and maintain data quality metrics and KPIs.

Documentation and Communication

• Writes and maintains 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.
• Communicates effectively with technical and non-technical stakeholders, translating 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 towards 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 as a Data Engineer in an environment using the Azure technology stack.
• Familiarity with designing and building ETL mechanisms in Azure.
• Proficiency in coding languages such as PowerShell, Python, SQL, Java, and Scala.
• 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, dimensional modeling, and star schemas.
• Experience with physical and logical design of database architectures for relational databases, data warehouses, and data lakes.
• Knowledge of database optimization, disaster recovery, and ETL performance tuning.
• Solid working knowledge in Azure Data Factory, ADLS GEN2 and TSQL.
• Exposure to Spark and Databricks in Azure is an asset.
• Developing and maintaining integrations in Oracle Integration Cloud (OIC).
• Working knowledge of Data Engineering components in Microsoft Fabric.

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

The estimated salary for this position is $72,900 – $87,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.

#LI-HN1 #LI-HYBRID