Application Engineer II (Data Engineer)

This is a hybrid role, with the expectation that time working will regularly take place inside and outside of a company office in Jacksonville, FL, Raleigh, NC, Morristown, NJ.

This position is responsible for the planning, problem resolution, and advanced production support for multiple high-priority Bank applications. Provides expert guidance and mentorship on application technical support, maintenance, and enhancement. Installs, configures, and performs daily administration of vendor-supplied software. Monitors overall performance to identify potential issues and tune appropriately. Addresses failed components or technical issues and provides resolution. May oversee the work of less experienced associates and serves as a technical resource to wider business unit.

• Technical Expertise - Maintains a high level of technical knowledge and skills in the Microsoft SQL Server toolset including T-SQL , SSIS, SSRS, SSAS. Develops ETL Processes, stored procedures, triggers, views and data manipulation scripts. Develops SQL Server Analysis Services cubes used for Self Service reporting. Validates that all items which are completed are checked into source control.
• System Testing - Properly unit testing code in each environment based on business requirements and development efforts. Documenting development items and unit tests based on use cases.
• System Enhancement - Working with requirements identified by architects and business requirements to develop coded solutions. Engineers should work to create proactive improvements that impact data quality, and database performance. Coordinates with business analysts, downstream applications business members business to verify request definitions, then makes appropriate system configuration or parameter changes.
• Production support as needed - In the event of a failure in the ETL processes or systems, developers are to work with Database Administrators and source systems to identify the root cause of the error and document that as well as work to get the ETL's running again in a timely manner.

Bachelor's Degree and 4 years of experience in Application Engineering OR High School Diploma or GED and 8 years of experience in Application Engineering

Preferred skills

• Overall 6+ years of experience in Data engineering /ETL-ETL tools / Data governance domains with hands-on building, maintaining, and managing experience

• 4+ years' experience in Developing, maintaining & troubleshooting SQL Server Analysis Services (SSAS) multi-dimensional cubes.
• 4+ Years of development experience in ETL Code using Microsoft T-SQL and SQL Server Integration Services (SSIS).
• Experience in writing triggers, stored procedures, views, functions etc. using MS-SQL
• Extensive experience in using data modelling techniques for building Data Warehouse, Data Lakes, Marts using Kimble methods.
• Document ETL designs, structures, and processes. Expertise in documentation skills with MS word / MS Visio / MS Excel
• Work with team leads and architects to carry out assigned tasks.
• Document daily work items using Microsoft DevOps
• Experience in us CI/CD code deployment/source control procedures.
• Use of Agile methodology to manage backlog & sprints, track work in Azure DevOps/Jira tools.
• Production support as needed.
• Nice to have - Experience in BI tools like SSRS, Tableau, Power BI AND/OR Cloud data solutions like Snowflake, Data bricks AND/OR MDM solutions like Informatica.

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits.