Our Ability Jobs

Job Information

Citizens Principal Data Engineer- ETL in Johnston, Rhode Island



The Principal Data Engineer will report to the Principal Solution Engineer, Enterprise Data Platform. The position is independently involved in the design, model and implementation of Enterprise data warehousing activities in support of projects and defect remediation process. The Principal Data Engineer participates and leads segments in the programming and configuration of warehouses on database, and provides independent support to warehouse users under direction and supervision of more senior data architects and programmers. The Principal Data Engineer assists with designing, implementing and supporting solutions that meet business requirements related to data warehouses, data marts or operational data stores primarily using ETL. The Principal Data Engineer works with application architects to implement enhancements to systems and remediate existing code.

Primary responsibilities include:

  • Design, develop and maintain Enterprise Data warehouse system using ETL tools such as Data Stage, Talend etc to conform to the Regulatory Program Standards.

  • Create and update scripts in UNIX/Linux shell and python to meet the business requirements

  • Design and dvelop code using ETL tools such as Datastage, Talend etc to load data from different sources to the enterprise data platform, including flat files, Complex flat files, AWS S3, Redshift, Oracle, SQL Server, DB2, and big data files.

  • Participate in mapping sessions to understand business requirements, source to target relationships and complex transformations involved in processing data from source to target.

  • Write complex SQL queries to extract data from databases using ETL tools such as DataStage, Talend or Query tools such as Aqua Data Studio, Dbeaver etc as part of ETL development, impact analysis, unit testing and supporting end users by using database joins, self-joins, aggregate functions, rank functions, case statements ,etc as per business requirements.

  • Create and Update Autosys JIL’s for scheduling ETL batch jobs, Autosys boxes to sequence batch windows schedule batch jobs and update dependencies.

  • Provide production support and defect resolution for the ETL code developed by self and others in the team.



  • At least 5-7 Years experience in ETL design and development utilizing Talend or IBM DataStage or other similar ETL tools.

  • Expert in AWS technologies

  • Experience working with DB2 on AIX and Oracle Exadata and other databases. DB2 and Oracle preferred.

  • Excellent SQL skills

  • Excellent scripting skills across Unix/Linux scripts using k-shell and python

  • Experience with SDLC and Agile Methodologies.

  • Experience with configuration management using Subversion

  • Ability to communicate effectively in verbally and in writing

  • Education:

  • Bachelor Degree required in Computer Science, or equivalent. Masters Degree preferred

    Hours and Work Schedule

    Hours per Week: 40

    Work Schedule: Monday-Friday 8:00AM-5:00PM

    Equal Employment Opportunity

    It is the policy of RBS Citizens, N.A. to provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to race, color, ethnicity, religion, gender, pregnancy/childbirth, age, national origin, sexual orientation, gender identity or expression, disability or perceived disability, genetic information, citizenship, veteran or military status, marital or domestic partner status, or any other category protected by federal, state and/or local laws.

    Equal Opportunity Employer – Minority/Women/Disabled/Veteran

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.

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.

Equal Employment Opportunity

Citizens, its parent, subsidiaries, and related companies provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability or perceived 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.

Equal Employment and Opportunity Employer/Disabled/Veteran

Citizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates.