Data Conversion Specialist

Cayuse Holdings

1d•$60,000 - $70,720•Remote

About The Position

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.

Requirements

Two (2) plus years advanced SQL experience writing complex queries, joins, and stored procedures to identify anomalies and transform data types.
Two (2) plus years ETL experience using enterprise tools (Informatica, SSIS) or scripting languages (Python, PowerShell) to move data from Point A to Point B.
Four (4) plus years experience working on data migration or data integration projects with specific experience in Data Profiling, Schema Mapping, Data Normalization, and Error 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.
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.

Nice To Haves

Experience with creating documentation such as data mapping documents and data dictionaries
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.

Responsibilities

Analyze and map data from the old system to the new one.
Develop and implement data conversion plans.
Design and execute data validation and testing processes.
Ensure data quality and integrity throughout the data conversion process.
Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize data conversion 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.