Senior Talend Data Engineer: Data Warehouse & ETL Lead

Citizens; Johnston (RI); Hybrid; USD 105,000 - 158,000; Full time

Benefits offered by this job

Education reimbursement

Wellness programs

Flexible work arrangements

Paid time off policy exceeds local law

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

Data integration architecture

Source system analysis

Data profiling

ETL/ELT frameworks

CI/ETL testing

Cross-functional collaboration

Education

Bachelor's Degree in Analytics, Mathematics, Statistics or Computer Science

Tools

Hadoop ecosystem (HDFS, Hive, PIG, HBase)

ETL tools (Talend, Datastage, Informatica, Sqoop)

RDBMS (Teradata, Oracle, MS-SQL, DB2, Redshift, Snowflake)

AWS services (S3, RDS, Glue, Athena)

Scheduling tools (Autosys, Tidal, Oozie)

Version control (Bitbucket/Jira/SVN)

Scripting languages (Python, SQL, Shell, Java, Spark, Scala)

Job description

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.