Data Solutions Developer

J.D. Irving, Limited; Saint John; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading company in the data solutions sector is seeking a Data Solutions Developer in New Brunswick. This role involves developing data pipelines, ensuring data integrity, and collaborating with a team to enhance the company's data infrastructure. Candidates must have a Bachelor’s degree in a related field and relevant experience with various ETL tools and Azure services.

Benefits

Continuous learning opportunities

Collaborative work environment

Qualifications

• 2+ years experience with DWH/ETL tools and data warehouse design.
• Familiarity with Azure Data Services and CI/CD practices.
• Controlled goods and security clearance required.

Responsibilities

• Develop and maintain data pipelines in Azure Synapse and Fabric.
• Integrate and transform data from diverse sources.
• Participate in project planning and code reviews.

Skills

Attention to detail

Problem solving

Interpersonal skills

Team player

Customer focused

Technically inclined

Process oriented

Strong verbal skills

Strong written skills

Results driving

Education

Bachelor’s degree in computer science, IT or related field

Tools

Wherescape RED

Data Manager

Data Stage

Spark

Azure Data Services

IBM Cognos Suite

Power BI

Azure DevOps

Git

GitHub

Job description

The Data Solutions Developer will be a collaborative member of the Data Solutions and Data Engineering team who create value by building and maintaining data infrastructure and architecture enabling business professionals to derive meaningful insights. This is a critical resource whose main responsibility is modelling, ingesting, and transforming data from a variety of sources into a high integrity data foundation supporting the needs of JDI’s diverse businesses for years to come.

This position requires full-time on-site presence.

All successful applicants must meet requirements for Canadian Controlled Goods Program (CGP), Canadian Government Security clearance, and U.S. International Traffic in Arms Regulations (ITAR).

Qualifications

• Education Required: Bachelor’s degree in computer science, IT or related field

• 2+ year experience supporting 2 or more DWH/ETL tools such as Wherescape RED, Data Manager, Data Stage, Spark etc.

• Familiarity with Azure Data Services (e.g., Data Lake, Data Factory, Synapse)

• Exposure to CI/CD practices and version control (e.g., Git, Azure DevOps, GitHub)

• Controlled goods and security clearance is required for this posting

• 2+ years experience designing on premise or Cloud Data Warehouses and Data Models

• Knowledge of IBM Cognos Suite of Products is an asset

• Attention to detail, problem solving skills, interpersonal skills, team player

• Customer focused: motivated by inspiring others to do things differently

• Technically inclined, process oriented and driven by a natural curiosity

• A continuous learner: acquiring new skills is second nature

• A practiced communicator with strong verbal, written, and interpersonal skills

• Results driving with the ability to explain complex concepts intuitively

Bonus:

• Experience in Power BI

• Certifications in Microsoft Synapse or Fabric

Responsibilities

• Developing and maintaining data pipelines and orchestration worflows in Azure Synapse and Fabric

• ETL development and maintenance for on premise data stores and warehouses

• Integrating and transforming structured and semi-structued data from diverse sources using Spark, PySpark, SQL, and native tools

• Contributing to data lakehouse and warehouse design using delta lake, Synapse, and Fabric Lakehouses

• Debugging and Troubleshooting, Monitoring ETL's and providing On-Call support

• Participating in project planning, estimations, and code reviews as part of a collaborative delivery team

• Environment and platform management for data and analytics platforms