← Back to jobsJob ID col-cmv8l8gwa0dg4oz01kht9cy9g

TALENT Software ServicesPosted 30+ days ago

Data Engineer

Full-time
Remote
Mid level
Competitive
Posted 30+ days ago

TALENT Software Services is seeking a Data Engineer to support a project involving data migration and validation. The role involves analyzing legacy datasets, performing root cause analysis on discrepancies, and collaborating with business stakeholders to ensure data integrity and compliance.

Posted
30+ Days Ago
Source
www1.jobdiva.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Validate migrated data in target systems to ensure that it accurately reflects source Informix data
  • Analyze legacy Informix datasets to identify remaining system dependencies and active data usage
  • Identify data that was not migrated, is incomplete, or does not match source system values
  • Perform root cause analysis on data discrepancies and failed or incomplete migrations
  • Review prior migration strategies, scripts, and processes to assess effectiveness
  • Develop and execute plans to migrate remaining required data to modernized systems
  • Build comparison queries and reconciliation pipelines across Informix, staging, and production environments
  • Confirm whether staging data is sufficient to recreate missing documents and records
  • Assess and validate archived data across storage types (e.g., magnetic, optical, paper)
  • Collaborate with business SMEs to determine data retention requirements and resolve data gaps
  • Document current and future state data architecture, including ERDs and data flow diagrams
  • Provide recommendations and support planning activities for Informix system retirement
  • Support broader data research and initiatives across the agency as needed
  • Provide knowledge transfer and documentation to State staff
  • Perform other related duties as assigned

Qualifications

  • Experience designing relational databases and using SQL to interact with data (Informix and/or SQL Server preferred)
  • Experience in data migration, validation, and reconciliation for legacy-to-modern system transitions
  • Experience reviewing and working with existing ETL/migration scripts and processes
  • Experience building ETL/ELT workflows and working with staging vs. production data environments
  • Experience performing data analysis and root cause investigation in complex or ambiguous environments
  • Experience complying with data quality, data governance, and records retention requirements
  • Experience documenting data architecture (e.g., ERDs, data flows)
  • Experience managing data within cloud platforms (e.g., Azure)
  • Experience using collaboration tools such as Jira and Confluence
  • Experience communicating effectively with and working with both technical teams and business stakeholders

Preferred

  • Experience designing relational databases and using SQL to interact with data (Informix and/or SQL Server preferred)
  • Experience in data migration, validation, and reconciliation for legacy-to-modern system transitions
  • Experience reviewing and working with existing ETL/migration scripts and processes
  • Experience building ETL/ELT workflows and working with staging vs. production data environments
  • Experience performing data analysis and root cause investigation in complex or ambiguous environments
  • Experience complying with data quality, data governance, and records retention requirements
  • Experience documenting data architecture (e.g., ERDs, data flows)
  • Experience managing data within cloud platforms (e.g., Azure)
  • Experience using collaboration tools such as Jira and Confluence
  • Experience communicating effectively with and working with both technical teams and business stakeholders

Required skills

InformixSQL ServerSQLData MigrationData ValidationData ReconciliationETLELTData AnalysisData GovernanceRecords RetentionData Architecture DocumentationAzureJira

Full job description

TALENT Software Services is seeking a Data Engineer to support a project involving data migration and validation. The role involves analyzing legacy datasets, performing root cause analysis on discrepancies, and collaborating with business stakeholders to ensure data integrity and compliance.

Responsibilities

  • Validate migrated data in target systems to ensure that it accurately reflects source Informix data
  • Analyze legacy Informix datasets to identify remaining system dependencies and active data usage
  • Identify data that was not migrated, is incomplete, or does not match source system values
  • Perform root cause analysis on data discrepancies and failed or incomplete migrations
  • Review prior migration strategies, scripts, and processes to assess effectiveness
  • Develop and execute plans to migrate remaining required data to modernized systems
  • Build comparison queries and reconciliation pipelines across Informix, staging, and production environments
  • Confirm whether staging data is sufficient to recreate missing documents and records
  • Assess and validate archived data across storage types (e.g., magnetic, optical, paper)
  • Collaborate with business SMEs to determine data retention requirements and resolve data gaps
  • Document current and future state data architecture, including ERDs and data flow diagrams
  • Provide recommendations and support planning activities for Informix system retirement
  • Support broader data research and initiatives across the agency as needed
  • Provide knowledge transfer and documentation to State staff
  • Perform other related duties as assigned

Preferred

  • Experience designing relational databases and using SQL to interact with data (Informix and/or SQL Server preferred)
  • Experience in data migration, validation, and reconciliation for legacy-to-modern system transitions
  • Experience reviewing and working with existing ETL/migration scripts and processes
  • Experience building ETL/ELT workflows and working with staging vs. production data environments
  • Experience performing data analysis and root cause investigation in complex or ambiguous environments
  • Experience complying with data quality, data governance, and records retention requirements
  • Experience documenting data architecture (e.g., ERDs, data flows)
  • Experience managing data within cloud platforms (e.g., Azure)
  • Experience using collaboration tools such as Jira and Confluence
  • Experience communicating effectively with and working with both technical teams and business stakeholders
  • Relational Database Design
  • SQL
  • Data Migration
  • Data Validation
  • Data Reconciliation
  • ETL Workflows
  • Data Analysis
  • Data Governance
  • Data Architecture Documentation
  • Cloud Platforms
  • Jira
  • Confluence
  • Effective Communication
  • Collaboration
  • Problem Solving

Company

  • IT consulting, staffing, and professional services provider
  • Saint Paul, Minnesota, USA
  • https://talentstaffingservices.com/
  • Founded in 1987
  • 51-200 employees

Qualifications

  • Experience designing relational databases and using SQL to interact with data (Informix and/or SQL Server preferred)
  • Experience in data migration, validation, and reconciliation for legacy-to-modern system transitions
  • Experience reviewing and working with existing ETL/migration scripts and processes
  • Experience building ETL/ELT workflows and working with staging vs. production data environments
  • Experience performing data analysis and root cause investigation in complex or ambiguous environments
  • Experience complying with data quality, data governance, and records retention requirements
  • Experience documenting data architecture (e.g., ERDs, data flows)
  • Experience managing data within cloud platforms (e.g., Azure)
  • Experience using collaboration tools such as Jira and Confluence
  • Experience communicating effectively with and working with both technical teams and business stakeholders

Required skills

  • Informix, SQL Server, SQL, Data Migration, Data Validation, Data Reconciliation, ETL, ELT, Data Analysis, Data Governance, Records Retention, Data Architecture Documentation, Azure, Jira, Confluence

Experience

  • Mid level

Job details

Employment type

Full-time

Seniority level

Mid level

Date posted

Oct 8, 2026

Work mode

Remote

Job source

www1.jobdiva.com

Company

TALENT Software Services

Information Technology & AI

IT consulting, staffing, and professional services provider

See all 3 jobs from TALENT Software Services →

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

Net2Source (N2S)

1d ago

New

Sr. Data Engineer

Full-timeOn-siteNew York, NYCompetitive

Net2Source is recruiting for a confidential client seeking a Senior Data Engineer. The role focuses on designing and supporting data pipelines and solutions, performing data analysis and ingestion, and implementing CI/CD pipelines for reliable data delivery.

Why similarSame roleETLSQL

Airbnb

1d ago

New

Data Engineer Tech Foundations

Full-timeRemoteUnited States$162K – $186K/yr

Airbnb is hiring a Data Engineer to build and operate reliable, reusable datasets and pipelines that support AI usage and cost measurement, Unit Economics, enterprise application data, and critical financial metrics.

Why similarSame roleData GovernanceRemote

Sagent

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Sagent is building a cloud-enabled, real-time data ecosystem for its next-generation mortgage servicing platform.

Why similarSame roleETLRemote

Get new Data Engineer jobs by email

Create job alert

Data Engineer

TALENT Software Services · Competitive

Apply on company site