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
First Citizens Bank is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race (including traits historically associated with race, such as hair texture and protective hairstyles), color, religion, national origin, sex, age, disability, protected veteran status, sexual orientation, gender identity, genetic information, military membership, application, or obligation, or any other legally protected status.