Data Conversion Business Analyst

Overview

Emergent Method is seeking a qualified Data Conversion Business Analyst to support the design and testing of the data conversion activities for a state government agency. This is a full-time position that will support ongoing project operations. Remote candidates will be considered and are encouraged to apply. The ideal candidate is experienced, self-motivated, and adept in handling a wide range of business analysis and data-related tasks.

This individual must be flexible, able to work in a fast-paced environment, and willing to embrace the challenges of supporting the continued development and success of a growing workforce.

• Work with the end-user identifying and documenting business and technical requirements
• Translate requirements into functional and technical designs, including implementing stories and source-to-target database data elements’ mappings
• Support data conversion developers for data migration and conversion activities such as validating test results and confirming business requirements and design details
• Conduct data analysis and profiling to ensure accuracy and consistency in data conversion efforts
• Identify and troubleshoot data discrepancies
• Document data quality issues and work with end-users to address and perform data cleansing activities
• Work closely with the application team to address issues and perform action items
• Create and execute complex structured query language (SQL) queries to assist with the technical design effort, data cleansing effort, and resolution of bugs/defects
• Collaborate with source systems, data analysts, and modelers to build scalable data solutions
• Analyze source data and perform data 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
• Attend and participate in extended and long-standing, daily remote meetings

• A bachelor’s degree in business, computer science, information systems, or a related field
• At least two years of experience serving as a data conversion business analyst (or directly involved in data conversion activities)
• At least five years working with relationship databases
• At least five years in implementing SQL queries
• At least five years of experience in translating business requirements into functional and technical designs
• At least five years working with end-users to identify and document requirements as well as to document detail designs
• At least three years of experience in data analysis using SQL queries
• At least three years of experience in testing/validating results
• Experience with using JIRA
• Excellent verbal, written, and interpersonal communication skills - ability to articulate complex concepts in a clear manner
• Strong analytical, problem-solving, and interpersonal skills
• High attention to detail and accuracy – strong quality of work and organizational skills
• Ability to prioritize work, meet deadlines, achieve goals, and work under pressure in a dynamic and complex environment
• Experience with applying new technologies to business needs in a technologically innovative, change-driven organization
• Advanced Microsoft Office (Word, Excel, Outlook and PowerPoint) skills

• Experienced with State Agency IT systems
• Experienced in designing batch programs/processes
• Experienced in database designs
• Experienced in documenting source-to-target field-level data mappings
• Experienced in working with end-users identifying and addressing data quality issues

Emergent Method is a nationally recognized management consulting firm focused on developing and implementing plans, programs, and initiatives that result in transformative impact. We are focused on strengthening the skills, capacity, and resources of our clients to support them in creating unique and valuable experiences for their stakeholders. With an uncommonly high degree of ownership in the work we do, our team thrives on solving complex challenges, delivering solutions built to last, and driving transformational growth.

We work from the inside out — fully engaged with our client teams and invested in their success.…