MS Expert Data Analytics Scientist - Business Intelligence

Job Locations US-CA-Whittier
Requisition ID
Posted Date
4 weeks ago(1/22/2018 5:39 PM)
Client Service/Support




Welcome to Allscripts! Our Mission is to be the most trusted provider of innovative solutions that empower all stakeholders across the healthcare continuum to deliver world-class outcomes. Our Vision is a Connected Community of Health that spans continents and borders. With the largest community of clients in healthcare, Allscripts is able to deliver an integrated platform of clinical, financial, connectivity and information solutions to facilitate enhanced collaboration and exchange of critical patient information.


The primary purpose of the Expert Data & BI Analytics Scientist role is to analyze large-scale data sets to discover trends, identify performance and quality metrics, and uncover optimization opportunities. Designs and develops enterprise-wide data analysis, scorecards and dashboard development and reporting solutions as well as fulfill ad hoc reporting requests. Other tasks as directed by Manager.


  • Analyze enterprise data warehouse and business intelligence systems to identify and document complex data mappings (ETL), relations, business rules, as well as functional and non-functional requirements.
  • Gather reporting and analysis requirements and translate into data models.
  • Provide analytical support to various departments within the organization including formulating metrics and quality targets.
  • Analyze and resolve data quality problems through appropriate process design strategies, including error detection and proposing error correction procedures, using automation wherever possible.
  • Recommend methods to collect, analyse and manage data to improve data quality and effectiveness of data systems.
  • Act as primary point of contact working with stakeholders to understand systems, processes and business needs.
  • Work closely with Legal, Compliance and Security/Privacy to ensure the highest level of Healthcare data protection and quality.
  • Support the Development Team during the software build process (consultancy, requirements definition, design, documentation, review, etc.)
  • Support the sales / pre-sales process by ensuring data meets the client needs and analysing development requirements from potential new sales prospects.
  • Define and develop dashboards/reports and ad hoc queries as requested in a simple and understandable format.




Academic and Professional Qualifications:

  • Bachelor’ Degree in Information Technology, Healthcare IT or Computer Science.



  • Minimum of 8+ years of experience.

  • Health IT experience preferred.
  • Familiarity with data modelling, database design, OLTP, OLAP and Big Data environments, structured and unstructured data processing, ETL processes and business intelligence tools and concepts required.

  • Advanced SQL skills required. Experience with MS SQL Server, RedGate and other similar SQL tools required.

  • Must have experience handling large amounts of data.


Travel Requirements:

  • Local travel as required within PIH Health System


Working Arrangements:

  • Hours required to complete projects/assignments.
  • Work is performed in a standard office environment with minimal exposure to health or safety hazards


At Allscripts, our greatest strength comes from bringing together talented people with diverse perspectives to support the technology needs of 180,000 physicians, 1,500 hospitals and 10,000 post-acute organizations across the globe. Allscripts offers a comprehensive compensation and benefits package, including holidays, vacation, medical, dental, and vision insurance, company paid life insurance and retirement savings.


Allscripts policy is to provide equal employment opportunity and affirmative action in all of its employment practices without regard to race, color, religion, sex, national origin, ancestry, marital status, protected veteran status, age, individuals with disabilities, sexual orientation or gender identity or expression or any other legally protected category. Applicants for North American based positions with Allscripts must be legally authorized to work in the United States or Canada. Verification of employment eligibility will be required as a condition of hire.


From a "VEVRAA Federal Contractor" We request Priority Referral of Protected Veterans


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with Allscripts for future communications and career opportunities.