Required Qualifications:
Bachelor’s Degree in Computer Science, Mathematics, Statistics, other applied science field.
Minimum of 5 years professional experience in a technical/data analyst role in a data driven environment.
Proficient knowledge of SQL –
Working with SQL server and Oracle; able to write sound, efficient, and proper SQL statements ensuring stability, reliability, and performance of databases.
Experience with stored procedures and able to query complex datasets and derive conclusions, including using all types of joins between multiple tables.
Skilled at optimizing large complicated SQL statements and knowledge of best practices.
3+ years’ experience in data mining, large scale data acquisition, transformation, and cleaning, both structured and unstructured data.
Experience with data modelling, data structure principles and designing database tables that facilitate efficient information retrieval.
Competency in data manipulation and analysis; accessing raw data in varied formats with different methods and analyzing and processing data.
The Data Analyst must have programming proficiency with analytical platform software and BI systems expertise including but not limited to Business Objects, SQL and Tableau.
Considerable experience with statistical tools and methods to incorporate statistical results into analyses.
Ability to turn vague concepts and asks into well-documented and effective business metrics and insights.
Strong knowledge and comfort level with Excel.
Preferred Qualifications:
Knowledge of PostgreSQL, Python and SSIS a plus.
Experience with the Cerner Electronic Medical Record and Population Health applications.
Mentor/direct junior programmer analyst team member(s).
Knowledge of HL7 transactions, Health Care Claims (837), and/or CCDA a plus.
Knowledge of, and exposure to, established standards of care presented by CMS, NCQA, AHRQ, IOM, The Join.
Experience with Tableau or other data statistical, visualization, and predictive modeling software.
Electronic health record review and abstraction ability and experience.
|