Data Engineering Developer III (ETL Lead)
Morristown, NJ  / Jacksonville, FL 
Share
Posted 29 days ago
Position No Longer Available
Position No Longer Available
Job Description
Overview

  • This position provides complex technical support to data processing systems through enhancement of related software and processes. Develops software and procedures that improve processing capabilities. Analyzes, codes, tests, and implements in coordination with management, associates, and end users. Serves as production system support by resolving issues and ensuring ongoing functionality. May oversee the work of less experienced analysts or assist in special projects as needed.

Responsibilities

  • System Enhancement - Performs a variety of actions that evaluate and improve department systems, processes, and applications. Utilizes programming specifications to construct modules, develop testing methods, and design materials. Provides new feature time estimates for system changes and assists in implementing modifications. Executes test plans to validate application functions as designed.
  • Analysis - Collects data related to user requests and determines scope, time estimates, and system impacts. Inspects business specifications, programming specifications, coding, test plans, documentation, and implementation plans for accuracy.
  • Business Support - Provides technical support to production systems by addressing reported issues, anticipating maintenance requirements, and ensuring functionality for end user needs. Drafts documentation to be used for system, end user, and operational purposes, including technical specifications and application designs.
  • Technical Expertise - Responsible for complex involvement in the software development life cycle including the creation, enhancement, implementation, and evaluation of software. Serves as a technical resource for management, associates, and business units.
  • Develop and maintain complex source code for all SSIS ETL packages within the Data and BI organization
  • Provide advanced code handling for difficult data scenario* Oversee the deployment of all SSIS projects adhering to proper SDLC methodology and change management tools.
  • Ensure the technical specifications of the design meet the stakeholders needs of the data organization
  • Track and perform quality checks using best practices and iterative development methods (AGILE SDLC)
  • Participate in project planning discussions that relate to data models that may be utilized for building data warehouse or data marts
  • Build the tables for the physical data model and continue to evolve it to a working state and continue to refine it to meet project needs
  • Review and monitor database maintenance and performance related topics

Qualifications

    Bachelor's Degree and 4 years of experience in Software application development and maintenance OR High School Diploma or GED and 8 years of experience in Software application development and maintenance
    Preferred Education: Bachelor Degree
    Preferred Area of Study: Computer Science
    Preferred Area of Expereince: MS.NET; ASP.NET; SQL Scripting; Powershell Scripting
    Skill(s): Advanced experience with programming languages such as Microsoft .NET (C#); ASP.NET Core; JavaScript; HTML 5; XML; SQL Scripting and Powershell Scripting, Advanced experience with Microsft Team Foundation Server (TFS) or similar code repository system, Advanced experience with ServiceNow or other information technology ticketing system, Ability to build strong collaborative and productive relationships, In-depth knowledge of System Life Cycle Development methodology (Waterfall and Agile)
    Other preferred qualifications:
    5+ years experience in writing and maintaining SSIS ETL packages
    Working knowledge of technologies and coding languages such as C#, Transact SQL, VB.NET, API (SOAP/REST), and XML
    Intermediate to advanced SQL writing skills
    Working knowledge of reporting tools such as Tableau, SSRS and Power BI is preferred


We are an Equal Opportunity Employer and do not discriminate against applicants on the bases of race, color, religion, national origin, sex, age, disability, veteran or military status, sexual orientation, gender identity, genetic information, or any other legally protected status.

 

Position No Longer Available
Job Summary
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
High School or Equivalent
Required Experience
4+ years
Email this Job to Yourself or a Friend
Indicates required fields