Data Engineer

Sample TasksValidate migrated data in target systems to ensure that it accurately reflects source Informix datanalyze legacy Informix datasets to identify remaining system dependencies and active data usageIdentify data that was not migrated, is incomplete, or does not match source system valuesPerform root cause analysis on data discrepancies and failed or incomplete migrationsReview prior migration strategies, scripts, and processes to assess effectivenessDevelop and execute plans to migrate remaining required data to modernized systemsBuild comparison queries and reconciliation pipelines across Informix, staging, and production environmentsConfirm whether staging data is sufficient to recreate missing documents and recordsssess and validate archived data across storage types (e.g., magnetic, optical, paper)Collaborate with business SMEs to determine data retention requirements and resolve data gapsDocument current and future state data architecture, including ERDs and data flow diagramsProvide recommendations and support planning activities for Informix system retirementSupport broader data research and initiatives across the agency as neededProvide knowledge transfer and documentation to State staffPerform other related duties as assigned.Desired QualificationsExperience 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 transitionsExperience reviewing and working with existing ETL/migration scripts and processesExperience building ETL/ELT workflows and working with staging vs. production data environmentsExperience performing data analysis and root cause investigation in complex or ambiguous environmentsExperience complying with data quality, data governance, and records retention requirementsExperience 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 ConfluenceExperience communicating effectively with and working with both technical teams and business stakeholders