Database Management Analyst Jobs in Rhode Island

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 https://jobs.citizensbank.com  and apply online (Job ID: 49054) or email resume and cover letter to Recruiting@Citizensbank.com with subject line: 49054.

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.