Job Description

Citizens Financial Group, Inc. (CFG) seeks a Senior Data Engineer for its Johnston, RI location.

Duties: Develops and maintains enterprise data warehouse systems using ETL tools to conform to the Regulatory Program Standards. Implements and integrates technical solutions to support the collection of data and the quantification of risk. Participates in mapping sessions to understand business requirements, sources to target relationships, and conducts complex transformations involved in processing data from source to target. Interprets logical and physical data models to business users to determine data definitions. Participates and executes components of the creation, planning, test files, and scripts for data warehouse, or data mart testing, ranging from unit to integration and UAT testing. Creates supporting documentation, such as diagrams of business processes, process flow and micro designs. Customizes and utilizes Data Stage, Talend, and open source ETL technologies to enable development of models and methodologies to derive minimum regulatory capital requirements and support the calculation of economic capital and reporting of regulatory capital in compliance with Regulatory programs.

Requirements: Bachelor's degree in Computer Science, Electrical Engineering, or related field, followed by five (5) years of progressive experience in the role or in a related position. Full term of experience must include: Creating complex ETL data pipelines in Talend, Datastage, Informatica for major business requirements for Complex flat files, Datasets, Bigdata files, Parquet, XML, Databases (source and target); Building ETL and ELT processes from different Data Source databases like AWS Athena, Redshift spectrum, Oracle, flat files, CSV files, AWS S3 bucket and XML files and loaded into target warehouse Snowflake, AWS Redshift database using Talend; Creating joblets in Talend for the processes, which can be used in most of the jobs as part of reusable components; Utilizing IBM DataStage, Talend, Dbeaver , TOAD, and Aqua Data Studio to build data processes (ETL), data profiling and data analytics; Utilizing Python programming, Unix/Linux SHELL, PERL scripting for building data controls; Developing data pipelines in Talend for extracting and transforming data and loading on Snowflake data warehouse; Developing ETL process using AWS Glue, AWS Athena, Aws Lambda on AWS S3, EMR (elastic map reducing), and AWS EC2 Instances for enterprise data warehouse on AWS Redshift database; Building data pipelines using Apache Spark for batch and real-time processing; Creating Autosys JIL's scripts and Autosys box for scheduling ETL jobs to ensure proper dependencies among various processes; Implementing Kafka for real-time data streaming and event-driven data solutions; Designing and implementing ETL processes in Java and optimizing data transformations and integrations using Java frameworks; and Developing dashboards and reports in Tableau for various business requirements.

May telecommute from any U.S. location.

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 status/parenthood, 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.