Strategic Data Migration & SQL Analyst

Celebrates Seventh Consecutive Year On Inc.; Baton Rouge (LA); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Emergent Method is seeking a qualified Business Analyst to support an IT project for a state government agency in Baton Rouge, LA. This full-time role supports an active system development effort with onsite presence preferred, though remote candidates are encouraged to apply.

The ideal candidate will handle data migration, data cleansing, SQL queries, and translating business requirements into functional and technical designs while collaborating with technical teams in a fast-paced environment.

Qualifications

• Bachelor’s degree in business, computer science, information systems, or related field.
• 4+ years in data migration, cleansing, and conversion projects.
• 3+ years in data analysis using SQL queries.
• Experience translating business requirements into functional/technical designs.
• Ability to create complex SQL queries.
• Experience with Jira or similar system-testing tools.
• Excellent verbal and written communication skills.
• Strong analytical and problem-solving abilities.
• Ability to prioritize work and meet deadlines under pressure.

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 migration

SQL

Data analysis

Documentation

Jira

Communication

Stakeholder collaboration

Problem solving

Education

Bachelor’s degree in business, computer science, information systems, or related field

Tools

Jira

Job description

Emergent Method is seeking a qualified Business Analyst to support an IT project for a state government agency in Baton Rouge, LA. This full-time role supports an active system development effort with onsite presence preferred, though remote candidates are encouraged to apply.

The ideal candidate will handle data migration, data cleansing, SQL queries, and translating business requirements into functional and technical designs while collaborating with technical teams in a fast-paced environment.