Required Skills: Business analyst, Data Cleansing and migration plans, Python, Julia, Database Administrator

Job Description

Job Role: Business Analyst
Duration: 6 months+

Location: Lansing, MI Onsite Local only

Interview: Video
 

Note:

ALL CANDIDATES SHOULD INCLUDE 3 PROFESSIONAL REFERENCES WITH THEIR SUBMISSION (INCLUDING THE REFERENCES NAME, POSITION, PHONE NUMBER, AND EMAIL ADDRESS). PLEASE INCLUDE THIS AT THE BOTTOM OF THE RESUME.

NEW Requisition (MDOC EAMP Project) – Business Analyst

Short Description: Among other things, this project resource will work with the Michigan Department of Corrections to review, analyze, evaluate, validate, organize, coordinate, and lead MDOC, Agency Services, and DTMB teams to cleanse, and migrate legacy system data to a new enterprise-level software solution replacing numerous aging legacy systems.

Complete Description: Among other things, this project resource will review, analyze, evaluate, validate, organize, coordinate, and lead the activities of MDOC, Agency Services, and DTMB teams to cleanse, and migrate legacy system data to vendor hosted SaaS sophisticated enterprise-level software suites. This resource must be experienced in coordinating and communicating the efforts of multiple groups of technical and business groups (e.g. enterprise architecture analysts, database administrators, data scientists, business analysts, ETL developers, business subject matter experts, quality assurance and testing resources, and end users) in conjunction with third-party software vendors. This project resource will also be responsible for using Azure DevOps to track all assigned tasks. This position will work within DTMB Agency Services and report to the manager leading the appropriate team.

Demonstrable leadership and communication skills will be a highly desired skill set. A special emphasis will be placed on leadership and communication skills required to ensure clear, concise, and correct data cleansing and migration requirements; and design, development, testing, and deployment activities are completed by the technical and business teams. Data cleansing and migration activities must be completed prior to the project’s quality assurance team conducting large-scale testing efforts.

This position has a high probability of being extended past the end date listed above.

Additional Responsibilities: Preform additional business analyst duties as assigned.

Please note: We are looking for a true business analyst as opposed to a data migration developer.

Skills :

Required Skills

Experience in coordinating and leading multiple technical and business teams with data cleansing and migration efforts within the context of a large software implementation project. - 5+ years

Experience documenting data cleansing and migration plans, and explaining such plans to technical teams, business teams, and vendors. - 5+ years

Experience working with information technology teams while implementing new processes involving new software. - 3+ years

Experience using enterprise data cleansing and migration tools. - 5+ years

Experience understanding and creating relational database schema, SQL, formal descriptions of data, data structures, and data flow diagrams, entity relationship diagrams, data dictionaries, data dependencies, and data relationships. - 5+ years

Experience defining and enforce data standards, procedures, and guidelines to ensure data integrity, dependability, quality, and usability through the use of appropriate security, verification, and data management practices. - 5+ years

Experience using Microsoft Office tools and Azure DevOps for documenting data cleansing and migration plans. - 4+ years

Expert verbal and written communication with client management, technical team, project management, business management, and business staff in English. - 8+ years

Experience in identifying data cleansing and migration risks and assisting in the resolution of project issues. - 5+ years

Experience using basic SQL with an understanding of the how data migration and reporting tools such as SSRS and SSIS are used. - 4+ years

Preferred Skills

Experience in formulating data cleansing and migration plans, to import, export, organize, structure, cleanse, merge, order, aggregate, transform, and map data from a variety of data sources in conjunction with business teams, technical teams, and software vendors. - 10+ years

Experience using data science programming languages, such as R, Python, Julia, as necessary. - 4+ years

Experience as database administrator. - 4+ years

Experience as a business analyst. - 4+ years

Experience drafting requirement traceability matrices and test plans for requirement validation. - 3+ years

Experience working within a large IT project team. - 4+ years

Professional experience in working with end users on data cleansing tasks. - 2+ years

Experience working within projects involving vendor owned, managed, designed, and hosted solutions. - 2+ years

Experience with State of Michigan SUITE methodology or similar and related documentation. - 2+ years

Experience working directly with a Corrections Department as a business analyst focused on large-scale enterprise IT systems. - 1+ years