Data Analyst Apply Now.

Mi-Case; Northern (KY); Hybrid; USD 110,000 - 120,000; Full time

Job summary

Mi-Case is seeking a Data Analyst to map legacy data to Mi-Case requirements and develop conversion rules, with thorough documentation of data transformation steps. The role requires clear communication with the Project Manager, SMEs, developers, and QA to ensure data quality during migration.

Key duties include collaborating with application developers and SMEs to gather requirements, analyzing data structures, tracking progress, and resolving migration issues.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 4+ years of data analysis or related field with data migration focus.
• Proficient in SQL and database querying for extraction and validation.
• Excellent communication and cross-functional collaboration.
• Experience with data migration tools and methodologies (preferred).

Responsibilities

• Collaborate with Mi-Case Application Developers, Legacy System 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.

Skills

SQL

Data migration

Data analysis

Communication skills

Project coordination

Detail-oriented

Cross-functional teamwork

Education

Bachelor's degree in Computer Science/Information Technology

Tools

ETL Tools

Job description

Hybrid ( 3 days a week in Desert Ridge )

Company Background

Join us at Mi-Case, where we’re at the forefront of developing innovative public safety products and solutions. We take pride in delivering fully-integrated software and exceptional client support, making a real impact in communities. As part of our team, you’ll collaborate with passionate, talented colleagues and industry experts who are deeply committed to solving the unique challenges faced by our clients in the public safety sector. Together, we’re replacing outdated systems with cutting-edge, mobile-ready solutions that empower our clients to enhance public safety and achieve their goals.

Position Summary

We are seeking a skilled Data Analyst to analyze legacy data sources and Mi-Case data requirements, and to 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.

As a detail-oriented professional, 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.

Role:

• 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.

Minimum Years of Experience: 7 Years

Education and skills:

• Experience: 4+ years of experience in data analysis or a related field, with a focus on data migration projects.
• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience with data analysis, mapping, and transformation processes.
• Proficient in SQL and database querying for data extraction and validation.
• 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).
• Department of Corrections Technologies- ( Offender Management System )

Nice to Have:

• Knowledge of data governance and compliance best practices.
• Familiarity with ETL tools.

Job Types: Full-time, Exempt

Salary: $110,000-$120,000 per year