Description

You will design, develop, and maintain ETL processes and data integration systems. You own the full lifecycle of data migration and transformation workflows.

Responsibilities

• Design and implement ETL strategies to meet agency requirements, ensuring data quality and integrity.
• Cleanse, validate, and integrate data from structured and unstructured sources into data models.
• Build automated, repeatable workflows with performance tuning, audit logging, and exception handling.
• Collaborate with technical architects and stakeholders to define requirements and ensure compliance with state application standards.
• Provide technical documentation, training, and knowledge transfer to agency staff.

Required Skills

• 4+ years of experience in data migration or data integration projects.
• 2+ years of advanced SQL experience, including complex queries, joins, and stored procedures.
• Strong understanding of data modeling, data mappings, and data type transformations.
• Experience with API integration and handling unstructured data.
• Ability to work within Agile/Scrum ceremonies and provide detailed design feedback.
• Strong communication skills for stakeholder collaboration and documentation.

Preferred Skills

• Experience with enterprise ETL tools such as Informatica, Talend, AWS Glue, Azure Data Factory, or SSIS.
• Proficiency in scripting languages such as Python, PowerShell, or Java.
• Completion of two or more full-scale data migration projects (legacy to cloud or modern ERP/CRM).

Key Skills

Education

Any Gradute