Data Engineer

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 #J-18808-Ljbffr