Data Analyst III (Reporting Analyst) - CA in Irvine, CA at Apex Life Sciences

Date Posted: 1/29/2018

Job Snapshot

Job Description


  • The Reporting Analyst (Data Analyst III) is responsible for designing, creating and verifying data reports, metrics and visualizations of post market surveillance and sales data. 
  • The workflow is largely Business Objects reporting, followed by post processing in Excel. 
  • The work product supports management reviews and regulatory submissions, as well as other diverse areas of the business. 
  • The Analyst is responsible for project management of the reports, including defining and negotiating reporting requirements with various clients. 
  • A skilled analyst works in a highly collaborative manner, often educating clients on ways to address their data oriented problems. They document workflow, status, appropriate verification and approvals of reports. 
  • They also ensuring work product meets the requirements of clients, incorporating learning into future continuous improvement. 
  • The Analyst supports creation of aggregate safety reports, signal detection reports and presentations for various management reviews, including investigating safety signals, including use of statistical technique. 
  • The Analyst uses a wide variety of tools, especially Business Objects family of applications, advanced spreadsheet work and statistical packages. 
  • Support key business initiatives as required, providing statistical analysis, application design and interactive visualizations of data. 
  • MOST IMPORTANT is Business Objects experience and advanced Excel skills as listed below. Other platforms (listed below) instead of BO would be considered if we do not get BO experience. 

Education and Experience: 

  • Combination of Education and Experience to Satisfy one of the following three options: 
    • Master’s degree in Computer Science (or equivalent) with 1+ years of experiences or 
    • Bachelor’s degree in Computer Science (or equivalent) with 1+ years of experience or 
    • Bachelor’s degree in sciences or engineering plus 1+ years of experience in report and query creation using database query or report tools. 
    • 2+ years of experience in the Device or Pharmaceutical industry highly preferred 

Essential Skills and Abilities: 

  • Experience in Business Object (BO is most preferred. Will consider candidates with other similar query and report tools such as DOMO, Tableau, Spotfire, MS Power BI, etc.) 
  • Ability to design and create Business Object (or equivalent… BO preferred), queries and reports. 
  • Advanced ability with Excel spreadsheets such as Pivots, nested functions in formulas, vlookups,. 
  • Ability to work collaboratively with clients to generate reporting requirements. 
  • Ability to translate user needs (requirements) into business solutions. 
  • Ability to document user requirements. 
  • Extensive computer proficiency. 
  • Other skills as listed in the job description.