Citizens Financial Group, Inc

Sr Talend Data Engineer

Citizens Financial Group, Inc$105K — $157K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's Degree in Analytics, Mathematics, Statistics or Computer Science
  • Hands-on experience with big data/cloud platform solutions
  • Proficient in Hadoop ecosystem technologies like HDFS, Hive, and others
  • Skilled in using ETL/ELT tools such as Talend, Informatica, or Datastage
  • Experienced with RDBMS systems including Oracle and MS-SQL
  • Scripting expertise in SQL, Python, and shell scripting
  • Familiar with AWS cloud services like S3 and Glue
  • Strong communication and attention to detail skills

Responsibilities

  • Implement data integration architecture and solutions
  • Conduct source system analysis and data profiling
  • Build data pipelines for processing various financial metrics
  • Design application architecture and technical solutions
  • Map data from source to target and define transformation rules
  • Collaborate with cross-functional teams for optimal solutions
  • Execute unit testing and validate data accuracy
  • Coordinate user acceptance testing and code deployment

Benefits

  • Comprehensive medical, dental and vision coverage
  • Retirement benefits and maternity/paternity leave
  • Flexible work arrangements and education reimbursement
  • Wellness programs
  • Above-mandatory paid time off policy
Full Job Description
Job Description

4 Days in the office from any of our locations in RI,Iselin NJ, MA, Pittsburgh PA, Nashville TN, and couple other locations

Role is not relocation eligible.

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.

Primary responsibilities include
  • 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.

Qualifications, Education, Certifications and/or Other Professional Credentials
  • 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 & Work Schedule
  • Hours per Week: 40
  • Work Schedule: Monday - Friday
  • Hybrid schedule: 4 days in office, 1 day WFH is required for this role.
    Pay Transparency
    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.


About Citizens Financial Group, Inc

Citizens Bank is a financial service company. It provides outstanding local and personalized service. It offers a full range of commercial, real estate, and consumer lending. It is specialized in personal and small business deposit services, electronic services.

Citizens Financial Group, Inc. Careers

Join the dynamic team at Citizens Financial Group, Inc., a leading financial institution where your career aspirations can soar. We are committed to fostering a culture of innovation, leadership, and diversity that supports our employees' professional growth and development.

Explore Job Opportunities

At Citizens Financial Group, Inc., we offer a wide range of job opportunities that cater to diverse skill sets and career interests. Whether you're a seasoned professional or just starting out, you'll find a position that challenges you and enhances your expertise.

Internship Programs

Kickstart your career with our internship programs designed to give you a hands-on experience in the financial sector. Our internships provide a robust platform to develop your skills, engage in meaningful projects, and network with industry leaders.

Employment Benefits

Choosing a career with Citizens Financial Group, Inc. means opting for a comprehensive package of benefits. We believe in supporting our team members not only in their professional lives but also in their personal growth and well-being.

Inclusive Culture and Diversity Training

We pride ourselves on a workplace culture that embraces diversity and inclusivity. Regular diversity training ensures that our team members appreciate and leverage the unique backgrounds and perspectives that each individual brings to the company.

Professional Growth and Leadership Development

Continuous learning is at the core of our professional development agenda. With access to leadership development programs and tailored training, you can advance your career and leadership skills at Citizens Financial Group, Inc.

Innovation at Work

Innovation is key to staying competitive in the financial industry. At Citizens Financial Group, Inc., you’ll work alongside talented professionals who are pushing the boundaries of what’s possible in financial services.

Networking and Career Advancement

Our company not only provides job opportunities but also fosters an environment where networking and professional connections flourish. This supportive network is vital for career advancement and personal growth within the industry.

Join Our Team

Are you ready to take the next step in your career? Explore the open positions at Citizens Financial Group, Inc. and find where your skills and passions align with our needs. We are continuously hiring and looking for new talents to join our robust team.

Stay Connected

Keep up to date with the latest career tips, industry insights, and job openings at Citizens Financial Group, Inc. Subscribe to our careers blog and personalize your job alerts to match your preferences and career goals.

Prepare for Your Interview

Make a great first impression. Prepare for your interview with us by researching our company culture, reviewing your resume, and coming ready to discuss how your experience and skills align with the position you are applying for. At Citizens Financial Group, Inc., we are more than just a financial institution; we are a place where you can make a difference. Join us and transform your career with a company that values your unique talents and aspirations.
Learn more about Citizens Financial Group, Inc
Size
17,463 employees
Market Cap
$19.3 billion
Industry
Net Income
$1 billion
Founded
1828
5 Year Trend
+2.6%
NASDAQ

Similar Jobs

More Jobs at Citizens Financial Group, Inc

More Information Technology Jobs

Find similar Sr Talend Data Engineer jobs: