Data Migration Analyst — SQL & Process Mapping

Emergement Method; United States; Remote; USD 65,000 - 90,000; Full time

Job summary

Emergent Method is seeking a Business Analyst to support an IT project for a state government agency in Baton Rouge, LA. This full-time role favors onsite presence, with remote candidates also encouraged to apply.

The ideal candidate is experienced, self-motivated, and capable of handling data migration, analysis, and translating requirements into functional and technical designs in a fast-paced environment.

Qualifications

• Bachelor's degree in business, computer science, information systems, or a related field.
• At least four (4) years of experience in data migration, cleansing, and conversion projects.
• At least three (3) years of experience in data analysis using SQL queries.
• Experience translating business requirements into functional and technical designs; ability to create complex SQL queries; Jira experience.

Responsibilities

• Serve as a support resource for data migration and conversion activities.
• Document business processes and requirements around data conversion approaches.
• Translate business requirements into functional and technical designs, including implementing stories and process flows.
• Conduct data analysis and profiling to ensure accuracy and consistency in data migration efforts.
• Create and execute complex SQL queries to assist with technical design, data cleansing, and resolution of bugs/defects.
• Work closely with technical teams to ensure requirements align with data conversion strategies.
• Recommend eliminating, retaining, or enhancing business processes and document results.
• Collaborate with source systems, data analysts, and modelers to build scalable data solutions.
• Analyze source data and perform gap analysis, source-to-target mappings, and data integration design.
• Provide support for user acceptance testing (UAT) and IT application testing related to data migration.

Skills

Data analysis

SQL querying

Communication skills

Analytical thinking

Education

Bachelor's degree in business, CS, IS, or related

Tools

Jira

Job description

Emergent Method is seeking a Business Analyst to support an IT project for a state government agency in Baton Rouge, LA. This full-time role favors onsite presence, with remote candidates also encouraged to apply.

The ideal candidate is experienced, self-motivated, and capable of handling data migration, analysis, and translating requirements into functional and technical designs in a fast-paced environment.