IT Sr ETL Developer

logo

IT Sr ETL Developer

Georgia Farm Bureau

icon Macon, GA, US, 31210

iconFull Time

icon28 March 2024

Apply Now

REMOTE POSITION WITHIN GEORGIA

DESCRIPTION OF ESSENTIAL DUTIES:

  • Provides advanced support in all aspects of the design, mapping, development and testing of data movement for a data warehouse environment, with emphasis on the Extract-Transform-Load (ETL) process.
  • Provide expertise at data modeling, i.e. reading, analyzing, and digesting what the company needs to accomplish with its data, and design the best possible ETL process around those needs.
  • Develops ETL source and target mapping design/specifications based on business requirements and ETL standards and architecture.
  • Develops and executes SQL/stored procedures/ server scripts as needed to support Extract-Transform-Load (ETL) code.
  • Leads data acquisition and transformation delivery activities and provides oversight and technical checkpoints to enforce standards and quality of solutions.
  • Designs and executes testing of ETL designs to ensure the data warehouse system runs smoothly and is accurate.
  • Ensures performance metrics are defined, met and tracked.
  • Assumes responsibility for problem assessment and resolution and complying with service level agreement requirements for Extract-Transform-Load (ETL) support.

 OTHER RESPONSIBILITIES/REQUIREMENTS

  •  Adapt to change on short notice and have excellent people skills such as diplomacy, tact, patience, listening, and communicating.
  • Able to make decisions and accept responsibility.
  • Self-motivated with displayed initiative.
  • Attention to detail when composing and proofing materials.
  • Maintain a high level of confidentiality.
  • Able to organize and prioritize work.
  • Flexible when responding to unexpected situations that require immediate attention.
  • Other work related duties as required or as directed by management.

QUALIFICATION, EDUCATION AND EXPERIENCE REQUIREMENTS: 

A Bachelor’s Degree in the Information Technology field with five years of application development experience required. Experience with integration engines and/or Extract-Transform-Load (ETL) tools and relational reporting tools are required. Experience with data quality tools and working with relational databases and programming concepts is required. Knowledge of major business applications, workflows, and systems required. Demonstrated ability to work in a team environment. Requires excellent oral and written communication skills. Must be able to effectively communicate with company personnel at all levels.

SUPERVISORY RESPONSIBILITIES:

None

PHYSICAL DEMANDS/WORK ENVIRONMENT:

Normal office environment with occasional travel to conferences, training classes or meetings. Utilize Microsoft Office suite to produce work related documents and exhibits with a strong emphasis on Excel. Able to use or learn to use any required integrated development environment (IDE) used to perform development work. Able to read, analyze and interpret instructions, procedures, regulations, manuals and other required documents. Able to communicate in an excellent manner both verbally and in writing. Able to practically solve problems and to develop the necessary steps to produce a usable resolution. Capable of interpreting both written and verbal instructions.

EOE M/F/D/V AA

#LI-Onsite