Employment in this role is conditional upon successful execution of the contract by the client.

The Work

The ETL (Extract, Transform, Load) Developer is responsible for designing, developing, testing, implementing, and maintaining scalable ETL processes and data integration workflows for enterprise data warehousing and analytics solutions. The incumbent collaborates with business analysts, data architects, and database administrators to transform and consolidate complex data from various sources, ensuring high data quality, integrity, security, and compliance with relevant federal standards and policies. This position plays a pivotal role in enabling data-driven decision-making within government environments.

This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables.

• 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.

Here’s What You Need

The qualifications and skills listed below are intended to provide a general overview of the requirements for this position. However, due to the anticipated nature of the contract and the absence of a finalized task order from the client, this list should not be considered all-encompassing. Additional qualifications, certifications, skills, or experience specific to the client’s requirements may be identified and requested upon award of the task order. Candidates should demonstrate flexibility and a willingness to adapt to evolving responsibilities as outlined by the client.

• 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.

Desired Qualifications:

• Completion of two or more full-scale data migration projects (legacy to cloud or legacy to modern ERP/CRM).
• Experience with enterprise ETL tools such as Informatica, Talend, AWS Glue, Azure Data Factory, or SSIS.
• Experience with scripting languages such as Python, PowerShell, Java.
• Experience working on a development team.
• Experience with client engagements on design, delivery, deployment and on-going maintenance.
• Previous experience working in an Agile/Scrum environment.

Our Commitment to you / overview of 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

Reports to: Program Manager

Working Conditions

• Professional remote environment.
• Must be physically and mentally able to perform duties extended periods of time.
• Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
• Must be able to establish a productive and professional workspace.
• Must be able to sit for long periods of time looking at computer screen.

• May be asked to work a flexible schedule which may include holidays.
• May be asked to travel for business or professional development purposes.
• May be asked to work hours outside of normal business hours.

Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job.  Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer.  All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.