Lead Data Engineer (Data stage)

Overview

This is a remote role that may only be hired in the following locations : NC, AZ

This position is responsible for the end-to-end delivery and maintenance of cloud and on-premises data solutions that include analytics data platforms, data integration (ETL / ELT), data quality, data lineage, metadata management, and data governance tools. While ensuring that projects are delivered on time and meet the expected functionality, ensures the integrity of data for business operations and decision-making and be instrumental in building and providing support for the services offered. Serves as a technical expert and a mentor for less experienced associates in the work group. Engage in vendor management, budget planning, and auditing to ensure that resources are allocated effectively and efficiently.

Responsibilities

System Enhancement - Leads team efforts to evaluate and improve department systems, processes, and applications. Utilizes programming specifications to construct modules, develop testing methods, and assists with designing training materials. Designs and executes test plans to validate application functions. Designs modifications that fit within existing system architecture.

Business Support - Provides technical support to production systems by addressing complex issues, anticipating maintenance requirements, and ensuring functionality for end user needs. Develops technical solutions to unique system problems. Leads major projects, delegates tasks, and ensures quality results.

Technical Expertise - Utilizes expertise to mentor and train associates within the work group. Participates in special projects and meetings as needed to convey critical technical insight. Serves as a technical resource for management, associates, and business units.

Data 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.

Collaborate with architects and development teams to understand data requirements, instantiate design patterns, build reusable Data Pipelines / frameworks, design new tables / queries and ensure the design is feasible, implemented accurately and compliant with all the bank standards while accelerating speed to market for delivery.

Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, assembles complex data sets, and communicates required information for deployment.

Leads work efforts with technology partners and stakeholders to close gaps in data management standards adherence, negotiates paths forward by thinking creatively to identify and communicate solutions to complex problems, and leverages knowledge of information systems, techniques, and processes.

Qualifications

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

5 years of firsthand experience in data engineering / data integration SQL, SAP BODS, Oracle, SQL server, Informatica, DataStage, Netezza, SSIS technologies.

3 years of experience in agile engineering practices, leading multi-time zone data teams

2 years of hands-on experience in AWS, Snowflake, dbt

1 year experience with cloud computing

Working knowledge of design and development concepts in Cloud Data warehousing, transactional and analytical data modeling, data quality, business reporting and dashboards

Working knowledge of technologies in Cloud technologies, analytics platforms, mastering, integrations, and big data management.

Working knowledge of Analytics Delivery, Python, Power BI, SSAS, SSRS

Experience in working with Finance and regulatory reporting will be plus.

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.

Company Description :

Founded in 1898 and headquartered in Raleigh, N.C., First Citizens Bank serves customers in 18 states and the District of Columbia. For over 100 years, customers have trusted First Citizens with their money … and their futures. Today, First Citizens is the largest family-controlled bank in the nation and the sixth-largest bank franchise headquartered in the Southeast with more than $30 billion in assets. We employ more than 6,000 associates who are focused on helping our customers achieve a lifetime of success. First Citizens operates more than 570 branches in Arizona, California, Colorado, District of Columbia, Florida, Georgia, Kansas, Maryland, New Mexico, Missouri, North Carolina, Oklahoma, Oregon, South Carolina, Tennessee, Texas, Virginia, Washington and West Virginia.

First Citizens Bank. Forever First®. Member FDIC.

Equal Opportunity / Affirmative Action Employer / Minority / Female / Disability / Veteran

If you need special assistance or an accommodation in applying for employment at First Citizens Bank, please contact our Human Resources department.