Back to Job Search

Healthcare Data Analyst

Posted 26 days ago

  • Expiry Date: 19 August 2022
  • Referral:

Job Description:

  • These solutions typically involve extracting data from Client’s various relational databases, data cleansing, and reformatting into analytic data sets.

  • Solutions may also involve the design, testing, implementation, and ongoing maintenance of data marts.

  • Primary duties are outlined below.      

  • Assist with translating end-user data requests into technical specifications and specific data elements required for data set, report, or data mart development.

  • Assist with requirements elicitation for new reporting and data requests by interacting with end users.

  • SQL programming, testing, and performance tuning to fulfill data requests.

  • Manage and version control SQL scripts for re-usability.

  • Develop custom ETL jobs and/or packages to extract data from various sources and load them into the Client Data Warehouse or data marts.

  • Design and develop custom database schemas within the Data Warehouse, as needed.

  • Test reports and data extracts, and perform volume testing in live environments.  Ensure that customers are satisfied with data provided to them.

  • Monitor ETL executions and data-load processes as part of routine Data Warehousing operations.  Troubleshoot and resolve ETL job failures.  On-call support is sometimes required.

  • Design, implement, test, deploy, and manage data marts that align with the Data Warehouse architecture and enterprise data strategy.

  • Perform related duties as assigned or requested.


  • Bachelor degree in Computer Science or a related discipline; advanced degree preferred.

  • Minimum of 5 years’ experience working with electronic health record (EHR) and/or healthcare claims data; experience with Epic’s Clarity & Caboodle databases is strongly preferred.

  • Prior experience working with healthcare terminologies and code sets (e.g., ICD-10, RxNorm, LOINC, CPT), and building or using value sets for specific reporting use cases.

  • Ability to articulate technical and organizational approaches to meeting clinical data needs.

  • Team player with experience leading and collaborating cross-team to ensure successful delivery of solutions.

  • Fast learner with the ability to work both independently and in a team environment.

  • Highly proficient with SQL programming, and professional experience with multiple SQL dialects (e.g., Microsoft Transact-SQL, Oracle PL/SQL, PostgreSQL PL/pgSQL).  Ability to write complex SQL queries, scripts, and stored procedures.

  • Ability to assess query performance (e.g., query execution plans) and recommend improvements (e.g., query refactoring, indexing, table partitioning).

  • Experience with Microsoft SQL Server.  Experience with other relational databases (Oracle, PostgreSQL) is a strong plus.

  • Strong understanding of the principles of relational and dimensional data modeling.

  • Experience with software development best practices, including all phases of the Software Development Life Cycle (SDLC) and rigorous code version control with tools like Git or SVN.

  • Prior experience working in a research environment and/or knowledge of research Common Data Models (e.g., OMOP, i2b2, PCORnet, ACT) is a plus; experience with the OMOP Common Data Model is strongly preferred.

About ASK: ASK Consulting is an award-winning technology and professional services recruiting firm servicing Fortune 500 organizations nationally. With 5 nationwide offices, two global delivery centers, and employees in 42 states-ASK Consulting connects people with amazing opportunities

ASK Consulting is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all associates.