Reporting Analyst

Job description / Role

OnStar is a wholly owned subsidiary of General Motors and is the global leading provider of connected safety, security and mobility solutions and advanced information technology. With more than 6 million subscribers in the U.S., Canada and China, OnStar is available on more than 45 of our 2012 model year vehicles. OnStar is also available for installation on most other vehicles already on the road through its recently launched OnStar FMV. OnStar’s key services include: Automatic Crash Response, Stolen Vehicle Assistance, Remote Door Unlock, Turn-by-Turn Navigation, OnStar Vehicle Diagnostics and Hands-Free Calling.

OnStar Middle East is currently looking for a Reporting Analyst:

The IT Reporting Analyst supports all analytic efforts of the OnStar business including development of the reporting data requirements, reports creation and analysis, This role also supports business process improvement efforts through knowledge of the OnStar business processes and ability to work with the business to identify reports that would support the business direction. The analyst will also be responsible for supporting the IT reporting needs as part of continuous quality improvement efforts and optimization.

This role requires a thorough, detailed, creative, diligent, and sharp analytical candidate. The analyst will be responsible for both conceiving and writing necessary reports, and also will be responsible for analyzing the report results in order to identify trends and relevant artifacts associate with the data.

•Examines and evaluates purpose and content of business reports to develop new, or improve existing, format, use, and control.
•Reviews reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution, and purpose or function of report.
•Confers with persons originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements.
•Recommends the establishment of new or modified reporting methods and procedures to improve report content and completeness of information.
•May prepare and issue instructions concerning generation, completion, and distribution of reports according to new or revised practices, procedures, or policies of reports management.
•Understands and comprehends new system changes as they affect data, reports, and reporting systems
•Participate in application validation and QA efforts as they pertain to reporting, data, metrics, and report creation and execution
•Design, build, and implement new report formats and layouts on a customized basis.
•Prepare reports and analyze existing portfolios for trends and performance.
•Extract existing data to manipulate/calculate/format into presentable reports, charts, and graphs.
•Analyze data and reporting solutions to understand business impact, correlations/discrepancies, and to propose changes/alternate solutions.
•Build reporting solutions based on both existing and new requirements, prototypes, models, and delivery methods.
•Develop programs or queries to retrieve and analyze data for projects, program, or reports requiring sophisticated inferential techniques.
•Perform ad hoc analytical requests and research projects for internal parties. Special projects as assigned by management.
•Creates Scripts to automate repetitive tasks
•Maintain Code & Reports on an On-going basis

Requirements

Basic Skills Required:

•Bachelor of Science in Information Systems, Computer Science, or related field
•5 years of Information Technology experience
•Experience with Supplier Management
•Strong analytical & problem solving skills
•Excellent written and verbal communication skills
•Team oriented with good interpersonal skills and the ability to collaborate effectively with coworkers
•Appropriate interpersonal styles and communication methods to work effectively with business partners to meet mutual goals
•Ability to understand sophisticated mathematical models and concepts.
•Demonstrated ability presenting to small work groups on both technical and functional requirements and product management team
•The ability to interact professionally with a diverse group, including executives, managers, and subject matter expert

Technical Skills Required

•Advanced proficiency in MS Office, particularly Excel.
•Ability to utilize information delivery/report writing tools such as Crystal Reports, Cognos and Tableau
•Experience with databases such as Oracle and Microsoft SQL Server
•Good command over SQL*Plus, T-SQL etc.
•Experience writing complex SQL queries using analytical functions, multiple joins etc.

About the Company

General Motors Company (NYSE:GM, TSX: GMM), one of the worlds largest automakers, traces its roots back to 1908. GM and its strategic partners produce cars and trucks in 31 countries, and sell and service these vehicles through the following brands: Buick, Cadillac, Chevrolet, GMC, Holden, Isuzu, Jiefang, Opel, Vauxhall and Wuling. GMs largest national market is China, followed by the United States, Brazil, the United Kingdom, Germany, Canada and Russia. GMs OnStar subsidiary is the industry leader in vehicle safety, security and information services.

With its global headquarters in Detroit, GM employs 209,000 people in every major region of the world and does business in more than 120 countries. GM is headquartered in four major locations: GM Europe; North America (GMNA); South America; and GM International Operations (GMIO) is located in Shanghai, China. GMIO covers Asia Pacific and Middle East.

GM Middle East started in 1920s and the brands that are sold in the region are Cadillac, Chevrolet and GMC supported by a unique set of customer-focused services. GM parts and accessories are sold under the GM Parts and ACDelco brands. The regional office in Dubai covers the companys operations in Bahrain, Iraq, Jordan, Kuwait, Lebanon, Oman, Qatar, Saudi Arabia, UAE and Yemen in 20 dealerships.

GM has 2 facilities here in Middle East one is in Dubai World Trade Centre and the other, Middle East Distribution Corporation, which is located in Jebel Ali.