028130-Applications Consultant 2 - MicroStrategy Lead with AWS RedShift RDS Database


• Lead and execute projects

• Lead Proof of Concept (POC) and Framework development

• Work with teams to assess business needs

• Provide quick Prototypes to demo concepts

• Provide both development and guidance to developers.

• Write Technical Specs and Design Documents

Required skills:

• Strong SQL Development skills and experience especially Teradata and AWS RedShift RDS

• Ability to write complex SQL themselves to perform data analysis, performance analysis

• Ability to review SQL to optimize, analyze and improve database SQL performance.

• Hands on experience with MSTR 9.0 and above

• Strong knowledge in MSTR Report Development, Report Testing, Report Tuning, Ad-hoc, Scheduling report delivery and Alerts

• Strong understanding of how MSTR interacts with reporting databases

• Must  have architected MicroStrategy  objects from the ground up to support scalable and optimized use of ad hoc elements and analytical dashboards.

• Should have extensive experience creating Public objects and schema objects to develop reports and dashboards

• Report development grids, graphs and dashboards

• Fine-tuned VLDB properties

• Automated Cube building process on System manager using incremental refresh reports.

• Data modelling experience

• Strong understanding of proper data modelling concepts, especially as they apply to data warehousing

• Ability to build out conceptual, logical and physical models from scratch in a dimensional model structure

• Ability to review existing data models to optimize, analyze and improve report performance

• Overall 10+ years is must on MicroStrategy Reporting

• Must be local to Chicago, IL (work location is Oak Brook, suburb of Chicago)

With their expertise in a specific technology environment, Applications Consultants are responsible for software-specific design and realization, as well as testing, deployment and release management, or technical and functional application management of client-specific package based solutions (e.g. SAP, ORACLE).

These roles also require functional and methodological capabilities in testing and training.

Required Skills and Experience:

You focus on building solutions and on maintaining, optimizing and improving a client’s applications and systems.

You contribute to a business and technical blueprint and customize the respective Software Package Core Module.

You may also be responsible for unit testing, contribute to integration testing, and/or be responsible for the design and delivery of end-user training.

• Qualification: Minimum 3 years experience, Bachelor’s Degree.

• Certification: Should have or seeking SE or ERP/SAP Level 1.

• Should be proficient in Package Configuration.

• Should have progressing skills in Business Analysis, Business Knowledge, Architecture Knowledge, Technical Solution Design and Vendor Management

About Capgemini

With more than 190,000 people, Capgemini is present in over 40 countries and celebrates its 50th Anniversary year in 2017.

A global leader in consulting, technology and outsourcing services, the Group reported 2016 global revenues of EUR 12.5 billion (about $13.8 billion USD at 2016 average rate).

Together with its clients, Capgemini creates and delivers business, technology and digital solutions that fit their needs, enabling them to achieve innovation and competitiveness.

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.
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.

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.


As part of the Capgemini Technology Services Group, this person will be responsible for the full systems lifecycle from requirements gathering through implementation of data analysis solutions.

This person will work closely with our clients and must demonstrate professional knowledge to ensure that the work products and deliverables are of the highest caliber to ensure client satisfaction.

This person will also apply subject matter expertise to identify, develop, and implement techniques to improve engagement productivity, increase efficiencies, mitigate risks, resolve issues, and optimize cost savings and efficiencies for each client.

Click the following link for more information on your rights as an Applicant: http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law