Healthcare Data Analyst

Summary

Join MedeAnalytics, an innovative healthcare data company, as a highly experienced Healthcare Data Analyst. This client-facing role involves collaborating with internal and external teams to analyze large datasets, build reports and dashboards, and provide analytical expertise. You will lead data model design, development, and support, ensuring data quality and standardization. The ideal candidate possesses extensive experience in healthcare data analysis, SQL, BI tools, and data modeling. MedeAnalytics offers a competitive salary and benefits package, including comprehensive health insurance, retirement plan, paid time off, and professional development opportunities.

Requirements

• Possess a Bachelor’s Degree (Bachelor of Science, Computer Science or equivalent); advanced degree (MS or MBA) preferred
• Have 3+ year(s) of experience in working with MEDITECH Expanse, Cerner, Allscripts or Epic health information systems and/or 3 + years of relevant professional work experience with complex analysis background in healthcare data, HL7, C-CDA, HEDIS, CMS & STARS
• Possess expertise with standard healthcare terminologies and vocabularies (ICD, DRG, CPT, SNOMED CT, LOINC, NDC, Medispan, RxNorm, etc.)
• Have 2+ years of Enterprise Software Packaged/SaaS Integration experience
• Have 2+ years of Enterprise Integration Tool (Informatica is preferred) experience
• Have 3+ years of database design and construction, ETL, and data modeling with an understanding of relational and dimensional data models
• Have 3+ years of procedural programming and markup languages such as JAVA, JavaScript, Python, SQL, XML, and JSON
• Have 2+ years managing big data (Data transfer, import/export, storage, performance, and security) and MS OLAP
• Be familiar with data visualization tools, Data Lake, Git, and version control
• Be proficient in SQL and have experience using a BI tool
• Have up-to-date knowledge and understanding of HEDIS & CMS STARs measures’ technical specifications

Responsibilities

• Lead the design, development, and ongoing support of clinical and financial integrated data models and reports used by provider and payer management in decision-making
• Be responsible for designing new data structures, mapping data from client source data to our data models, writing SQL/SQL like scripts to load and transfer the data to databases and performing data analysis with ETL
• Lead ideation sessions using lean principles to develop, document and analyze present state process maps and develop future state models
• Conduct, assess and profile data mappings to adhere to specific data structures, ensuring data quality is clearly defined to meet requested business use cases
• Design, create and maintain accurate and efficient data models
• Summarize testing and validation results and be able to communicate and make recommendations on the best course for remediation
• Be resourceful in arriving at solutions using existing or available resources
• Participate in agile work environment, completing sprint deliverables on time
• Contribute to our evolving development and testing standards and best practices
• Utilize knowledge and experience in discrete data elements utilized in healthcare analytics
• Have experience querying data, data interpretation and report generation using modern analytics tools (i.e., Power BI)
• Work with product owners and business analysts on requirements and design
• Create and maintain comprehensive project documentation, using Mede’s standard technical templates, methodologies, and standards
• Engage consultatively with clients to assess and guide requirements specifications
• Conduct meetings, internal and with clients, to review integration progress, upcoming activities and deliverables required to fulfil the Integration project delivery
• Create and maintain data integrity by providing quality data profiling ensuring known constraints to operate in the Client’s environment

Preferred Qualifications

• Possess Epic certifications with a focus on analytical capabilities
• Possess CAQH certification and/or Certified Health Data Analyst (CHDA®)
• Have additional experience with ETL framework, Linux and open-source technologies
• Have 3+ years RDBMS and Cloud data platforms with preferred experience leveraging AWS, Mondrian, Oracle, Databricks, Vertica, Hadoop, Apache Spark, Mondrian & MongoDB

Benefits

• Great Medical, Dental, Vision benefits - Effective on the first of the month after your start
• Company paid Basic Life & AD&D Insurance, STD/LTD
• ROBUST Employee Assistance Program (EAP)
• 401k with Company Match
• 9 paid holidays AND 3 floating holidays = 12 total!
• Paid Time Off (PTO) Accrual
• Employee Referral Bonus
• Professional Development