Job Application Developer - Remote / Telecommute. Remote, Edmonton

Job Description:

• The Data Developer will support the Justice Information Candidateagement System (JIMS) 3.0 project, a large-scale data integration initiative aimed at redesigning and consolidating disjointed reporting data marts into a unified Enterprise Data Warehouse (EDW).
• The role focuses on ETL design, data profiling, testing, and development activities that ensure accuracy, efficiency, and usability of the new reporting architecture.
• The successful candidate will work closely with senior data architects and business stakeholders to translate requirements into actionable data pipelines and structures.

• Review existing data marts and perform detailed data profiling.
• Analyze and create mapping specifications.
• Develop and test ETL processes for transforming and loading data.
• Write test queries for Dimensions and Facts.
• Conduct quality assurance testing of Dimension and Fact tables.
• Develop views, tables, stored procedures to support data validation and usability.
• Stage data as required and address defects in newly developed data structures.
• Communicate analysis results to data architects, developers, and subject matter experts.
• Provide support for production defect resolution.
• Write efficient, quality code and participate in code reviews.
• Maintain technical documentation and configuration for development environments.
• Ensure timely delivery of application features and functionality.
• Contribute to application lifecycle planning and release scheduling.
• Support implementation and maintenance of data solutions in production.

• College or Bachelor's degree in Computer Science or a related field.
• Experience with Microsoft SQL Server (5+ years).
• Experience creating user training materials and platform documentation (5+ years).
• Experience as an Application Developer in an enterprise IT environment (5+ years).
• Experience working in data warehouse/BI environments in development or support roles (5+ years).
• Strong knowledge of ETL processes and tools (5+ years).

• Experience with Agile methodology (3+ years).
• Experience with various testing methods including smoke, unit, system, integration, regression, and UAT (3+ years).
• Experience with UAT in large, multi-stakeholder environments (3+ years)
• Experience working in the public sector (3+ years).

• College or Bachelor's degree in Computer Science or a related field (required).