Data Quality Analyst

About Capgemini <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

With more than 170,000 people in over 40 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2014 global revenues of EUR 10.5 billion. Together with its clients, Capgemini creates and delivers business and technology solutions that fit their needs and drive the results they want. A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model.

Learn more about us at http://www.capgemini.com/ .

 

Rightshore ® is a trademark belonging to Capgemini

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

 

 

Title – Data Analyst

 

Analyst will support the Senior DQ Measurement Manager to conduct analysis of profiling and metrics results. Location is New York.

Duties & Responsibilities:

 

This position requires someone who has experience analyzing data sets or data results (e.g. profiling results, results reporting) to draw inferences and identify adherence, or lack thereof, to business requirements.

For Example: Candidate should be able to determine in the database that there are similar dates for a large number of securities and identify if that is related to any other patterns within the data. (e.g. Date of record is set to when a tranche of securities was purchased via acquisition of a portfolio from another bank).

Needs to be able to interface with end business users to:

Educate them on how the profiling was done on the data and what rules were applied

Articulate data findings in a manner that is understandable to a business team.  Also, they will need to work with the business team to confirm or modify requirements and rules based on the findings.

For Example: Candidate should be able to explain that there is a pattern seen within the securities and be able to explain if that pattern does or does not match provided requirements or if it should be a new requirement.

A general knowledge of Financial products and concepts is needed to interact with end business users.

The user should have experience working with data within databases and reporting tools.

For Example: The candidate should be able to write SQL Statements to pull data from a database.

The user should have the ability to write data rules in a manner that is easily understood and implementable by a technical team.

For example: Candidate should be able to write rules such as: IF SECURITY_TYPE = “Purchased” then DT_Of_Rec = DT_Of_Purch

It is an added benefit or Nice to have if the Candidate has experience with:

Data quality concepts and processes.

Bug tracking tools such as (e.g. HP Quality Center, RTC)

 

 

About 5+ years of experience required

This role will work with the Chief Data Office (CDO) business and function leads to review data analysis results as well as create and/or modify business requirements and rules.

Experience working as a data analyst,  financial modeler, statistician

Good understanding of data management practices

Demonstrated knowledge of Financial Services (Banking, Wealth Management, and Capital Markets) business processes and resultant information needs: client, risk / regulatory / finance    

Previous experience with data quality tools preferred or nice to have

Skill, Experience & General information required:

 

Basic Technical Requirements 

 

Experience with data quality tools preferred or nice to have

Ability to conduct analysis on the data using database querying, excel, and other methods

Ability to write data rules using pseudocode

  

Desirable Skills

 

Demonstrated knowledge of Financial Services (Banking, Wealth Management, and Capital Markets) business processes and resultant information needs: client, risk / regulatory / finance    

 

Location:-NYC,NY