Senior Data Engineer

Job 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.

Required Qualifications

• 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

About Us

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 statparenthood, 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.

Equal Employment and Opportunity Employer

Job Applicant Data Privacy Policy

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.