Lead Data Engineer (NC, TX, AZ, FL, GA, VA)

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

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.

• 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.
• Mentors Data Engineers to enable continuous development and monitors key performance indicators and internal controls. Must be comfortable working on a distributed, multi-time zone team and oversee multiple tasks in a constantly changing environment.
• Perform unit tests and conduct reviews with other team members to make sure code is rigorously designed, elegantly coded, and effectively tuned for performance.
• Performance tuning of complex SQL queries and data pipelines.
• Create data ingestion pipelines in data warehouse and other large scale data platforms for variety of sources - File (Flat, delimited, Excel), DB, API (With Apigee integration) and SharePoint.
• Leads testing teams to develop test plans, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues, and errors, and leads triage of underlying causes.
• Creating scheduled as well as trigger-based ingestion patterns using Redwood scheduler.
• Build/manage CI/CD pipelines using Gitlab runner.
• Collaborate with Product Owners to understand PI goals, PI planning, requirement clarification, and delivery co-ordination.
• Collaborating with Team (Technical and delivery) to deploy & validate team deliverables, PI planning, story refinement, JIRA creation and management, release planning and execution, CR creation and other release readiness activities.
• Working in Agile Framework, participating in various agile ceremonies, co-ordination with scrum master, tech lead and PO on sprint planning, backlog creation, refinement, demo, and retrospection.
• Ensuring proper availability of the services.
• Technical support for incident tickets escalated to the team.
• Provides 24/7 on call rotations.

Bachelor's Degree and 10 years of experience in Software application development and maintenance OR High School Diploma or GED and 14 years of experience in Software application development and maintenance

Preferred:

• 5 years of firsthand experience in data engineering/data integration SQL, 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

#LI-XG1

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.