Position Summary
Evolve Blue is seeking a CCWIS DL Engineer 1 to support hands-on data engineering for the Minnesota CCWIS modernization program. The engineer will work with senior data engineering, architecture and conversion resources to build and execute data pipelines, implement transformations, perform quality checks, support interface data flows and help validate the successful migration of legacy SSIS information into the new statewide CCWIS solution.
Key Responsibilities
• Develop and maintain ETL/ELT jobs, SQL scripts and data-processing routines under established architecture and coding standards.
• Extract data from legacy sources and load approved target structures for conversion and testing cycles.
• Implement source-to-target mappings and transformation rules provided by architecture and conversion leads.
• Perform data profiling and identify missing, duplicate, inconsistent or invalid records.
• Develop data cleansing, standardization and validation routines.
• Execute migration jobs and analyze pipeline logs, warnings and failed records.
• Perform record-count, field-level and business-rule reconciliation between source and target systems.
• Assist with interface data preparation, API/file-exchange testing and integration troubleshooting.
• Write unit tests and support migration, regression and UAT-related data validation.
• Document mappings, job configurations, defects, test results and operational procedures.
• Work with QA analysts and business/functional teams to investigate data-related defects.
• Follow secure development, source-control and change-management practices.
• Support migration rehearsals, production cutover and post-go-live issue resolution.
• Escalate architecture, mapping and data-quality issues to senior engineers and project leads.
• Contribute to continuous improvement of reusable scripts, data checks and migration utilities.
Required Qualifications
• Recommended: 3+ years of professional data engineering, ETL/ELT, database development or comparable experience.
• Strong working knowledge of SQL and relational databases.
• Hands-on experience building or maintaining ETL/ELT pipelines.
• Experience with data transformation, cleansing, validation or migration activities.
• Working knowledge of Python or another scripting/programming language used for data processing.
• Basic understanding of data modeling, keys, relationships and source-to-target mappings.
• Experience troubleshooting data-load failures and correcting data-quality issues.
• Experience with Git or comparable version-control tools.
• Ability to create clear technical documentation and communicate issues to senior technical resources.
• Must be able to perform project work from within the United States and comply with project security and confidentiality requirements.
Technical Skills
• SQL, relational databases and stored procedures / query development.
• Python or comparable scripting for data processing and automation.
• ETL/ELT tooling such as Azure Data Factory, Databricks, Synapse, AWS Glue or comparable technologies.
• Data profiling, cleansing, transformation, validation and reconciliation.
• Basic API and enterprise integration concepts.
• Source control, unit testing, logging and defect troubleshooting.
Preferred Qualifications
• Government, Child Welfare, CCWIS/SACWIS, Human Services, Healthcare or Medicaid experience.
• Experience with large-scale legacy system migration or modernization.
• Experience with cloud-based data platforms and modern data engineering services.
• Experience with regulated PII/PHI information or government security requirements.
• Reporting or analytics experience using Power BI or comparable tools.
• Experience supporting data conversion testing, migration rehearsals or production cutovers.
CCWIS Project Alignment
• The project requires hands-on execution of legacy SSIS data conversion, validation, cleansing and reconciliation activities.
• The statewide CCWIS must support accurate data exchanges and federal/state reporting while reducing duplicate entry and improving data quality.
• Development and testing in non-production environments before a controlled statewide production deployment.
• Data engineering work must support security, privacy, auditability and operational-readiness requirements for sensitive child welfare information.
Pay: $65.00 - $68.00 per hour
Work Location: Hybrid remote in Saint Paul, MN 55146
