Overview
On Site
Full Time
Skills
Finance
Control Flow Graph
Mapping
Data Marts
Testing
Acceptance Testing
Documentation
Business Process
Process Flow
Open Source
Reporting
Regulatory Compliance
Computer Science
Electrical Engineering
Datastage
Informatica
Big Data
Apache Parquet
ELT
Spectrum
Oracle
Flat File
Computerized System Validation
XML
Warehouse
IBM InfoSphere DataStage
Toad
Aqua Data Studio
Data Profiling
Data Analysis
Python
Unix
Linux
Shell
Perl
Talend
Snow Flake Schema
Amazon Lambda
Amazon S3
Electronic Health Record (EHR)
Amazon EC2
Data Warehouse
Amazon Web Services
Amazon Redshift
Database
Apache Spark
JIL
Scripting
CA Workload Automation AE
Scheduling
Apache Kafka
Real-time
Streaming
Software Design
Extract
Transform
Load
Java
Dashboard
Tableau
Management
Military
Decision-making
Privacy
Legal
Job Details
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 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.
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 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.