<p>Remote - United States</p> <p>I. DESCRIPTION OF SERVICES</p> <p>The scope of the proposed services will include the following:</p> <ul> <li>Design, develop, and maintain ETL processes and systems. </li><li>Create and implement ETL strategies to meet LDWF and OTS requirements. </li><li>Collect, clean, and integrate data from various sources, including structured and unstructured data. </li><li>Develop and maintain data models and data mappings. </li><li>Ensure data quality and integrity by implementing data validation and error handling processes. </li><li>Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize requirements. </li><li>Provide technical knowledge transfer, training, and documentation to OTS and LDWF Agency staff for all requested work. </li><li>Participate by providing feedback and detailed design and implementation approaches in all necessary team meetings and design sessions in accordance with Scrum ceremonies. </li><li>Cooperation with LDWF's Technical Architect and other OTS technical teams to ensure compliance with OTS standards of State applications. </li><li>Perform all other tasks, special projects, analysis, studies, and plans as directed. </li></ul> <p>II. CANDIDATE SKILLS AND QUALIFICATIONS</p> <p>Years</p> <p>Required/Preferred</p> <p>Experience</p> <p>2</p> <p>Required</p> <p>Advanced SQL experience writing complex queries, joins, and stored procedures to identify anomalies and transform data types.</p> <p>4</p> <p>Required</p> <p>Working on data migration or data integration projects with specific experience in building automated, repeatable workflows; performance tuning; data cleansing; API integration; audit logging and exception handling.</p> <p>2</p> <p>Preferred</p> <p>Completion of two or more full-scale data migration projects (legacy to cloud or legacy to modern ERP/CRM).</p> <p>2</p> <p>Preferred</p> <p>Experience with enterprise ETL tools such as Informatica, Talend, AWS Glue, Azure Data Factory, or SSIS.</p> <p>2</p> <p>Preferred</p> <p>Scripting languages such as Python, PowerShell, Java.</p> <p>2</p> <p>Preferred</p> <p>Working on a development team.</p> <p>2</p> <p>Preferred</p> <p>Experience with client engagements on design, delivery, deployment and on-going maintenance.</p> <p>2</p> <p>Preferred</p> <p>Working in an Agile/Scrum environment.</p> <p>Note: Expected Start Date 07/01/2026 and Expected End Date 06/30/2029.</p> <p>Hours worked should be within the State's core hours of 7:00 AM CT to 6:00 PM CT. In addition, Contractor personnel may be required to work on State holidays, weekends and hours outside of the State's core business hours in order to meet critical deadlines.</p>