Principal Data Analyst

Principal Data Analyst, Business Banking Analytics Johnston, Rhode Island Citizens Financial Group, Inc. (CFG) seeks a Principal Data Analyst, Business Banking Analytics for its Johnston, Rhode Island location. Duties: Owns the roadmap, build, enhancement and maintenance of strategic data products that drive business decision making. Owns multiple data products and works alongside others to conceptualize, design, and build strategic solutions and ensuring products meets approved architecture patterns and governance. Manages linkages with centralized assets and engineering teams, including Salesforce, Master Data Management, and other Internal Customer Databases. Responsible for supporting a wide range of data analysis functions, and performing adhoc analysis to support strategic business needs. Responsible for enabling hardened data for business banking that allows performing insightful analytics to be consumed by data scientists and other advanced analytics professionals. Requirements: Bachelor’s degree in Electronics, Computer Science, Engineering, or related field, followed by five (5) years of progressive experience in the role or in a related position. Full term of experience must include: Designing, testing, and deploying ETLs and performing root cause analyses and defect resolutions; Fine tuning long running ETL jobs and SQL queries; Building reusable ETL components and implementing push down optimization for performance enhancement; Implementing disaster recovery and data security policies, including data tokenization solutions for EDW Datawarehouses; Implementing platform migration projects and orchestration tool migration projects; Building Spark applications for data extraction, transformation, and aggregation with multiple file formats; Migrating data using Sqoop from HDFS to Relational Database System; Implementing Hadoop Eco-system components; Deploying encryption techniques, compression, and replication for data processing needs; and Analyzing and addressing ETL transformation performance issues. May telecommute from any U.S. location. Direct applicants only. 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. 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. Apply To This Job