What are the responsibilities and job description for the Senior Data Analyst position at Citizens Bank?
Job Description
Citizens Financial Group, Inc. (CFG) seeks a Senior Data Analyst for its Johnston, Rhode Island location.
Responsibilities:
Participate in the design, development and implementation of business intelligence tools to provide quality information and data driven insights to our business partners to facilitate improved decision making.
Work with functional teams to access and understand data elements and identify process improvement opportunities.
Conduct source system/data analysis and data profiling.
Extract, Transform and Load data from data sources using SQL, API and Alteryx.
Analyze KPIs and present them as Dashboards using Tableau.
Provide support, monitor, and maintain existing Dashboards and Data Extraction process.
Undertake data mapping from source to target and define transformation rules that meet the models created by Data Architects.
Execute unit test of data populated in target data container, validating expected result and ensure quality & accuracy.
Coordinate with business users for User Acceptance Test and with Operations team for code deployment to upper environments.
Qualifications:
Requires a Master's degree in Analytics, Data Analytics or related field and 4 years of experience in the position offered, BI Developer, or a closely related position. Alternatively, employer will accept a Bachelor's degree in the specified fields and 6 years of the specified progressive, post-baccalaureate experience.
Must have at least 4 years of experience with the following:
Utilizing advanced features in Tableau Desktop, including: parameters, LOD expressions, row-level security, set actions, parameter actions, data blending, geo spatial mapping, regression models, clustering, forecasting, Tabcmd and Dashboard Extensions to develop and maintain production reporting within an SDLC framework;
Leveraging skills in Tableau Server Administration, including: managing projects, permissions and dashboard deployments to develop and maintain production reporting;
Troubleshooting Tableau performance issues by decoding error codes to identify key issues;
Utilizing Tableau's order of execution;
Utilizing Tableau's JavaScript and REST API;
Working with Tableau's PostgreSQL database and related tables;
Utilizing experience with advanced SQL Queries to extract data from Netezza, Oracle, Redshift and Microsoft SQL Server databases for ingestion into Tableau;
Utilizing R and Python programming experience to develop predictive models and incorporate results in a Tableau dashboard;
Building efficient Alteryx workflows and data pipelines to Extract/Transform/Load (ETL) Adobe Analytics clickstream data into Tableau to develop actionable end user reporting;
Developing SAS Enterprise Grid Procedures to extract and normalize data from multiple databases for ingestion into multiple databases; and
Building user segments and analyzing digital user behavior data, pathing and traffic patterns within Google Analytics and Adobe Analytics in order to develop Tableau reports.
100% telecommuting permitted from any US location.
Worksite: One Citizens Bank Way, Johnston, RI 02919 United States, 40 hrs/wk. EO employer.
For summary of benefits and to apply visit our website at and apply online (Job ID: 49054) or email resume and cover letter to with subject line: 49054.
Direct applicants only.
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.
Citizens Financial Group, Inc. (CFG) seeks a Senior Data Analyst for its Johnston, Rhode Island location.
Responsibilities:
Participate in the design, development and implementation of business intelligence tools to provide quality information and data driven insights to our business partners to facilitate improved decision making.
Work with functional teams to access and understand data elements and identify process improvement opportunities.
Conduct source system/data analysis and data profiling.
Extract, Transform and Load data from data sources using SQL, API and Alteryx.
Analyze KPIs and present them as Dashboards using Tableau.
Provide support, monitor, and maintain existing Dashboards and Data Extraction process.
Undertake data mapping from source to target and define transformation rules that meet the models created by Data Architects.
Execute unit test of data populated in target data container, validating expected result and ensure quality & accuracy.
Coordinate with business users for User Acceptance Test and with Operations team for code deployment to upper environments.
Qualifications:
Requires a Master's degree in Analytics, Data Analytics or related field and 4 years of experience in the position offered, BI Developer, or a closely related position. Alternatively, employer will accept a Bachelor's degree in the specified fields and 6 years of the specified progressive, post-baccalaureate experience.
Must have at least 4 years of experience with the following:
Utilizing advanced features in Tableau Desktop, including: parameters, LOD expressions, row-level security, set actions, parameter actions, data blending, geo spatial mapping, regression models, clustering, forecasting, Tabcmd and Dashboard Extensions to develop and maintain production reporting within an SDLC framework;
Leveraging skills in Tableau Server Administration, including: managing projects, permissions and dashboard deployments to develop and maintain production reporting;
Troubleshooting Tableau performance issues by decoding error codes to identify key issues;
Utilizing Tableau's order of execution;
Utilizing Tableau's JavaScript and REST API;
Working with Tableau's PostgreSQL database and related tables;
Utilizing experience with advanced SQL Queries to extract data from Netezza, Oracle, Redshift and Microsoft SQL Server databases for ingestion into Tableau;
Utilizing R and Python programming experience to develop predictive models and incorporate results in a Tableau dashboard;
Building efficient Alteryx workflows and data pipelines to Extract/Transform/Load (ETL) Adobe Analytics clickstream data into Tableau to develop actionable end user reporting;
Developing SAS Enterprise Grid Procedures to extract and normalize data from multiple databases for ingestion into multiple databases; and
Building user segments and analyzing digital user behavior data, pathing and traffic patterns within Google Analytics and Adobe Analytics in order to develop Tableau reports.
100% telecommuting permitted from any US location.
Worksite: One Citizens Bank Way, Johnston, RI 02919 United States, 40 hrs/wk. EO employer.
For summary of benefits and to apply visit our website at and apply online (Job ID: 49054) or email resume and cover letter to with subject line: 49054.
Direct applicants only.
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.