This role will assist in the planning, design, development, and testing of the Extract, Transform and Load (ETL) phases for the data warehousing activities within the Justice Information Management System (JIMS) 3.0 project. Additionally, the role is expected to help make sense of the large amount of legacy data through analysis and insight to ensure new data model correctly reflects business requirements. The success of this part of the project is critical to the overall project success for the Justice Business Intelligence unit and the GOA.

Working with Senior Data Architects, this role will primarily be as the Data Developer who understands data models and design specifications, understands star schema and data warehouse development life cycle, and is able to translate requirements and design specifications into queries and batch jobs that move data into a structured data warehouse. This Data Developer role will specifically focus on:

• reviewing existing data marts,

• performing detailed data profiling,

• analyzing and creating mapping specifications,

• developing and testing Extract Transform Load (ETL) processes,

• developing test queries for several Dimensions and Facts,

• testing of Dimensions and Facts for quality assurance,

• developing objects such as views, tables, stored procedures to examine data for business usability,

• staging the required data,

• addressing defects in newly developed dimension and fact tables,

• communicating analysis results with data architects, other developers, and business subject matter experts

• providing feedback and lessons learned at project close out.