Sr Talend Data Engineer
Citizens
Turn this role into an interview — a resume and cover letter built around what this employer wants.
Benefits offered by this job
Job summary
Citizens is seeking a data engineering professional to design, build, and optimize enterprise data warehousing solutions. You will work on data pipelines, ETL/ELT processes, and data models while collaborating with architects and business users to meet complex analytics needs.
You will engage in development, testing, and deployment activities across multiple environments, ensuring quality, scalability, and adherence to regulatory requirements.
Qualifications
- Bachelor's degree in analytics, math, stats or CS.
- Hands-on experience building data solutions in big data/cloud.
- Experience with Hadoop ecosystem (HDFS, Hive, PIG, HBase).
- Experience with ETL/ELT tools (Talend, Datastage, Informatica, Sqoop).
- RDBMS experience (Teradata, Oracle, MS-SQL, DB2, Redshift, Snowflake).
- Scripting: SQL, Python, Shell, Java, Spark, Scala; AWS cloud services; scheduling tools.
- Experience with Windows/Unix/Linux systems and data warehouses.
- Strong communication and collaboration skills; 5+ years in data engineering.
Responsibilities
- Be a strong contributor in implementing data integration architecture and solutions.
- Conduct source system/data analysis and data profiling.
- Build robust data pipelines to collect, process and compute different metrics from various financial sources, adhering to quality and development standards.
- Design application architecture/technical design and articulate data pipeline solutions to team members.
- Data mapping from source to target and define transformation rules meeting data model requirements.
- Collaborate with cross-functional teams to meet data demands and deliver optimized solutions.
- Execute unit tests of data in target containers and validate results for quality.
- Coordinate with business users for UAT and with operations for code deployment to upper environments.
- Follow change management and compliance requirements for production deployments.
Skills
Education
Tools
Job description
At Citizens, we’re more than a bank. Here, you’ll experience new things, create new opportunities, think beyond your role and make an impact!
At Citizens, we’re more than a bank. Here, you’ll experience new things, create new opportunities, think beyond your role and make an impact! While in this position, you will work independently while engaging in the design, model and implementation of enterprise data warehousing activities in support of projects and defect remediation process. You will also, participate in and lead segments in the programming and configuration of warehouses on database, and provide independent support to warehouse users. You will also assist with designing, implementing and supporting solutions that meet business requirements related to data warehouses, data marts or operational data stores primarily using ETL. Lastly, you will work with application architects to implement enhancements to systems and remediate existing code. Most importantly, you’ll feel valued for who you are and supported to achieve what’s important to you, personally and professionally!
- Be a strong contributor in implementing data integration architecture and solutions.
- Conduct source system/data analysis and data profiling.
- Build robust data pipelines to collect, process and compute different metrics from various financial sources, adhering to quality and development standards.
- Design application architecture / technical design and articulate the data pipeline solutions to team members.
- Data mapping from source to target and define transformation rules that meet the models created by data Architects.
- Collaborate with cross functional team members as necessary and come up with optimal solutions that meet data demands.
- Execute unit test of data populated in target data container, validate expected result and ensure quality & accuracy.
- Coordinate with business users for user acceptance test and with operations team for code deployment to upper environments.
- Follow change management team stipulations on path to production requirements and strictly adhere to the compliance and regulatory needs.
- Required Qualifications
- Bachelor's Degree in Analytics, Mathematics, Statistics or Computer Science
- Hands on experience in building data solutions in big data / cloud platforms.
- Experience with Hadoop ecosystem (HDFS, Hive, PIG, Hbase, Hiveql etc.)
- Experienced in ETL/ELT tools such as Talend, Datastage, Informatica, and Sqoop as well as building/enhancing ETL framework.
- RDBMS experience in either of Teradata, Oracle, MS-SQL, DB2, RedShift, Snowflakes, etc.
- Scripting language (shell scripting, SQL, PL/SQL, Python, Java , Spark, Scala)
- Experience with AWS cloud native services such as S3, RDS, Glue, Athena, etc.
- Worked with any of the scheduling tools (Autosys, Tidal, Oozie)
- SCM tool such as Bitbucket with Jira, Starteam or SVN.
- Experience working with various operating systems (Windows, Unix/Linux, IBM Mainframe)
- Strong communicator and collaborator with attention to details.
- Performance tuning and optimization of code and peer code reviews.
- 5+ years of professional work experience as described above.
- Preferred Qualifications
- BigData Technology/AWS/Agile Certifications
- Data engineering experience for Data science projects where Machine learning is used (R, SAS, etc.)
- Experience in the financial services industry, especially banking.
- Business Intelligence/Reporting development experience using tools such as Tableau, Cognos, SAS, etc.
- Code commits to any Open source data tools.
- Experience with handling structured, semi-structured and unstructured data.
- Hours per Week: 40
- Work Schedule: Monday - Friday
- Hybrid schedule: 4 days in office, 1 day WFH is required for this role.
The salary range for this position is $ 105,100 - $ 157,680 per year plus an opportunity to earn an annual discretionary bonus. Actual pay is based on various factors including but not limited to the work location, and relevant skills and experience. We offer competitive pay, comprehensive medical, dental and vision coverage, retirement benefits, maternity/paternity leave, flexible work arrangements, education reimbursement, wellness programs and more. Note, Citizens’ paid time off policy exceeds the mandatory, paid sick or paid time-away policy of very local and state jurisdiction in the United States. For an overview of our benefits, visit https://jobs.citizensbank.com/benefits.
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.
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
Posting End Date: 09/15/2026
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
