Design, develop, and maintain ETL processes and systems.
Create and implement ETL strategies to 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 by providing feedback and detailed design and implementation approaches in all necessary team meetings and design sessions in accordance with Scrum ceremonies.
Cooperation with LDWF’s Technical Architect and other OTS technical teams to ensure compliance with OTS standards of State applications.
Perform all other tasks, special projects, analysis, studies, and plans as directed. Other duties as assigned .

Requirements

Two (2) plus years advanced SQL experience writing complex queries, joins, and stored procedures to identify anomalies and transform data types.
Four (4) plus years experience 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.
Must be able to pass a background check.
May require additional background checks as required by projects and/or clients at any time during employment.
Minimum Skills: Exceptional interpersonal skills with the ability to communicate in a clear, professional, and articulate manner.
Exceptional verbal and written communication skills.
Excellent organizational, analytical, and problem-solving skills with high-level attention to detail.
Ability to analyze systems and procedures
Strong multitasking skills with the ability to manage multiple design streams across concurrent work effort.
Must be self-motivated and able to work well independently as well as on a multi-functional team.
Ability to handle sensitive and confidential information appropriately.

Benefits

Medical, Dental and Vision Insurance
Wellness Program
Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
Short-Term and Long-Term Disability options
Basic Life and AD&D Insurance (Company Provided)
Voluntary Life and AD&D options
401(k) Retirement Savings Plan with matching after one year
Paid Time Off

Applicant Tracking System Keywords

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

Hard Skills & Tools

ETL processesSQLdata migrationdata integrationdata cleansingAPI integrationdata validationerror handlingperformance tuningdata modeling

Soft Skills

interpersonal skillscommunication skillsorganizational skillsanalytical skillsproblem-solving skillsattention to detailmultitasking skillsself-motivatedteam collaborationconfidentiality