Michigan Veterans Jobs

Mobile michigan-jobbank Logo

Job Information

Capgemini Senior Data Analyst in Detroit, Michigan

About Capgemini

Capgemini is a global leader in consulting, digital transformation, technology and engineering services. The Group is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize their business ambitions through an array of services from strategy to operations. Capgemini is driven by the conviction that the business value of technology comes from and through people. Today, it is a multicultural company of 270,000 team members in almost 50 countries. With Altran, the Group reported 2019 combined revenues of €17billion.

Visit us at www.capgemini.com. People matter, results count.

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.

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

This support role will monitor all feeds from suppliers transferred to a staging area and then loaded into the Global ODS database. The loading of these feeds has been automated using server scripting that also includes SQL and SQL Loader.

These scripts are scheduled through Autosys. Additionally, this role will monitor and create new reporting from this database through Cognos. As a support role this person will be the first line of defense in the case of errors and warnings that may or may not lead to GM Production incidents, and must work towards immediate remediation. It is very important this person makes use of extensive Unix/Linux expertise, as well as script development and SQL capabilities.

Role Summary

The role of the Data Analyst is to distill information from data collected by the Connected Consumer Innovation Laboratory (CCIL) global Pilot capabilities. In this function, the resource will be called upon to provide detailed information regarding the performance of CCIL Pilot platforms, monitor the effectiveness of services being provided by the global environment and ensure that new initiatives are successfully integrated to maximize business benefits.

Key Responsibilities

  • Determines business service data capture requirements and the applicable data infrastructure resources to assure delivery

  • Trains and educates data consumer teams on data collection tools and equipment

  • Establishes data quality standards and works with data consumer teams to ensure standards are met

  • Reports on availability and data collection metrics for the various global Pilot service systems

  • Ensures data exchange and reporting systems are operational on a 24 x 7 basis

  • Provides access to data consumers and ensures the delivery of recurring data loads

  • Assists consumers with set-up, testing and implementation of data collection applications that support Pilot service data visibility

  • Troubleshoots data reporting errors and data quality issues

  • Ensures that all data application updates are properly installed and rolled out

  • Performs and documents procedures for data preparation including data cleaning, standardization and analysis- Develops data collection and evaluation methodologies, including format design, project criteria and requirements, data compilation, relevancy and usage

  • Prepares hourly, weekly, monthly, quarterly, annual and ad hoc data reports for distribution

  • Presents data at conferences and meetings where needed- Develops and maintains a data consumer access or limited access data research portal

Qualifications - Required

  • Bachelor's Degree in Science / Technology areas (Computer Science, Computer Engineering, etc.) or equivalent experience

  • A solid understanding of both UNIX-based (Linux, Solaris) and Microsoft Windows (2008, 7) operating systems. Adept at the use of performance analysis methods to tune systems, and resolve connectivity problems

  • Specific experience delivering data and reporting information from Oracle, MongoDB, MySQL, and Hadoop repositories

  • Proven practical experience programming in ETL / Unix Scripting- Perl, Unix/MS Windows Shells

  • Object Oriented Analysis and Design- Database schema design (logical and physical, NoSQL)

  • High degree of written and oral communication skills- Solid and wide-reaching foundation in programming (Scripting, SQL) and database structures (Relational, Object)

  • Proven experience working as part of a technical team to communicate the changes needed to maintain a database's stability, or speaking with business leaders to describe performance options for Pilot databases and security controls.

  • High degree of analytical capability where problems are unusual and complex- Report design and creation with Cognos, Tableau, and Quest Toad

  • Knowledge of analysis software (i.e. SPSS, SAS) and Business Intelligence and analytics competencies- In depth expertise with mathematical analysis (Arithmetic, Algebra, Calculus, Statistics)

  • Capable of handling multiple

Software Engineers perform requirements analysis. They then design, develop or maintain the physical application (components) or the application environment, based on the Software Architecture (models and principles). Activities include coding, integrating, implementing, installing or changing frameworks and standard components, or technical and functional application management. A Software Engineer also develops languages, methods, frameworks and tools, and/or undertakes activities in support of server-based databases in development, test and production environments.

Required Skills and Experience:

You have mastered several Software Engineering areas, applications or database environments. You act as a Software Engineering stream leader with technical delivery ownership within a (limited) number of technology areas. You contribute to bids or client proposals based on your technological expertise. You also act as a team leader with delivery ownership, and guide individuals and groups towards desired outcomes. You actively participate in at least one community and contribute to community discussions.

• Qualification: 7-10 years (3 years min relevant experience in the role) experience, Bachelor’s Degree.

• Certification: Should have SE Level 1 and seeking level 2.

• Should be proficient in Business Analysis, Business Knowledge, Software Engineering, Testing, Data Management, Architecture Knowledge and Technical Solution Design.

Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.

Job: Developer

Organization: DEMS

Title: Senior Data Analyst

Location: MI-Detroit

Requisition ID: 051848