Design, develop, and maintain ETL processes and systems to support agency data integration needs.
Create and implement ETL strategies that meet LDWF and OTS requirements.
Collect, clean, and integrate data from various sources, including structured and unstructured data.
Develop and maintain data models and data mappings.
Ensure data quality and integrity by implementing data validation and error handling processes.
Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize requirements.
Provide technical knowledge transfer, training, and documentation to OTS and LDWF agency staff for all requested work.
Participate in team meetings and design sessions by providing feedback and detailed design and implementation approaches in accordance with Scrum ceremonies.
Cooperate with LDWF's Technical Architect and other OTS technical teams to ensure compliance with OTS standards for state applications.
Perform additional tasks, special projects, analysis, studies, and plans as directed.

Requirements

4 years of experience working on data migration or data integration projects
2 years of advanced SQL experience writing complex queries, joins, and stored procedures
Specific experience in building automated, repeatable workflows; performance tuning; data cleansing; API integration; audit logging; and exception handling.
Completion of 2 or more full-scale data migration projects involving legacy to cloud or legacy to modern ERP/CRM systems (preferred)
Experience with enterprise ETL tools such as Informatica, Talend, AWS Glue, Azure Data Factory, or SSIS (preferred)
Experience with scripting languages such as Python, PowerShell, or Java (preferred)
Previous experience working in an Agile/Scrum environment (preferred)

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL processesdata integrationdata modelingdata mappingdata validationerror handlingadvanced SQLautomated workflowsdata cleansingAPI integration

Soft Skills

collaborationtechnical knowledge transfertrainingdocumentationfeedbackdesign sessionscommunicationprioritization