Lead Software Engineer (ETL/AWS Cloud)

First Citizens Bank; Raleigh (NC); Remote; USD 90,000 - 130,000; Full time

Job summary

An innovative financial institution is seeking a Lead Software Engineer specializing in ETL and AWS Cloud technologies. This remote role offers the chance to enhance enterprise data processing systems while collaborating with cross-functional teams. You will be responsible for developing robust data pipelines, ensuring data accuracy, and optimizing processes. The ideal candidate will possess extensive experience in data warehousing and cloud-based solutions, particularly with AWS services. Join a forward-thinking team that values creativity and efficiency, and make a significant impact on data-driven decision-making within the organization.

Qualifications

• 6+ years in software application development or 10+ years with a high school diploma.
• Experience in designing data pipelines and ETL frameworks with AWS technologies.

Responsibilities

• Develop and support enterprise data processing systems and enhance software processes.
• Ensure accuracy and efficiency in data integration and testing.

Skills

Data Integration

Data Analysis

Technical Proficiency

System Testing

Data Pipeline/ETL Frameworks

Data Warehousing/Data Lake

Programming Languages (SQL, Python, Scala, Java)

Data Privacy Constructs

Big Data Technologies

Agile Engineering Practices

Education

Bachelor's Degree in Computer Science

High School Diploma or GED

Tools

AWS Glue

Snowflake

SSIS

Informatica IICS

DataStage

Python

SQL

Hadoop

Kafka

AWS Redshift

Job description

Join to apply for the Lead Software Engineer (ETL/AWS Cloud) role at First Citizens Bank

4 days ago Be among the first 25 applicants

Join to apply for the Lead Software Engineer (ETL/AWS Cloud) role at First Citizens Bank

Overview

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

This position is responsible for development/support of Enterprise data processing systems through enhancement of related software and processes. Develops software and procedures that improve processing capabilities. Analyzes, codes, tests, and implements in coordination with management, associates, and end users. Serves as production system support by resolving issues and ensuring ongoing functionality. May oversee the work of less experienced analysts or assist in special projects as needed.

Responsibilities

1. Data Integration - Provide data integration services for all batch/ real-time data Movement in data warehouse, data platforms (data lake) and dependent data marts (Cloud/OnPrem)
2. Data Analysis - Sources, compiles, and interprets data. Performs analysis for accuracy and efficiencies, effectively communicates analysis output.
3. Technical Proficiency - Provides technical support by performing coding, ensuring processes run smoothly, and working to continuously improve processing capabilities. Works closely with technical and operation teams to support their business objectives.
4. System Testing - Thoroughly tests data integration, data warehouse, data marts to ensure accuracy, completeness, and overall efficiency. Evaluates and conveys testing results. Performs coding and assists in implementing system modifications and enhancements.
5. Ensure that new solutions meet defined technical, functional, and service level requirements and standards and manage the end-to-end lifecycle for new data migration, data integration, and data services-oriented solutions.
6. Additionally, the Lead Software Engineer will engage with partners in testing, release management, and operations to ensure quality of code development, deployment, and post-production support.

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

Preferred Area Of Experience

1. 5+ Years of Experience in designing & building data pipeline/ETL Frameworks with cloud-based data technologies (Preferred AWS Cloud Services Skills)
2. 8+ years of experience in creating and maintaining ETL processes and architecting complex data pipelines - knowledge of data modeling techniques and high-volume ETL/ELT design.
3. 3+ years of Experience with data warehousing/Data Lake solutions using Snowflake, AWS- Redshift.
4. 5+ years of Experience with ETL and Data Ingestion tools such as (SSIS, Informatica IICS, AWS Glue, SAP BODS, DataStage)
5. Experience in programming languages such as ANSI-SQL, Python, Scala, and/or Java
6. Extensive knowledge of data warehouse principles, design, and data modeling concepts.
7. 1+ years of experience in designing data privacy related constructs to enable data tokenization, encryption & data access controls on a public cloud data lake
8. 3+ years of experience in Data Engineering related AWS services like Lake formation, Glue, S3, Lambda, DynamoDB and other AWS accelerators
9. 3+ years of experience in Bigdata technologies like Hadoop, Hive, SPARK, No-SQL DB, Kafka and API
10. Experience in leading team of engineers across geographies
11. Use agile engineering practices and various data development technologies to rapidly develop creative and efficient data products
12. Identify inefficiencies, optimize processes and data flows, and make recommendations for improvements
13. Communicate with other developers across teams, both for ad hoc problem solving, and check-ins/discussions with other initiatives
14. Technical Skills: Snowflake, AWS Services like S3, Glue, Lambda, DynamoDB, Redshift, Redshift spectrum, Lake formation, Sagemaker, Quicksight, Athena
15. Scripting and languages: Python, SQL, PySpark, Hive
16. ETL tools like SSIS, Informatica IICS, SAPBODS, DataStage

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.