Sr Data Analyst

Citizens • Westwood, MA

2d • $118,000 - $138,000 • Remote

About The Position

Citizens Financial Group, Inc. (CFG) seeks a Senior Data Analyst for its Westwood, Massachusetts location. This role involves translating business requirements into decisioning software logic designs, writing programming code, customizing decisioning application software, and performing quality assurance checks. The analyst will also be responsible for unit and integration testing, maintaining reference data, resolving production defects, diagnosing application issues, and creating post-implementation support documentation. Additionally, the role includes running queries to analyze customer interactions and mitigate anomalies.

Requirements

• Bachelor’s degree in Analytics, Statistical Modeling, Data Science, followed by two (2) years in the role or in a related position.
• Utilizing Pega PRPC, Java, JavaScript, and SQL for custom logic and data handling.
• Developing REST/SOAP services, connectors, and data pages to integrate with external systems.
• Using 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.
• Leveraging 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 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 using methods, including A/B testing and regression analysis, to validate and support key business initiatives.
• Performing data profiling tasks to ensure data 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.
• Leveraging SAS to automate the provisioning of datasets, ensuring data is pre-processed and ready for analysis or modeling.

Responsibilities

• Translating business requirements and information into decisioning software logic designs.
• Writing programming code, customizing decisioning application software, and performing appropriate quality assurance checks before hand-off to quality assurance colleagues.
• Performing unit and integration testing of new or modified business logic.
• Maintaining the required reference data for executing the decisioning logic, including offer compatibility.
• Resolving inquiries and service for the screening, prioritization, and resolution of production defects.
• Assisting in diagnosing application issues.
• Assisting in creating post-implementation support documentation.
• Running queries to analyze customer interactions and take actions to mitigate anomalies.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior