The Application Developer - Intermediate will work on the Justice Information Management System (JIMS) 3.0 project, which aims to integrate and redesign several disjointed reporting data marts into an Enterprise Data Warehouse (EDW).
The project will replace existing IBM Cognos BI data marts with a well-integrated data warehouse to improve the availability, governance, and reporting of court data.
The role involves assisting in the planning, design, development, and testing of the Extract, Transform and Load (ETL) phases for data warehousing activities.
Responsibilities include reviewing existing data marts, performing detailed data profiling, analyzing and creating mapping specifications, and developing and testing ETL processes.
The developer will also create test queries, test dimensions and facts for quality assurance, and develop objects such as views, tables, and stored procedures.
Communication with data architects, other developers, and business subject matter experts is essential to provide analysis results and feedback at project closeout.
The role requires delivering applications programming and analysis tasks, providing application support, maintenance, and enhancements, while ensuring solutions meet current and strategic ministry needs.
Requirements:
Candidates must have a strong understanding of data models and design specifications, as well as experience with star schema and data warehouse development life cycle.
Proficiency in writing quality code that fulfills design requirements and passes code review with minimal defects is required.
Experience in configuring development environments and participating in the implementation of products into production is necessary.
Candidates should be able to analyze the technical impacts of functional designs on existing applications and deliver technical designs for medium to high application complexity.
The role requires maintaining technical documentation and identifying critical features of the system to focus testing efforts on.
Candidates must be able to efficiently handle and fix production defects and provide tracking and reporting of time and status on all work.
Strong communication skills are essential for liaising with business units and program areas to ensure solutions meet their needs.
Benefits:
The position offers the opportunity to work on a significant government project that aims to improve the efficiency and effectiveness of court data reporting.
There is potential for a maximum duration of extension of 24 months, providing job security.
The role allows for remote work, offering flexibility in the work environment.
The project will provide valuable experience in data warehousing and application development within a government context.
The successful candidate will have the chance to contribute to the creation of the Application Lifecycle Planning and coordinate release schedules, enhancing their project management skills.
