Citizens Financial Group, Inc. (CFG) seeks an Senior Data Engineer for its Johnston, RI location.
Duties: Designs, maintains, develops, tunes, and automates modern ETL solutions. Builds modern, architecturally sound components, tools, and applications to meet mission-driven strategic business goals. Performs analysis and study of existing systems. Collaborates in creating of high level design documents to extract, transform, validate, and load ETL process data dictionaries, metadata descriptions, file layouts, and flow diagrams. Gathers business and application requirements, provides feedback on missing or contradictory requirements, plans and executes sprints. Organizes and manages all phases of the software development life cycle, including development, testing, and deployment of code into production. Writes technical documentation covering design and execution of parallel jobs, batch jobs, and sequencers for data migration. Participates in code and design reviews with network, infrastructure and solutions engineering teams to ensure that solutions meet current enterprise standards.
Requirements: Bachelor’s degree in Computer Science or related field followed by five (5) years of progressive experience in the role or in a similar position. Full term of experience must include: Building data pipelines, Datawarehouse solutions, and frameworks to accommodate end user reporting needs using sources that include flat files, databases, APIs, and streaming applications; Collecting requirements, creating software designs, and developing efficient implementations using Agile Software Development Life Cycle; Building ETL and data warehousing applications using ETL tools such as Informatica, SSIS, DataStage, Talend, Atacama; Designing data enrichment frameworks and processing large amounts of data using Informatica, SSIS, SQL stored procedures, Talend, DataStage, ODI, Unix, PL-SQL, Teradata, AWS; Utilizing programming languages including, Unix, PL-SQL, C, and C++ to fetch data from rest APIs and retrieve security keys; Utilizing Cloud technologies, specifically AWS(including Athena, Lake Formation, and Redshift), AZURE or GCP; Utilizing databases MS SQL, Teradata, MySQL, Oracle, and NoSQL; Loading and extracting data using SQL, DDL, and DML commands; Designing, developing, governing, and maintaining the platform level data models; Utilizing CICD tools, including Bitbucket, Github and Jenkins; and Data engineering for data analytics and reporting.
May telecommute from any location in the United States.
Direct applicants only.
Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance.
Equal Employment Opportunity
At Citizens we value diversity, equity and inclusion, and treat everyone with respect and professionalism. Employment decisions are based solely on experience, performance, and ability. 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 (including transgender individuals who are transitioning, have transitioned, or are perceived to be transitioning to the gender with which they identify), 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.
Equal Employment and Opportunity Employer
Citizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates.
Why Work for Us
At Citizens, you'll find a customer-centric culture built around helping our customers and giving back to our local communities. When you join our team, you are part of a supportive and collaborative workforce, with access to training and tools to accelerate your potential and maximize your career growth
About the Company: