About Capgemini

With more than 193,000 people in over 44 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2016 global revenues of EUR 12.539 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 www.capgemini.com.

Rightshore® is a trademark belonging to Capgemini

 Capgemini America Inc 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.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship

Job Responsibilities

Job Title:Microsoft Data Analyst

Location: NYC, NY

Duties & Responsibilities:

  • Understanding Data Mapping is a big part of the project. Like ETL Process (Extract/Transform/Load into downstream applications build in MS SQL procedures, T-SQL, and SSIS packages)
  • Extremely good skills on the T-SQL side

Skill, Experience & General information required:

  • 7+ years of technical/data analysis experience
  • Proficient in SQL; ability to write and understand SQL Queries (conditional statements, nested functions, aggregations, self-joins, nested group by, having clause)
  • Basic Technical Requirements
  • Expert in SQL (T-SQL), data analysis using SQL queries
  • Ability to communicate clearly and articulate correctly to the audience

Desirable Skills:

  • Expert Excel (knowledge of VBA/macros a plus), Access, and other database programs/reporting platforms like oracle
  • Financial services experience with investment and asset management firms
  • Knowledge of SSRS, Talend, Spotfire or other database reporting packages is good to have
  • System design and data architecture/data modelling knowledge is good to have
  • Knowledge of SEI Trust 3000, Oracle, and Visual Studio is good to have

Apply now