Business Data Analyst

A large state university is looking for a BSA to help with a large ERP Implementation. This system will replace of their legacy applications related to student information. They are looking for a BSA to specifically help with the Data Migration workstream from legacy applications into the new ERP System

This person is being brought on to
• Migrate student information data from various source systems into a single new source of truth (TSS).
• Ensure data integrity, accuracy, and completeness during and after the migration process.
• Identify and address discrepancies or data quality issues prior to migration.
• Validate the converted data against source records to ensure compliance with organizational standards.

Daily Responsibilities Include:
• Data mapping between the various source systems and TSS
• Extraction, and transformation of data.
• Work cross-functionally to ensure alignment of business logic, student information system configuration, and conversion logic.
• Data quality assessment and cleanup.
• Testing and validation of migrated data.
• Documentation of the data conversion process and results.
• Translate business and configuration requirements of target student information system into technical data requirements
• Create process flow and system diagrams describing data processes
• Identify required unit tests based on current and target systems, write SQL tests, perform and track unit testing
• Create and maintain a variety of documentation in Confluence
• Create and maintain mapping specifications for business fields, including table, field, and transformation mappings
• Working with subject matter experts, identify logic to extract and transform data into the desired format
• Perform data analysis across varying sources

They will be expected to:
• Create Data Mapping Documents: Outlines mapping between the source and target systems.
• Create SQL Scripts/Processes: Developed to extraction, transformation data according to specifications
• Do Data Quality Review: Highlights issues identified during the initial data analysis.
• Do Conversion Test Cases and Results: Verification of migrated data accuracy.
• Ensure All data is successfully migrated into the [Target System] without loss or corruption.
• Ensure Data conforms to predefined quality metrics.
• Ensure Migration deliverables are approved by key stakeholders.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Required Skills & Experience
- 5+ years working as a data analyst/business systems analyst specifically with SQL
- experience with data process flows/mapping (using lucid charts but visio works)
- experience extracting data from a variety of data sources (SQL, oracle DB2)
- experience extracting data directly using SQL
- Requirements gathering

Nice to Have Skills & Experience
- data conversion project experience

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.