Data Engineer II

NCMIC • Full-time • Clive, IA, US • 1w ago

Job Details

Description

Job Purpose:

Responsible for creating and modifying moderate to complex Extract, Transform, and Load (ETL) processes. Ensure reliability, stability, and performance of ETL environment. Design, develop, troubleshoot, and maintain ETL processes.

Essential Functions

Performs design, development, debugging, and maintenance of ETL processes. Identify, understand, and translate development requirements into technical solutions. Monitor ETL processes to ensure reliability and data availability.

Performs unit testing and regression testing as needed to ensure ETL processes are functioning according to requirements. Relies on experience and judgment to plan and accomplish goals and in resolving problems and technical issues.

Assists in development of standards and procedures for the management, design, and maintenance of the ETL environment.

Maintains knowledge of ETL tools and processes; including changes in technology and potential impact to department and makes appropriate recommendations.

Performs other duties as assigned.

Requirements

Education: Bachelor’s degree in computer science, management information systems or related field or equivalent experience.

Experience

3+ years of experience in ETL development with Talend, SSIS, Informatica, Python, or similar ETL tool (Talend preferred).
Strong understanding of relational databases, with a preference for expertise in MS-SQL.
Proficiency in the fundamentals of data pipelining, ELT/ETL processes, and the overall data lifecycle, complemented by strong problem-solving and analytical skills to gather and interpret data, identify trends, and translate findings into efficient data workflows and solutions.
Knowledge of agile SDLC methodologies.
Strong verbal, written, and interpersonal skills required, including ability to convey technical issues to non-technical audience.

Mental Demands: Ability to gain understanding of tools, technologies, languages and techniques as required for assigned environments. Ability to research and solve development and application problems with little assistance. Ability to focus on tasks for extended periods of time. Must be flexible and have the ability to work with a variety of tasks and employees. Ability to plan, organize, be detail and deadline oriented and maintain a high accuracy rate.

Physical Demands: Continuous sitting for extended periods of time, some standing, walking, bending and reaching. Frequent use of fingers and hands to manipulate computer, telephone and other office equipment. Ability to be able to look and concentrate at a computer screen/monitor for extended periods of time.