Senior Data Engineer
Data Analytics
Johnston, Rhode Island
Description
Finance and Risk Technology team is looking for a Sr. 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. They will be responsible for building data products which involve architecture, design, build, test, and support data integration projects as well as serve as a core member in the Agile team that leads user story analysis and elaboration.
The Senior Data Engineer will be responsible for:
Contributing in 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 come up with optimal solutions that meet data demands.
Executing unit test of data populated in target data container, validating expected result and ensure quality & accuracy. Coordinating with business users for User Acceptance Test and with Operations team for code deployment to upper environments.
Following change management team stipulations on path to production requirements and strictly adhere to the compliance and regulatory needs.
RequiredQualifications
- 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 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, Glu, 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.
Desired Qualifications
- 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.
Education and Certifications
Required: Bachelor's Degree in Analytics, Mathematics, Statistics or Computer Science
Preferred: BigData Technology/AWS/Agile Certifications
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.
Equal Employment Opportunity
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.
Background Check
Any offer of employment is conditioned upon the candidate successfully passing a background check, which may include initial credit, motor vehicle record, public record, prior employment verification, and criminal background checks. Results of the background check are individually reviewed based upon legal requirements imposed by our regulators and with consideration of the nature and gravity of the background history and the job offered. Any offer of employment will include further information.
Benefits
We offer competitive pay, comprehensive medical, dental and vision coverage, retirement benefits, maternity/paternity leave, flexible work arrangements, education reimbursement, wellness programs and more.
View Benefits
Awards We've Received
Age-Friendly Institute's Certified Age-Friendly Employer
Human Rights Campaign Corporate Equality Index 100 Award
Dave Thomas Foundation’s Best Adoption-Friendly Workplace
Disability:IN Best Places to Work for People with Disabilities
Fair360 Top Regional Company
FORTUNE’s World’s Most Admired Companies
Military Friendly® Employer
- Citizens Banker Pittsburgh, Pennsylvania Pittsburgh, Pennsylvania
- Citizens Banker Islandia, New York Islandia, New York
- Home Mortgage Product Strategy & Management Johnston, Rhode Island; New York, New York; Irving, Texas; Boston, Massachusetts; Westwood, Massachusetts; Plano, Texas Johnston, Rhode Island, New York, New York, Irving, Texas, Boston, Massachusetts, Westwood, Massachusetts, Plano, Texas
-
-
Benefits We’re committed to providing benefits, resources and programming to surface healthy habits and support the whole you, across all aspects of your life.
-
Life at Citizens Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt.
-
Business Banking Jobs Roles with our Business Banking team are for ambitious entrepreneurs. Here, growth is attainable, for your career, for your clients’ business, and for our company.
-
Technology, Security & Digital At Citizens, we invest in the humans who build the logic, ideas, and innovations that bring new technologies to life.
-
Retail Banking Careers
-
Job Seeker Resources
-
Community Being good citizens is at the heart of who we are. See how Citizens supports and strengthens communities, learn about banking careers and search our jobs.
-
Explore Citizens
-
Career Areas
-
Commercial Banking Jobs
-
Corporate Jobs
-
Mortgage Careers
-
Commitment to Pay Equity Citizens is committed to building a diverse, inclusive, and high-performing culture where everyone feels valued, respected, and heard and feels a sense of belonging.
-
Corporate Responsibility Our commitment to continual environmental, social and governance (ESG) progress is woven into the fabric of our business, as we work to create a thriving, sustainable, inclusive future for all of our stakeholders.
-
What drives you? We strive to help our customers, colleagues and communities reach their potential. No matter what drives you, we'll support your goals with a culture that encourages mentoring and empowers you to put your ideas into action. Learn more about our Home Mortgage careers today.
-
Our Journey for Social Equity We’re committed to creating a diverse, equitable and inclusive world. We’re proud of the meaningful progress we made in 2021 and are committed to continuing our efforts in 2022 and beyond.
-
Citizens Helping Citizens Giving back is part of our Credo. Citizens harnesses the power of our colleagues to impact communities across our footprint.
-
How I Grow Here | CJ Builds a Well-Rounded Career CJ, Head of Enterprise Experience Risk, has been with Citizens for 17 years and he’s got some wisdom to share.
-
-
-
-
Career Growth & Development at Citizens With dedicated programs, advice and upskilling opportunities, you can build the career you want at Citizens.
-
-
Celebrating Those Who Live Our Credo We make it easy to recognize colleagues who live our values, drive innovation and volunteer in our communities.
-
Supporting Veterans and Military Families at Citizens Military members demonstrate the ultimate sacrifice. At Citizens, we're proud to support veterans, those who are serving, and those who support them.
-
How One Colleague Made Prioritizing Her Well-being Work Kendra, a colleague in our Universal Operations team, came in first place in our 2023 Move for Mental Health step challenge. Find out how she did it!
-
How Karen Stays “Grounded in Gratitude” Here’s how Karen, Head of Citizens Contact Center & Retail Transformation, navigates her health journey.
-
For Mark, Wellness Means Conscious Choices Hear about the moment our interim Head of Core Banking and Pittsburgh Market President made a wellness decision to prioritize a true work life balance.
-
Kirsten’s Journey from Couch to 5K and Beyond When the opportunity to join Team Citizens at the 2023 TCS NYC Marathon came up, Kirsten knew she had to throw her hat in the ring.
-
Recognizing the Hard Work of our Colleagues during Credo Week Credo Week is an opportunity to take a moment and recognize the incredible workforce that has helped us grow into the leading financial institution we are today.
-
Hear from our Early Career Program Alumni Our Early Career Development Program (ECDP) ensures that you get a versatile, interesting mix of experience in various disciplines and fields - with mentors and peers to support you along the way.
-
Celebrating Pride 365 Days a Year Celebrating Pride is a reflection of Citizens' commitment to supporting LGBTQ + communities and fostering a more inclusive world.
-
Our Charlotte, NC Office is Uniting Forward-thinking Digital Minds We’re committed to growing out our digital capabilities with our Charlotte office build out and top-down organizational commitment.
-
Ready to Protect our Customers A career with our Fraud Operations team is ideal for self-motivated people who desire to be best-in-class, delivering an exceptional customer experience.
-
Betting on Herself The career journey of Kristy, Human Resources Development Consultant
-
Citizens Continues Autism at Work Program Citizens is continuing to hire for their Autism at Work Program as part of their diversity and inclusion efforts.
-
Celebrating our Colleagues’ Achievements: Big and Small Celebrating our colleagues is engrained in the Citizens culture. Learn about the different ways that we celebrate the achievements of our colleagues, every day.
-
Well-being at Citizens We invest in supporting wellness across all dimensions of our colleagues’ lives. Care for the whole you is an essential cornerstone of our commitment to you.
-
How I Grow Here | Maria Upskills Through Networking Meet Maria, an Engagement Manager at Citizens, and learn how her appetite to learn new skills, gain new experiences and expand her network helped her unlock her full potential.
-
Business Banking Colleague Spotlight Our Business Banking colleagues share how they feel supported by leadership and our culture of innovation.
-
Virtual Volunteering with Citizens Giving back is at the core of what we do and embedded deep in Citizens’ culture. As distinguished former Citizens colleagues, we invite you to engage in any of these virtual/at-home volunteer activities to continue to make a difference in your community.
-
For Darnell, Well-being Begins with Balance When Darnell isn’t busy supporting our bustling Mergers & Acquisitions business, you can catch him getting some reps at the gym or hitting the heavy bag.
-
We're hiring PCRMs in Southern New England! We're expanding our team of Private Client Relationship Managers in Southern New England. Learn more and apply today!
-
How I Grow Here | Melissa's Journey to Growth & Professional Success Discover how our Head of Enterprise Data and Analytics Transformation leaned into opportunities for development, empowering her to excel in her professional path.
-
How to Avoid Recruiting Scams | Tips from Citizens Learn how to protect yourself from recruiting scams with tips from Citizens Cyber Defense Team. Stay informed about common red flags, protect your personal information, and ensure your job search is safe and secure.
-
Citizens Colleagues Build Playhouse for Veteran Family Discover how Citizens colleagues from the Veterans and Caring for Citizens BRGs teamed up to build a playhouse for a veteran family, embodying our commitment to service, collaboration and community support.
-
Helping Colleagues Grow Their Families Through Adoption We’re proud of the recognition for the support, care, and resources we provide colleagues when they begin their parenthood journey. Read David's story of how Citizens and his team supported his journey to parenthood.
-
Democratizing Data Across Citizens We sat down with Krish Swamy, our Chief Data & Analytics Officer, to talk about big trends in the space, and his commitment to colleague upskilling in the discipline.
-
Consumer Bank Colleagues Battle on the Ice Colleagues across the Consumer Bank gathered for the 1st Annual Citizens Stanley Cup at a rink near our Johnston, RI campus.
-
Welcome to Your New Technology! Get started quickly with step-by-step instructions for setting up your new devices.
-
Ready to make your mark in our Citizens Private Bank internship Gain exposure to Citizens Private Bank as a summer intern, helping to build and apply exceptional client-service skills and ingenuity to solve problems and enhance relationships with our clients.
-
Floorcare Maintenance Technicians | Apply Now Join Citizens as a Floorcare Maintenance Technician and help maintain clean, safe and welcoming facilities. Enjoy competitive benefits, including a company vehicle and health coverage. Explore opportunities in your region and apply today!
-
Data & Analytics Takes Centerstage at DataPulse We're on a journey to revolutionize data and insights at Citizens. DataPulse, our proprietary, annual data and analytics conference, is open to all colleagues to learn, network and upskill.
-
Transforming Data & Analytics at Citizens If you embrace a 'test and learn' mentality and crave a culture that invests in its community of users, you're ready to help us transform the data and analytics space at Citizens.
-
Ready for a sneak peek into a career in our Contact Centers Help our customers while growing your career. Join our Contact Center team today!
-
Bring your skills to our Commercial Banker Development Program We’re looking for the next generation of talent to serve as trusted advisors to our clients; to understand where they’re going and bring the tools and insights needed to help them get there.
-
How I Grow Here | Joel's Tackling New Challenges Meet Joel, Project Manager for the Emerging Markets team in the Community Development organization. Hear how his eagerness to learn and embrace technology led to exciting new career growth.
-
Capital Markets & Advisory (CM&A) Programs Want to join one of the oldest and largest financial institutions in the country? Explore our internship and full-time programs today!
-
A Career That Makes An Impact Be part of our elite team of Private Client Relationship Managers and be the trusted advisor for your clients.
-
Citizens Community Service Sabbatical program Learn more about our pinnacle volunteer opportunity that invests in the growth of our colleagues and nonprofit partners by leveraging colleagues' skills and talents in new ways.
-
Consumer Bank Enterprise Experience Programs Jumpstart your career through hands-on, impactful projects, comprehensive training, and exposure to executive leadership, paving the way for a robust career.
-
Be Supported for Who You Are - and All You Can Do As part of our commitment to building an inclusive workforce and world, Citizens is proud to offer a range of programs to support colleagues with differing abilities as they build new skills, grow their careers, and make an impact.
-
Educational Assistance Program Discover how Citizens supports your professional growth with our Educational Assistance Program. From financial support to skill development, explore our commitment to helping you build a rewarding career.
-
Our Johnston, RI Campus is Strengthening Collaboration & Benefiting the Community Our state-of-the art campus in Johnston, Rhode Island is located off I-295 and spans over 123 acres as the centralized hub for over 3,000 colleagues. The Johnston Campus brings significant benefits to the local community.
-
Meet Omar, a Successful Banker and Proud Hispanic American Fluent in English, Spanish and Portuguese, Omar is proud to serve his community in Framingham, MA.
-
How Citizens Helped Neil's Appointment to the Board of a Nonprofit Thanks to Citizens’ investment in his growth, Neil was unanimously appointed to the board of a nonprofit.
-
A FinTech Veteran’s Perspective on Building an In-house Tech Firm Learn why Citizens is perfect for curious and motivated software engineers looking to build impactful solutions that affect millions of customers.
-
Guide to Behavioral Interviewing Learn how to have a successful behavioral interviewing experience.
-
Finding the right career path: Guidance from our CEO, Bruce Van Saun Some lessons from our CEO Bruce Van Saun on career journeys and advancing your career.
-
Robert’s Career Journey From Client to Colleague Hear Robert share how he went from a loyal customer, to working at Citizens.
-
Bringing Her Whole Self to Work Hear from Kavita, SVP, Director of Product Strategy & Merchant Services with the Commercial Bank, about the impact her Asian American and Pacific Islander (AAPI) heritage has had on her life.
-
From Refurbishing Sneakers to Thriving at Citizens The career journey of Silavong, CDL Merch Relationship Support Partner.
-
Meet Aaron, Branch Manager & Seasoned Resident of Boston’s Chinatown Aaron is living out our values as the BM of his Chinatown branch, helping his branch team grow and actively giving back to his community.
-
Citizens Alumni Community Citizens supports our alumni at work, at home, and in your community. We’re committed to helping our former employees thrive, and invite you to reconnect and explore opportunities at Citizens.
-
From Challenging Start to Unstoppable The career journey of Renee, Business Banking SVP and Virtual Channel Director
-
How Lisa Made the Most of Mentorship Lisa, a Retail Banking Director for the Upper Mid-Atlantic region and a 33-year Citizens veteran, recently shared in her own words what it means to have a mentor and be a mentor.
-
Writing Her Own Career Story The career journey of Mary, Senior Digital Content Management Partner
-
Finding the Perfect Career Fit The career journey of Evanne, Home Equity Loan Specialist
-
Colleague Growth at Citizens Check out the career journeys of colleagues from around the organization, and across our footprint.
-
Tips for Video Interviewing If you’re on the job search and part of an online recruiting process, check out these tips from our recruiting team on how to succeed at your next virtual interview.
-
How a "Just do it!" Mentality Led to Career Growth Mo, head of Transactions Processing for Consumer Operations and a 21-year Citizens veteran, recently shared in his own words the importance of continuously learning, growing and being encouraged by his mentors to pursue new career opportunities.
-
Curiosity and Commitment The career journey of Jessika, ESG Product Associate of Commercial Liquidity
-
FinLit Volunteers at Citizens During Financial Literacy Month (and every month), we celebrate our FinLit volunteers who help make a difference in their customers' lives and the community they're a part of.
-
Herb Teaches Financial Literacy in Boston's Chinatown Neighborhood Relationship Manager Herb exemplifies our Credo with his financial literacy work in Boston’s Chinatown.
-
Students & Data Science Enthusiasts Converge at the BrownU DataThon Some of our top minds in the data science field and enthusiastic undergraduate talent convened for a weekend of data discovery.
-
Meet Evan, active U.S. Army First Sergeant and Branch Manager in Derry, NH With the support of his branch colleagues and family, Evan is able to balance his role as First Sergeant for his unit and his Branch Manager position.
-
Mergers & Acquisitions Hub Mergers and acquisitions are part of our strategy. Citizens is ready to earn its place as a valued part of our new communities. We're here to listen and help our customers, colleagues and communities. Here are some questions you may have as a job seeker, candidate or current colleague of a company we recently acquired.
-
Our Locations Learn about the dynamic office locations and environments you could be working in as a Citizens colleague.
-
Seven Must-dos Before Applying to Your Next Job On the job hunt? Check out this list of 7 must-dos before you begin hitting those application buttons!
-
Eight Questions to Ask During your Interview Impress your potential employer by asking these questions at your next interview!
-
