Overview
On Site
Full Time
Skills
Control Flow Graph
ROOT
Documentation
Regulatory Compliance
Data Management
EDQ
Reporting
Issue Tracking
Finance
Emerging Technologies
Continuous Improvement
Computer Science
SQL
Apache Hadoop
Teradata
Database
Stored Procedures
Business Rules
Extract
Transform
Load
Datastage
IBM InfoSphere DataStage
Microsoft SSIS
Informatica
Talend
Flat File
Amazon Web Services
Amazon S3
Amazon Redshift
Snow Flake Schema
PL/SQL
IBM DB2
Big Data
Dashboard
Analytical Skill
Data Visualization
FOCUS
Microsoft Excel
Microsoft SQL Server
Microsoft SSRS
Tableau
Microsoft Power BI
Writing
MDS
Master Data Management
Data Quality
Quality Assurance
Performance Testing
Scalability
Acceptance Testing
Management
Military
Decision-making
Privacy
Legal
Job Details
Job Description
Citizens Financial Group, Inc. (CFG) seeks a Senior Solution Engineer for its Johnston, RI location.
Duties: Supports enterprise data quality support requests. Conducts data quality checks, monitors and remediates data quality issues, collaborates with data platform owners across the Enterprise Data Organization and with data content owners. Determines root causes of data anomalies, create remediation plans, articulates technical aspects of quantitative data issues, recommends solutions, develops and maintains documentation to ensure compliance with data management policy. Supports EDQ Mailbox service requests. Gathers requirements to support data quality checks for data quality monitoring interactive dashboards. Serves as a subject matter expert when designing data quality solutions. Creates robust reporting and issue tracking. Proactively uncovers financial data issues and develops processes and procedures for data quality models. Embraces emerging technologies to leverage new capabilities as part of continuous improvement and efficiency returns.
Requirements: Bachelor's degree in 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: Writing complex SQL queries using various data sources, including AWS Redshift, DB2, Oracle, SQL Server, Big Data Hadoop, Teradata, and Snowflakes to profile data, identify data anomalies and understand data patterns; Preparing complex data sets using database joins, self-joins, aggregate functions, rank functions, case statements, and stored procedures; Designing, developing, and maintaining ETL frameworks for Data Quality Business Rules using ETL tools including Ataccama, Datastage, SQL Server Integration Services (SSIS), Informatica, and Talend to read and write data from sources, including Complex flat files, AWS S3, Redshift, Snowflake, Oracle, SQL Server, DB2, and big data files; Building and supporting data visualization reports and dashboards on data quality health from analytical models, using data visualization tools including Web Focus, Excel Power Pivot, SQL Server Reporting Services (SSRS), Tableau, and Power BI to show monthly and quarterly data quality scores, number of DQ rules built, and defects reported; Writing complex datasets on MDS (Master data Services) and profile data for data quality checks; Performing end to end DQ application testing and performance testing with large data volume to test scalability of applications; and Providing UAT support for business users, documenting DQ processes and procedures in the form of job aid documents.
May telecommute from any U.S. location.
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 Solution Engineer for its Johnston, RI location.
Duties: Supports enterprise data quality support requests. Conducts data quality checks, monitors and remediates data quality issues, collaborates with data platform owners across the Enterprise Data Organization and with data content owners. Determines root causes of data anomalies, create remediation plans, articulates technical aspects of quantitative data issues, recommends solutions, develops and maintains documentation to ensure compliance with data management policy. Supports EDQ Mailbox service requests. Gathers requirements to support data quality checks for data quality monitoring interactive dashboards. Serves as a subject matter expert when designing data quality solutions. Creates robust reporting and issue tracking. Proactively uncovers financial data issues and develops processes and procedures for data quality models. Embraces emerging technologies to leverage new capabilities as part of continuous improvement and efficiency returns.
Requirements: Bachelor's degree in 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: Writing complex SQL queries using various data sources, including AWS Redshift, DB2, Oracle, SQL Server, Big Data Hadoop, Teradata, and Snowflakes to profile data, identify data anomalies and understand data patterns; Preparing complex data sets using database joins, self-joins, aggregate functions, rank functions, case statements, and stored procedures; Designing, developing, and maintaining ETL frameworks for Data Quality Business Rules using ETL tools including Ataccama, Datastage, SQL Server Integration Services (SSIS), Informatica, and Talend to read and write data from sources, including Complex flat files, AWS S3, Redshift, Snowflake, Oracle, SQL Server, DB2, and big data files; Building and supporting data visualization reports and dashboards on data quality health from analytical models, using data visualization tools including Web Focus, Excel Power Pivot, SQL Server Reporting Services (SSRS), Tableau, and Power BI to show monthly and quarterly data quality scores, number of DQ rules built, and defects reported; Writing complex datasets on MDS (Master data Services) and profile data for data quality checks; Performing end to end DQ application testing and performance testing with large data volume to test scalability of applications; and Providing UAT support for business users, documenting DQ processes and procedures in the form of job aid documents.
May telecommute from any U.S. location.
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.