ETL Developer/ Data Warehouse Developer Job at Whopper Technologies, Canada

WHFVVjJKM3c3MS9tWWpoSVVXOEZ3NCtNd3c9PQ==
  • Whopper Technologies
  • Canada

Job Description

Job Title: ETL Developer/ Data Warehouse Developer

Location: Canada, Remote (onsite 3-4 times per fiscal year)

Seniority on the skill/s required on this requirement: Senior

Estimated Duration: 6 months with possible extension for another 24 months

Work authorization: any (candidate must be authorized to work in Canada)

Job Description:

We are seeking a highly skilled Data Warehouse / ETL Developer to support the Justice Information Management System project - a large-scale data integration initiative aimed at consolidating and redesigning multiple disjointed reporting data marts into a unified, efficient, and scalable Enterprise Data Warehouse (EDW). This role is critical in enabling better governance, availability, and reporting of court data through advanced data architecture and ETL processes.

The successful candidate will work closely with senior data architects, developers, and business stakeholders to design, build, test, and deploy ETL workflows that transform legacy data into actionable intelligence within a modernized reporting environment. This position requires strong experience in data modeling, star schema, and hands-on development of data pipelines and warehousing solutions.

Key Responsibilities:

  • Review and analyze existing data marts and legacy structures
  • Perform detailed data profiling and develop mapping specifications
  • Design, develop, and test ETL processes to load data into the new EDW
  • Build and validate dimensions and fact tables, including test queries and QA checks
  • Create database objects such as views, tables, and stored procedures for data examination
  • Stage and transform legacy data to align with the new data model
  • Investigate and resolve defects in data structures and pipelines
  • Collaborate with architects, SMEs, and developers to ensure data accuracy and usability
  • Document findings and contribute feedback during project close-out

General Application Development Duties:

  • Deliver quality application development and programming tasks throughout the system development lifecycle
  • Liaise with business units to gather and validate requirements aligned with strategic goals
  • Write clean, efficient, and well-documented code that meets functional and technical specifications
  • Contribute to full product deployments and provide support post-implementation
  • Analyze impacts of functional design on existing applications
  • Develop technical designs and database structures for complex applications
  • Maintain accurate and updated technical documentation
  • Conduct effective unit testing and ensure test coverage of critical components
  • Handle production support issues and fix bugs efficiently
  • Track and report work status, time spent, and progress updates
  • Support release management by coordinating schedules, documenting versions, and managing service requests

Requirements:

  • College or Bachelor degree in Computer Science or related field of study
  • Proposed resource has agreed to a Criminal Records Check and Enhanced Security Clearance including a credit check prior to commencement
  • Experience and technical knowledge of Microsoft SQL Server
  • Experience creating user training materials, technical documentation, and platform support resources
  • Experience working as an Application Developer within an enterprise IT environment
  • Experience working in a data warehouse/business intelligence or relevant data environment in either a development or support role
  • Knowledge of ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses
  • Experience with Agile methodology
  • Experience with smoke testing, unit testing, system testing, integration testing, regression testing, and user acceptance testing
  • Experience with User Acceptance Testing processes on large, complex, multi-stakeholder environments
  • Experience working in the public sector

Mindtris, a minority women-owned enterprise, is at the forefront of digital transformation, technology excellence, and business growth solutions. Specializing in talent mobilization and innovation, we are dedicated to enhancing customer experiences across diverse sectors such as Information Technology, Telecommunications, Healthcare, Engineering, and the Public sector. With a focus on deploying top-tier talent and fostering innovation, we empower businesses to thrive and excel in a rapidly evolving digital landscape, helping them reach new heights of success.

Mindtris is committed to fostering workforce diversity and is proud to be an equal opportunity employer.

Mindtris, a minority women-owned enterprise, is at the forefront of digital transformation, technology excellence, and business growth solutions. Specializing in talent mobilization and innovation, we are dedicated to enhancing customer experiences across diverse sectors such as Information Technology, Telecommunications, Healthcare, Engineering, and the Public sector. With a focus on deploying top-tier talent and fostering innovation, we empower businesses to thrive and excel in a rapidly evolving digital landscape, helping them reach new heights of success.

Mindtris is committed to fostering workforce diversity and is proud to be an equal opportunity employer.

Job Tags

Full time, Part time, Internship, Seasonal work, Remote work,

Similar Jobs

Compass Group

MGR, HUMAN RESOURCES Job at Compass Group

 ...5,000 - $80,000 Driven by our passion in the pursuit of hospitality and culinary excellence, Morrison Living has built community...  ...with an emphasis in associate relations, front line associate recruitment, training and diversity.You will contact expert regarding policies... 

FAIRMONT

Laundry Manager Job at FAIRMONT

 ...promotion opportunities. The sky is your limit. Salary Range: $85,000.00 to $95,000.00 Gross Annually. Job Description The Laundry s Manager is an integral role within our hotel, reporting to the Director of Housekeeping and overseeing the laundry operations by... 

D4C Dental Brands

Dental Assistant Job at D4C Dental Brands

 ...Description Now Hiring: Dental Assistant - Pediatric/Orthodontic Combo Location: Lone Star Pediatric Dental and Braces Schedule: Tuesday to Friday, 8:00 AM - 5:00 PM Status: Full-Time Travel Required: No Lone Star Pediatric Dental and Braces is... 

WeAssist.io

Internal - Part-time Content Production Assistant (PHILIPPINES ONLY) Job at WeAssist.io

**Hiring: Part-time - Content Production Assistant - Remote - $4,800 - $7,200/yr****&##127775; About us, WeAssist, the hiring team &##128161;**&##127757; **Led by a Founder Who Cares ** Reef Colman built WeAssist to empower individuals and create meaningful opportunities... 

Luxor Healthcare

RN- Registered Nurse/LPN- Licensed Practical Nurse- Weekends Job at Luxor Healthcare

 ...excellence and compassionate care to our residents. . We are looking for RN- Registered Nurse / LPN - Licensed Practical Nurse to join our...  ...a LPN - Licensed Practical Nurse looking to work close to your home with competitive pay? Rancho Rehab and Healthcare is the place...