Logo
First Citizens Bank

Senior Data Engineer

First Citizens Bank, Chicago, Illinois, United States, 60290

Save Job

Join to apply for the

Senior Data Engineer

role at

First Citizens Bank . 12 hours ago Be among the first 25 applicants. Get AI-powered advice on this job and more exclusive features. Overview This is a remote role that may only be hired in the following locations: NC, TX, AZ, FL, GA, VA. Responsibilities Builds, manages, and implements metadata-driven data pipeline capabilities, including data modeling, process design, and overall data pipeline architecture, covering all phases of ETL processes. Automates repeatable data preparation and integration tasks. Develops technical solutions for system problems, ensuring quality results. Serves as a technical resource for management, associates, and business units. Partners with technology teams to understand data capture and testing needs, building and testing end-to-end solutions. Leads small data engineering projects and plays significant roles in larger initiatives. Provides technical support to production systems, addressing complex issues, anticipating maintenance needs, and ensuring functionality for end users. Collects data related to user requests, determines scope and estimates, and implements effective technical solutions with problem analysis and resolution. Inspects specifications, programming, coding, test plans, documentation, and implementation plans for accuracy. Collaborates with architects and development teams to understand data requirements, design new tables/queries, and ensure designs are feasible, accurate, and compliant with bank standards. Codes complex solutions to integrate, clean, transform, and control data; builds processes supporting data transformation, data structures, metadata, data quality controls, dependencies, and workload management. Assembles complex data sets and communicates deployment information. Supports data management standards, identifies and communicates solutions to complex problems, and leverages knowledge of information systems and processes. Monitors key performance indicators and internal controls. Works comfortably in distributed, multi-time zone, and dynamic environments. Performs unit tests, reviews code with team members, and ensures code is well-designed, efficient, and performance-tuned. Performs performance tuning of SQL queries and data pipelines. Creates data ingestion pipelines for various sources, including Files, Databases, APIs, and SharePoint. Develops and maintains test plans, analyzes test reports, and leads issue triage. Creates scheduled and trigger-based ingestion patterns using Redwood scheduler. Builds and manages CI/CD pipelines with Gitlab runner. Collaborates with technical and delivery teams for deployment, validation, planning, and release activities. Participates in Agile ceremonies, coordinates with Scrum Master, Tech Lead, and PO. Provides technical support for incident tickets and participates in 24/7 on-call rotations. Qualifications Bachelor's Degree and 4 years of experience in software development, or High School Diploma/GED and 8 years of experience. Preferred 5 years of experience in data engineering, including SQL, Informatica, DataStage, Netezza, SSIS. 3 years of experience leading multi-time zone data teams in agile environments. 1 year of hands-on experience with Cloud platforms (AWS, Snowflake, dbt). Knowledge of data warehousing, data modeling, data quality, and business reporting. Knowledge of analytics platforms, integrations, and big data management. Experience with Power BI, SSAS, SSRS.

#J-18808-Ljbffr