Data Analyst

About the Company

Founded in 1992, Mi-Case is the industry leader in fully integrated offender management software solutions and provides industry expertise and consulting within Criminal Justice and Public Safety systems. Mi-Case leverages a unique combination of technical, functional and industry specialization as well as partnerships with key software vendors to deliver maximum value add projects.

About the Role

As a Data Analyst, you will analyze legacy data sources and Mi-Case data requirements and develop detailed data mapping specifications. In this role, strong communication skills are essential for effectively conveying data requirements, identifying source data locations, and defining conversion rules. Proficiency in SQL and data analysis is required, as well as the ability to query data and provide thorough analysis. You will be responsible for documenting element level data conversion specifications and communicating progress and requirements clearly to key stakeholders, including the Project Manager, client system Subject Matter Experts, application developers, data engineers, and quality analysts. You will focus on gathering, analyzing, and mapping data for migration purposes, ensuring data quality and integrity throughout the process. Your contributions will be vital to the successful transition of data from legacy systems to new platforms.

Responsibilities

• Collaborate with Mi-Case Application Developers, Legacy System Subject Matter Experts (SMEs), and stakeholders to gather, document, and analyze data migration requirements.
• Analyze and map data structures from legacy systems to target platforms, making certain that data mapping specifications and transformation rules are precise.
• Document the steps for data transformation, cleansing, and validation to uphold high standards of data quality and integrity.
• Track migration requirements, mapping rules, and progress through tools like DevOps, keeping stakeholders fully informed.
• Serve as the main point of contact for clients regarding data migration queries, delivering clear and consistent communication to manage expectations and keep the process aligned.
• Log migration errors and any records that weren’t transferred, and investigate these issues to resolve them for future migration runs.
• Offer ongoing support to Project Managers, SMEs, developers, data engineers, and quality analysts by regularly communicating migration progress, updates, and troubleshooting any issues that arise.

Qualifications

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Training in Data Integration or Migration Analysis would be beneficial.

Required Skills

• Experience: 4+ years of experience in data analysis or a related field, with a focus on data migration projects.
• Experience with data analysis, mapping, and transformation processes.
• Proficient in SQL and database querying for data extraction and validation.
• Corrections (Offender management) systems and / or CJIS data experience, is a big plus.
• Excellent communication skills and ability to work collaboratively with cross-functional teams.
• Detail-oriented with a strong commitment to data quality.
• Strong analytical and problem-solving skills.
• Experience with data migration tools and methodologies preferred.

Preferred Skills

• Results - Consistently delivers required business results; sets and achieves achievable, yet aggressive, goals; consistently complies with quality, service and productivity standards and meets deadlines; maintains focus on company goals.
• Technical/Functional Expertise - Demonstrates and effectively applies depth and breadth of knowledge and skill in a technical or functional area.
• Professional Development - Demonstrates a commitment to professional development by proactively seeking opportunities to develop new capabilities, skills, and knowledge; acquires the skills needed to continually enhance his/her contribution to the company and to his/her respective profession.
• Communication - Respectfully listens to others to gain a full understanding of issues; comprehends written material; presents information in a clear and concise manner orally and in writing to ensure others understand his/her ideas; appropriately adapts his/her message, style, and tone to accommodate a variety of audiences.
• Problem Solving - Analyzes problems by evaluating available information and resources; develops effective, viable solutions to problems which can help drive the effectiveness of the company.
• Teamwork - Cooperates with others to accomplish common goals; works within and across his/her department to achieve shared goals; treats others with dignity and respect and maintains a friendly demeanor; values the contributions of others; ability to work effectively with people of diverse backgrounds and characteristics.
• Interpersonal and Organizational Professionalism – adept in displaying positive interpersonal skills and has self-awareness in being accountable and responsible. Recognizes areas for self-improvement and pursues professional development for continuous learning. Aligns actions to the mission and goals of the organization. Follows through on initiatives and meets deadlines, puts thought into appropriate professional-development and keeps skills updated.