Data Consolidation Analyst

Turf Masters Brands is searching for a Data Consolidation Analyst for a hands-on role that will be responsible for supporting enterprise database consolidation, migration, and system integration initiatives across a growing portfolio of businesses. This position requires three (3) years of experience in data analysis, database migration, data conversion, systems integration, business analysis, or a related field. Candidates must also have experience analyzing source and destination database structures, data elements, and business processes. Interested candidates must reside within the Eastern or Cerntral time zone. 

Education: 

Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Business, Accounting, Finance, or a related field.
Relevant professional experience may be considered in lieu of a degree.
Additional coursework or certifications in database management, data migration, data integration, or business analysis is a plus.

 Skills:

Strong understanding of relational databases, database structures, tables, fields, relationships, and data dependencies.
Strong analytical and problem-solving skills with the ability to understand complex business processes and data relationships.
Ability to analyze differences between source and target systems and determine appropriate mapping or transformation requirements.
Strong data-mapping and data-validation skills.
Strong attention to detail, commitment to data accuracy, and documentation skills, including the ability to clearly document data mappings, business rules, testing results, issues, and conversion outcomes.
Ability to work independently while collaborating effectively with business and technical teams.
Familiarity with data migration, ETL, data integration, or database conversion tools is a plus.

General Responsibilities:

Support enterprise database consolidation, migration, and system integration projects across the organization’s portfolio of businesses.
Analyze source databases, applications, and business processes to understand data structures, relationships, dependencies, and business requirements.
Develop, maintain, and document source-to-target data mappings.
Identify required data transformations, conversions, cleansing, and business rules.
Identify data discrepancies, investigate root causes, and coordinate resolution with appropriate business and technical teams.
Support the development and execution of user acceptance testing (UAT) and conversion testing.
Perform pre-conversion data assessments and audits to identify potential migration risks or data-quality issues.
Perform post-conversion audits and reconciliation to confirm the integrity and completeness of migrated data.
Assist with post-conversion stabilization by monitoring data quality, investigating issues, and supporting remediation activities.
Maintain detailed documentation of data mappings, transformation rules, business requirements, testing results, issues, resolutions, and conversion outcomes.
Use reports and analytical tools as needed to support data validation, reconciliation, testing, and conversion activities.
Collaborate with project managers, stakeholders, application owners, database teams, developers, and other technical resources throughout the conversion lifecycle.
Escalate significant data-quality, technical, or business-process issues to the appropriate stakeholders.
Identify opportunities to improve data conversion processes, documentation, controls, and repeatability across consolidation initiatives.
Contribute to lessons learned and continuous improvement following completed migrations and conversions.
Perform other data analysis and conversion-related responsibilities as needed to support enterprise consolidation initiatives.

We are committed to diversity, equity, and inclusion in the workplace and provide consideration for an employment relationship without regard to race, color, religion, sex, sexual orientation, gender expression, gender identity, genetic predisposition, national origin, ethnicity, disability, veteran status, or any other characteristic protected by federal, state, or local law.