Lead Data Engineer (Data Stage)

First Citizens Bank is a financial institution seeking a Lead Data Engineer to oversee the delivery and maintenance of data solutions. The role involves ensuring data integrity for business operations, mentoring team members, and managing vendor relationships while leading complex data engineering projects.

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

Requirements:

• Bachelor's Degree and 6 years of experience in Advanced data engineering, enterprise architecture, project leadership OR High School Diploma or GED and 10 years of experience in Advanced data engineering, enterprise architecture, project leadership
• 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