Senior ETL Developer- Hybrid (Morristown, NJ, Jacksonville, FL, Raleigh, NC)

First Citizens Bank - Raleigh, NC

Full-time - Mid Level

Raleigh, NC

Credit Intermediation and Related Activities

About the position

This is a hybrid role, with the expectation that time working will regularly take place inside and outside of a company office. The position is for a Senior ETL Developer who can write complex data processing procedures, functions, and programs to support data storage, transmission, encryption, and organization using data tools to manage data stores, data warehouses, and reporting systems. This position provides complex technical support to data processing systems through enhancement of related software and processes. The Senior ETL Developer will develop software and procedures that improve processing capabilities, analyze, code, test, and implement in coordination with management, associates, and end users. Additionally, this role serves as production system support by resolving issues and ensuring ongoing functionality. The Senior ETL Developer may oversee the work of less experienced analysts or assist in special projects as needed.

Responsibilities

• Perform a variety of actions that evaluate and improve department systems, processes, and applications.
• Utilize programming specifications to construct modules, develop testing methods, and design materials.
• Provide new feature time estimates for system changes and assist in implementing modifications.
• Execute test plans to validate application functions as designed.
• Collect data related to user requests and determine scope, time estimates, and system impacts.
• Inspect business specifications, programming specifications, coding, test plans, documentation, and implementation plans for accuracy.
• Provide technical support to production systems by addressing reported issues, anticipating maintenance requirements, and ensuring functionality for end user needs.
• Draft documentation to be used for system, end user, and operational purposes, including technical specifications and application designs.
• Responsible for complex involvement in the software development life cycle including the creation, enhancement, implementation, and evaluation of software.
• Serve 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 scenarios.
• 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.

Requirements

• Bachelor's Degree and 6 years of experience in Software application development and maintenance OR High School Diploma or GED and 10 years of experience in Software application development and maintenance.
• Preferred Education: Bachelor Degree
• Preferred Area of Study: Computer Science
• Preferred Area of Experience: Data management software's like Microsoft Visual Studio, SSIS, SSRS, or similar ETL and reporting tools.
• Expertise in loading into data warehouse, Data Modelling, Maintain data consistency, accuracy.
• Advanced experience with Microsoft Team Foundation Server (TFS) or similar code repository system.
• Knowledge of ServiceNow or other information technology service ticketing systems.
• Proven ability to resolve conflicting situations, in order to move process and people forward.
• Ability to be on call 24 hours a day, 7 days a week, on a rotating basis.
• In-depth knowledge and experience with System Life Cycle Development methodologies such as Waterfall and Agile.

Nice-to-haves

• Informatica, Data Stage or other ETL tools
• Intermediate to advanced SQL writing skills, Stored procedures, Functions, APIs
• Working knowledge of reporting tools such as Tableau, SSRS and Power BI is preferred.
• Working knowledge of Master Data Management (MDM), Metadata management using Collibra.

Benefits

• Comprehensive benefits program for full-time associates (20+ hours) with customized offerings designed to support families.
• Access to various health and wellness programs.
• Opportunities for professional development and career growth.