Sr Data Management Specialist

Description

Citizens Financial Group, Inc. (CFG) seeks a Senior Data Analyst for its Westwood, MA location.

Duties: Participate in the design, development, and implementation of data provisioning and support processes to deliver high-quality data and insights to our business partners for informed decision-making. Collaborate with cross-functional teams to gather and understand data requirements. Utilize Python, advanced SQL, and other data science techniques to access, manipulate, and prepare data for business-critical applications. Conduct thorough analysis and profiling of source systems and data elements. Work extensively with big data technologies such as Apache Spark and AWS Redshift to provision and manage large datasets. Develop complex queries and optimize relational databases for high-performance data retrieval. Create and maintain interactive data visualizations using Tableau and PowerBI to present key business metrics. Design and execute data model testing to validate the quality and accuracy of data in target systems. Troubleshoot data issues, ensuring data integrity and reliability across platforms, and optimize processes to address data inconsistencies.

Requirements: Bachelor’s degree in business, finance, mathematics, or related field. Must include the following, gained either through education or professional experience: Designing and implementing robust data pipelines to provision data from various sources, ensuring timely and accurate data availability for analytics and reporting; Leveraging Python, including NumPy, Pandas, Dask, and Scikit-learn libraries, and SQL to process, clean, and prepare data for models and business reports; Using R and SQL to analyze, query, and validate data across relational databases, ensuring data quality meets business requirements; Managing real-time data integration and provisioning using Apache Kafka to enable seamless data flow for business-critical applications; Developing and maintaining data solutions on big data platforms including Apache Spark, PySpark, and Hadoop, processing large-scale datasets to meet business needs; Implementing cloud-based data solutions using AWS Redshift to enable scalable data storage and high-performance querying for business intelligence; Designing and optimizing relational databases to store, retrieve, and provision structured data in accordance with business and analytics requirements; Utilizing Tableau and PowerBI to create customized reports and visualizations; Applying data mining techniques (including clustering and association) to discover trends, patterns, and anomalies in data, supporting business teams with actionable insights; Conducting statistical analysis and using methods such as A/B testing and regression analysis to validate and support key business initiatives; Ensuring smooth collaboration using Git for version control and GitHub for tracking code changes in data provisioning workflows; Performing data profiling tasks to ensure data from various sources is accurate, clean, and aligned with business objectives before provisioning to analytical environments; Maintaining continuous data provisioning using DBeaver for database interaction, enabling seamless integration with relational databases for data support; and Leveraging SAS to automate the provisioning of datasets, ensuring data is pre-processed and ready for analysis or modeling.

May telecommute from any U.S. location.

Direct applicants only.

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.