Citizens Bank Data Engineer(Remote) in Phoenix, Arizona
The Enterprise Data Office is looking for a Data Engineer with a winning track record in building high performing data and analytical solutions that transform, integrate and meet various data demands from business.
Our Data Engineer will be responsible for the development of ETL process on AWS technologies. We are looking for developers with hands on experience to develop scripts to move data from AWS S3 to downstream systems. You will be responsible for building data products which involves architecture, design, build, test and support data integration projects.
Location is not a barrier for this role and while our preference would be to have a chosen candidate with onsite capabilities in our Johnston, RI headquarters – we are open to remote employment within the United States for an experienced candidate.
Primary responsibilities include:
Implementing data integration architecture and solutions.
Conducting source system/data analysis and data profiling.
Building robust data pipelines to collect process and compute different metrics from various financial sources, adhering to quality and development standards.
Designing application architecture / technical design and articulating 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. Collaborating with cross functional team members as necessary and coming up with optimal solutions that meet data demands.
Executing unit test of data populated in target data container, validating expected result and ensuring quality and accuracy. Coordinating with business users for User Acceptance Testing and with Operations team for code deployment to upper environments.
Following change management team stipulations on path to production requirements and strictly adhering to the compliance and regulatory needs.
Minimum of 3-5 years of ETL development experience
Proficiency in AWS technologies
Proficiency with ETL Development tools like Talend, Data Stage
Excellent skills in SQL Development
Python and other scripting language expert
Ability to work on AWS Glue, AWS S3, Lake formation and other cloud concepts.
Demonstrated and proven verbal and written communication skills
Education, Certifications, and/or Other Professional Credentials:
BS/Engineering in Computer Science or any technology related degree
Hours and Work Schedule
Hours per Week: 40
Work Schedule: Monday through Friday
This position is not available in Colorado
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.