Albin Engineering Services, Inc. (www.aesi.com) is searching for a Data Reporting Analyst to work as an Albin Engineering employee, on a 6+ month contract for one of our premier clients, Apple, in the Cupertino area. For the right Data Reporting Analyst, the opportunity will become a longer-term project. As an Albin Engineering Employee, you qualify for our full benefit package. The Data Reporting Analyst will be working directly with various business groups to understand their business requirements to create appropriate reports and data analysis as needed. You will have the ability to work with large and complex volume data sets and must have a clear understanding of the full database system. You will be working with SQL source all the way up to the presentation of the results. Job Responsibilities: - Provide value-add analysis to Business units through use of meaningful reports and graphs - Draw conclusions from your analysis, and clearly communicate the results - Can clearly convey the key insights or “story” the data reveals in a visual format that is grouped, summarized, or formatted to be easily understood - Understand how data flows within various systems to provide input on requirements for databases to ensure data is organized properly for reporting/analytics - Work closely with our Data Quality team to ensure data integrity and completeness - Develop business requirements to drive functional specifications for reporting applications - Work with Business and cross-functional teams to thoroughly document reporting processes and systems Job Requirements: - Very proficient in SQL, Oracle, UNIX is a must - 4-5 years of strong SQL skills utilizing complex queries in a large data warehouse environment such as Oracle, DB2, and/or Teradata - 2+ years of strong Excel skills, including pivots, vlookups, conditional formatting, large record sets - 1+ years Unix experience with file manipulations and running SQL scripts - 4-5 years reporting experience involving both adhoc, fast turnaround requests, along with standardized scheduled reporting based upon large data sets and complex queries - Experience analyzing large, complex volumes of data - Strong data analysis skills with the ability to use MS Excel and other desktop products to prototype and display results - Experience with statistical analysis and visualization software such as SAS, JMP, R, Tibco Spotfire, Tableau - Strong business analysis skills, particularly around requirements gathering including facilitation, interviewing, to gather information and requirements from other business units - Hands-on experience with Data Query Business Intelligence Software (Business Objects, Cognos, Endeca) - Familiarity with enterprise database systems - Knowledge of or experience with product configuration, product lifecycle management, test engineering, and hardware manufacturing in a high tech, high volume environment - Outstanding written, verbal, and presentation skills is a MUST! - A self managed “do-er” and self-starter who works well in a fast-paced, dynamic, team-oriented environment - Highly responsive and adaptable to efficiently manage quick-turn, tactical projects - Able to work in an ambiguous environment with complex undocumented business logic and data flows - Being very inquisitive and be able to work solo and on a team to solve problems and draw conclusions - Additional language: Proficient in Mandarin would be a plus