Principal Data Engineer

Job Description

Citizens Financial Group, Inc. (CFG) seeks a Principal Data Engineer for its Johnston, Rhode Island location.

Responsibilities:

Design scalable and reliable data architecture, leading complex technical design decisions for data pipelines and ETL processes, review implementations developed by team members and contract resources, mentor team members on best practices, and drive improvements to enhance performance, scalability, and reliability of data platforms.
Perform analysis and study of existing systems.
Create high level design documents to extract, transform, validate, and load ETL process data dictionaries, metadata descriptions, file layouts, and flow diagrams.
Gather business and application requirements, provide feedback on missing or contradictory requirements, plans and executes sprints.
Organize and manage all phases of the software development life cycle, including development, testing, and deployment of code into production.
Write technical documentation covering design and execution of parallel jobs, batch jobs, and sequencers for data migration.
Participate in code and design reviews with network, infrastructure and solutions engineering teams to ensure that solutions meet current enterprise standards.
Serve as a technical lead, mentoring and supervising more junior engineers.

Qualifications:

Requires a Bachelor's degree, or foreign equivalent, in Computer Science, Electronic Engineering, or related field followed by 7 years of progressive experience as Senior Data Engineer, IT Consultant, or a related position.

Must have 7 years of experience with:

Building data pipelines, datawarehouse solutions, and frameworks for accommodating end user reporting needs;
Collecting requirements, creating software designs, and developing efficient implementations using Agile Software Development Life Cycle;
Implementing data pipelines with using sources that include flat files, databases, APIs, and streaming applications;
Building ETL and data warehousing applications using IBM Datastage, Talend, and ODI;
Designing data enrichment frameworks and processing large amounts of data using Spark, Python, Talend, Datastage, ODI, Unix, PL-SQL, Teradata, AWS, and Java;
Designing, developing, and automating ETL processes to validate and perform reconciliations among multiple source systems using ETL tools, including Spark, Python, Talend, Datastage, ODI, Unix, PL-SQL, Teradata, AWS, and Java;
Utilizing programming languages including, Python, Unix, Java, JavaScript , C, and C++ to fetch data from rest APIs and retrieve security keys;
Utilizing AWS cloud services, including S3, Glue, Athena, Lake Formation, Lambda, EC2, RDS, EMR, Redshift, and IAM to migrate data to AWS Cloud;
Utilizing Cloud technologies, including AWS, AZURE, and Google Cloud Platform, to fetch data from AWS Cloud environments for processing in downstream systems;
Developing and integrating APIs using REST webservices; and
Utilizing CICD tools, including Bitbucket, Github, and Jenkins.

100% remote work permitted from any US location.

Worksite: One Citizens Bank Way, Johnston, RI 02919 United States, 40 hrs/wk. EO employer.

For summary of benefits and to apply visit our website at and apply online (Job ID: 49575) or email resume and cover letter to with subject line: 49575.

Direct applicants only.

About Us

Equal Employment Opportunity

Citizens, its parent, subsidiaries, and related companies (Citizens) provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability, perceived disability or history or record of a disability, ethnicity, gender, gender identity or expression, genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family statparenthood, medical condition, military or veteran status, national origin, pregnancy/childbirth/lactation, colleague's or a dependent's reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and/or local laws. At Citizens, we are committed to fostering an inclusive culture that enables all colleagues to bring their best selves to work every day and everyone is expected to be treated with respect and professionalism. Employment decisions are based solely on merit, qualifications, performance and capability.

Equal Employment and Opportunity Employer

Job Applicant Data Privacy Policy

Background Check

Any offer of employment is conditioned upon the candidate successfully passing a background check, which may include initial credit, motor vehicle record, public record, prior employment verification, and criminal background checks. Results of the background check are individually reviewed based upon legal requirements imposed by our regulators and with consideration of the nature and gravity of the background history and the job offered. Any offer of employment will include further information.