Sr. Data Architect, Professional Services Data Integration - Healthcare

MedeAnalytics is seeking a highly experienced Sr. Data Architect with a focus in healthcare.  This is a client facing position that plays a key role collecting data extracts from healthcare providers and payers.  The architect will provide clients with analytical consultative expertise and guidance.  Will lead the design, development, and ongoing support of clinical and financial integrated data models. Responsible for designing new data structures, mapping data from client source data to our data models, writing complex SQL/SQL like scripts to load and transfer the data to databases and performing data analysis with ETL. It is the responsibility of the Data Architect to ensure accurate and efficient data models.  Also consults and coaches project teams with regards to implementation of process improvement plans and strategies.  Leads ideation sessions using lean principles to develop, document and analyze present state process maps and develop future state models. Analyze where the end-to-end gaps exists and facilitate the development of those processes.  This position will act as a liaison, facilitating collaboration between core Mede and Professional Services teams.  This role will report to the Sr. Director of Professional Services at MedeAnalytics.

• The ideal candidate will have strong data modeling, data mapping & integration skills coupled with current experience in B2B, EAI, ESB, web services, service-oriented architectures, and standardized terminology services. Epic certifications with a focus on analytical capabilities is ideal.  Key to success in this position will require a strong understanding of healthcare data structures and business objects as well as industry standards, metrics,  and taxonomies (CMS, HL7/FHIR, CDA, HEDIS, STARS, HCC, etc.), specifically relating to healthcare providers and payers, and an ability to interact directly with clients. The Data Architect will be required to work in a team environment and will be responsible for full life cycle software development including new development, design/architecture, and implementation of B2B integration solutions. 

Essential Duties and Responsibilities: 

• 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.
• Summarizes testing and validation results and be able to communicate and make recommendations on the best course for remediation.
• 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.
• Knowledge and experience in discrete data elements utilized in healthcare analytics.
• Consistently goes above and beyond as a strong team player driving team success.
• Confidence partnering with other engineers of all levels.
• 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.
• Understand Mede solutions and integration project scope.
• Consultative engagement 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.

Education, Experience, and Required Qualifications:

• Epic certifications with a focus on analytical capabilities is ideal.
• 7 + years of Industry background in healthcare data, HL7, C-CDA and EMR/EHR systems such as Cerner or Epic or McKesson
• Expertise with standard healthcare terminologies and vocabularies (ICD, DRG, CPT, SNOMED CT, LOINC, NDC, Medispan, RxNorm, etc.)
• 7+ years of Enterprise Software Packaged/SaaS Integration experience.
• 7+ years of Enterprise Integration Tool (Informatica is preferred) experience.
• 7+ years of database design and construction, ETL, and data modeling with an understanding of relational and dimensional data models
• 7+ years of procedural programming and markup languages such as  JAVA, JavaScript, Python, SQL, XML, and JSON
• 7+ years managing big data (Data transfer, import/export, storage, performance, and security) and MS OLAP; additional experience with ETL framework, Linux and open-source technologies preferred.
• 7+ years RDBMS and Cloud data platforms with preferred experience leveraging AWS, Mondrian, Oracle, Databricks, Vertica, Hadoop, Apache Spark, Mondrian & MongoDB
• Familiar with data visualization tools, Data Lake, Git, and version control
• Bachelor’s Degree (Bachelor of Science, Computer Science or equivalent) strongly desired; advanced degree (MS or MBA) preferred.

Benefits Include:

• Fantastic 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
• and more!

Compensation Information:

• Base Salary Range: USD $125,000 - $150,000
  **Individual compensation packages are based on various factors unique to the candidate, including skill set, relevant experience, qualifications, and other job-related reasons.

This job description reflects management’s assignment of essential functions. Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.