Manager Azure Cloud Infrastructure

JOB SUMMARY:
Hands on manager, who maintains and optimizes the Microsoft Azure infrastructure for the DVACO including virtual servers, databases and other cloud based applications that support Operations and Analytics functions for the DVACO. Works with external payers and venders to support monthly claims and roster loads that feed DVACO analytics platform. Maintain and create databases, views, ETL functions and stored procedures in conjunction with Operations and Analytics teams. Works in a DBA development capacity to assist with the integration of new data sets, optimize\automate system functions and assist the analytics team to build foundational layers for Power BI and other applications. Configures, maintains, recovers, and insures the performance of Relational Data Base Management Systems (RDBMS) on multiple database platforms. Manages three direct reports supporting integration and product development activities with Azure.

Essential Accountabilities:

Azure Cloud

1. Works with cloud vender and DVACO leadership to develop and strategies and deploy new capabilities that meet DVACO business requirements
2. Ensures Azure cloud configuration meets MLH IT security policies
3. Optimizes Azure cloud infrastructure while balancing budgetary considerations
4. Maintains Azure server infrastructure
5. Monitors server and application performance
6. Creates and tests disaster recovery plans
7. Maintains SFTP endpoints
8. Monitors Azure Download and Upload performance
9. Assists the development of appropriate testing methodology and migration paths for implementing changes

Product Development

1. Supports the agile development methodology by maintaining and monitoring existing scrum software solutions
2. Helps to prioritize technical development while working with scrum master support staff
3. Leads the product build cycle by developing, testing and rolling out new product code while working with the Operations and Analytics team
4. Leads the monthly refresh of the multi payer dimensional model and other data repositories

RDBMS Administration and Development

1. Develops and support changes to the clinical and claims multi payer dimensional model and other data warehouses, databases, etc.
2. Supports Power BI and other analytical products including the creation of necessary Dax queries
3. Configures, maintains, and insures performance of RDBMS applications
4. Designs and implements new physical RDBMS structures (i.e., tables, stored procedures and views) to meet business requirements
5. Analyzes, optimizes and documents any customized RDBMS structures (i.e., tables and views)
6. Insures recoverability of data bases
7. Diagnoses and resolves RDBMS outages and failures
8. Documents all configurations in writing

Extract, Transform and Load (ETL) and Automation

1. Develops and supports Microsoft Data Factory\Bricks environments including the creation of new pipelines, maintenance, etc.
2. Manages the regular upgrades to the Microsoft Data Factory\Bricks environments
3. Manages data feeds to and from Azure cloud to various venders and other parties
4. Transforms and loads data sets into RDBMS structures
5. Develops validation routines on data sets
6. Ensures accuracy of loads and extracts
7. Automates operations within the Azure cloud wherever possible

Primary Customers or Key Working Relationships:

1. DVACO Operations and DVACO Analytics Staff
2. External Venders

QUALIFICATIONS:

Education: Bachelor of Science in Computer Science is preferred.

Experience:
Expertise with the following functions demonstrated by at least (x) years’ experience:

1. Working knowledge of MS Data factory\Bricks – 1 year
2. Development and implementation of ETL and auto scripting capabilities – 3 years
3. Development and Support using Power BI or Similar Solution – 2 years
4. Maintenance, recoverability and performance of MS SQL Server – 3 years
5. Development and optimization of database tables, stored procedures and views – 4 years
6. Experience managing Azure or AWS Cloud capabilities – 2 years
7. DBA Support of software and\or analytics development team – 3 years

Technical Skills\Capabilities:

• MS Azure Cloud, Data Factory and Data Bricks
• MS Power BI or similar tool
• Maintains proficiency and expertise in MS SQL Server Components (Query Analyzer, SSRS, SSIS Analysis Server, Stored Procedures, Jobs, and Functions)
• Practical experience programming in Python or similar tools.
• Capable of programming in SAS, SQL Query Construction or other programming languages.
• Experience creating and maintaining stored procedures, tables, views, indexes, etc that support the software and analytics development
• Demonstrates strong mathematical, statistical, financial, technical, interpersonal, organizational, project management skills, and ability to maintain confidentiality.
• Evidence of independent analytical and problem solving skills.
• Exceptional time management and organizational skills.
• Ability to effectively handle numerous priorities simultaneously.

WORKING CONDITIONS:

This position requires the ability to handle multiple tasks simultaneously, remain effective under stress, and work hours outside the range of the regular schedule.

We are committed to the health and wellness of our employees. We offer competitive salaries, comprehensive benefits, generous paid time off, 403b savings plan, lucrative pension plan, tuition reimbursement, and more! Learn more about our benefits. If interested, please apply online at https://www.mainlinehealth.org/careers , Job ID 59501

We are an EOE/Veterans/Disabled/LGBTQ employer. Main Line Health celebrates our differences and our similarities. Learn more about our Diversity and Inclusion culture.

Applicants must certify that they have not used tobacco products or nicotine in any form in the 90-days prior to submitting an application to Main Line Health. This will be verified during pre-employment testing. We are an Equal Opportunity Employer. Please, no agency calls

Population Health Application Analyst III

JOB SUMMARY:
The Population Health Application Analyst III will be responsible for validating and interpreting data to support population health management analytical tools and applications. This position is seen as a subject matter expert and will lead DVACO governance committees and maintain ongoing relationships with vender management, DVACO leadership, POD (Jefferson and MLH) leadership, key third party staff, internal constituents and external customers at participating CIN organizations to gather information, share data and effectively move projects forward. Stays current with vender applications and manages upgrades and new releases across internal and external stakeholders. Provides guidance to less experienced analysts and proactively coaches and mentors others throughout the system.

ESSENTIAL ACCOUNTABILITIES:

• Ability to serve department as a subject matter expert.
• Works with Vice Presidents, Medical Directors, Clinical Operations, Finance, Network Contracting, IT and other POD departments or stakeholders.
• Provides supervisory guidance to less experienced analysts.
• Proactively coaches and mentors others throughout the system.
• Fully responsible for interpreting, organizing, executing, coordinating, evaluating, and communicating complex projects under the guidelines of leadership
• Demonstrates knowledge in the relevance/importance of work and its impact on operations
• Participates in all required meetings, educational overview sessions, product implementation and review sessions as communicated by leadership
• Communicates effectively within informal and formal channels, including written communications, presentations and informal communications with peers, management and business partners.
• Interacts with co-workers, visitors, and other staff consistent with DVACO values.
• Develops a deep understanding of the functionality of the population health applications to consult and strategize on complex issues and implement solutions
• Accountable for all aspects of payer contracts integration and implementation; data acquisition and data management, advanced SAS or SQL programming, quantitative and qualitative data analysis.
• Responsible for the coordination of interface between extractions from payer contract(s) from developing a deep understand of the patient attribution process to feed active member rosters, claims into population health application.
• Coordinates population health application design, interfaces, and development in accordance with user workflows for DVACO, JHS\MLH PODs, Clinical Integrated Network (CIN) and independent practices.
• Documents requirements and specifications for new/update application functionality/content
• Evaluates vendor requirements and specifications, prepares test cases, perform user acceptance testing (UAT) and data validation related to new/update application functionality/content
• Supports population health application users by documenting issues for the vendor, providing education to end user, and managing issues resolution
• Provides analytical support (consultation, design, analysis) to business units to understand and monitor performance as it relates to cost and quality.
• Interfaces directly with customers and management to negotiate requirements (understand customer needs and provide consultation on options to best meet that need) with customers to ensure optimal value and timely delivery.
• Provides business knowledge and anticipate business questions and needs.
• Identifies gaps in business reporting and proactively identifies and implements solutions.
• Achieves and maintains certification status in assigned application(s) and working knowledge of other related applications.
• Demonstrates initiative including recommending changes for improvement opportunities.
• Acquires knowledge about DVACO and JHS\MLH Pods system and processes, as required to support population health reporting.

Primary Customers or Key Working Relationships:

DVACO Leadership; DVACO, Jefferson and MLH Analytics Staff; DVACO Care Coordinators; DVACO Practice Transformation Team; DVACO Operations Team; DVACO and POD Clinical and IT teams; vender contacts

QUALIFICATIONS:

Education:

BS required in Population Health, Health Care Informatics, IT or data relevant field

Experience:

Minimum of 5 years related professional work experience in a progressive healthcare setting
required.

Technical Skills\Capabilities

• Experience with electronic medical record (EMR) systems
• Maintains proficiency and expertise in Health Plan data applications, business intelligence software and reporting tools that include, but are not limited to, MS SQL Server Components (Query Analyzer & coding, Analysis Server, Stored Procedures, Jobs, and Functions), Business Objects (Tableau, Qlik, Crystal Reports, Crystal Enterprise, Crystal Analysis), SAS, Microsoft Office (Word, Excel, PowerPoint, and Access) to prepare complex multi-factorial analysis. Synthesizes and Interprets analyses.
• Must possess a comprehensive understanding of clinical or payer operational processes and ability to evaluate impacts on data compilation and reporting.
• Knowledge of healthcare coding structures and payment methodologies.
• Advanced programming in SAS, SQL Query Construction or other programming language.
• Advanced understanding of relational database systems and uses.

Other Skills\Capabilities

• Demonstrates strong mathematical, statistical, financial, technical, interpersonal, organizational, project management skills, and ability to maintain confidentiality.
• Demonstrated strong business acumen.
• Effective verbal and written communication and presentation skills appropriate for communication with both external clients and senior management.
• Demonstrated evidence of independent analytical and problem solving skills.
• Exceptional time management and organizational skills.
• Ability to effectively handle numerous priorities simultaneously.
• Demonstrated ability to identify problem areas and take initiative to identify and implement appropriate solutions, self-motivated

WORKING CONDITIONS:

Position requires the ability to manage multiple tasks in a fast moving environment.

Exposures:

Individual must take proper precautions as outlined in Hospital Safety Manual, Infection Control Policy and Fire and Emergency Manual.

We are committed to the health and wellness of our employees. We offer competitive salaries, comprehensive benefits, generous paid time off, 403b savings plan, lucrative pension plan, tuition reimbursement, and more! Learn more about our benefits. If interested, please apply online at https://www.mainlinehealth.org/careers , Job ID 65567

We are an EOE/Veterans/Disabled/LGBTQ employer. Main Line Health celebrates our differences and our similarities. Learn more about our Diversity and Inclusion culture.

Applicants must certify that they have not used tobacco products or nicotine in any form in the 90-days prior to submitting an application to Main Line Health. This will be verified during pre-employment testing. We are an Equal Opportunity Employer. Please, no agency calls

Business Intelligence Developer Sr

JOB SUMMARY:
The DVACO Business Intelligence Developer Sr, is responsible for enhancing and supporting the DVACO Northstar suite of interactive Business Intelligence products. This role collaborates with organizational leadership teams to define requirements and develop meaningful solutions that connect the technical and business worlds while supporting the DVACO clinical strategy.

The Developer oversees the request and defines reporting objectives, analyzes data, creates visualizations , and deploys/maintains reports.

ESSENTIAL ACCOUNTABIITIES:

• Provide DVACO leadership with data, analysis, and insight necessary to ensure informed decision-making on key strategic issues.
• Combine data from multiple sources, including medical claims, provider, and third-party data to develop analysis.
• Work with the BI Product Manager to scope and execute new dashboard development while ensuring long term maintainability.
• Educate peers and clinical leadership on use of existing data tools to answer a business question
• Communicate effectively with all levels of staff to exchange information, ideas, and respond to inquiries
• Develop data insights and visualizations by preparing, modeling, and visualizing data.
• Choose the appropriate tool for a given analysis based on stakeholder requirements (excel, PBI or other)
• Serve as first point of contact for Analytics regarding internal and external questions related to assigned subject matters.
• Collaborate with stakeholders from initial request triage through final delivery.
• Anticipate roadblocks and proactively address issues before they impact business results.
• Communicate progress, escalations, and issues to DVACO’s Manager of Analytics and/or stakeholders as appropriate.
• Contribute to the vision and product roadmap for the business intelligence and visualization tools and define requirements across product, engineering and business teams to craft a suite of data solutions and features
• Work closely with key internal business stakeholders to understand user needs with data, identify gaps in our offerings and form product requirements
• Champion a culture of data informed decision making
• Ensuring successful product adoption by documenting, training and evangelizing use of the platform.
• Document and track project progress using Agile methods in project management tools
• Provide backlog management, iteration planning, and elaboration of the user stories
• Define success criteria for testing and product acceptance
• Create and maintain documentation end users and internal processes.
• Take an active role in removing blockers to successful team completion of Release/Sprint Goals

Primary Customers or Key Working Relationships:
DVACO Leadership, DVACO, Jefferson and Main Line Health Senior Leaders and Analytics Staff, DVACO Care Coordinators, DVACO Practice Transformation Team, DVACO Operations Team, DVACO and Pod Clinical teams.

QUALIFICATIONS:

Education:

• Bachelors required. Master’s Degree a plus.
• 5+ years related professional work experience, preferably in healthcare or insurance setting.

Technical Skills\Capabilities

• Demonstrated ability to design, build, document, test, maintain and troubleshoot interactive dashboards and customize reports
• Experience with healthcare claims or EHR data
• Experience building data models using Power BI, Tableau, Qlik, or similar tool.
• Advanced SQL knowledge for data analysis and development of recurring procedures
• Experience with Microsoft Visual Studio and version control
• Expert user of Microsoft Office Suite of products (PPT, Excel, Access, Word, etc)
• Working knowledge of Python or R.
• Experience engaging with leadership level stakeholders
• Experience with Agile development methodology is a plus
• Outstanding communication, presentation and leadership skills
• Excellent organizational and time management skills
• Sharp analytical and problem-solving skills

Other Skills\Capabilities

• Demonstrated ability to work in a team atmosphere and establish excellent working relationships with all stakeholders
• Ability to prioritize and execute independently
• Experience with documentation
• Ability to mentor newer users and developers
• Creative thinker with a vision
• Excellent verbal and written communication skills including the ability to manage and influence stakeholders
• Good time management skills and the ability to successfully manage multiple, concurrent deliverables
• Attention to details

WORKING CONDITIONS:

Position requires the ability to manage multiple tasks in a fast moving environment.
This is a full-time telecommuting position.

Exposures:

Individual must take proper precautions as outlined in Hospital Safety Manual, Infection Control Policy and Fire and Emergency Manual.

We are committed to the health and wellness of our employees. We offer competitive salaries, comprehensive benefits, generous paid time off, 403b savings plan, lucrative pension plan, tuition reimbursement, and more! Learn more about our benefits. If interested, please apply online at https://www.mainlinehealth.org/careers , Job ID 67343

We are an EOE/Veterans/Disabled/LGBTQ employer. Main Line Health celebrates our differences and our similarities. Learn more about our Diversity and Inclusion culture.

Applicants must certify that they have not used tobacco products or nicotine in any form in the 90-days prior to submitting an application to Main Line Health. This will be verified during pre-employment testing. We are an Equal Opportunity Employer. Please, no agency calls

Population Health Data Scientist I

Description:
Could you be our next DVACO Population Health Data Scientist I?

Why work as a DVACO Population Health Data Scientist I with Main Line Health?

Make an Impact! The Population Health Data Scientist I is a full stack analyst responsible for producing highly visible analytics used to measure DVACO physician performance in Medicare and commercial Value Based Purchasing contracts. Specifically, this person will develop algorithms, dashboard applications, and other reporting to track and trend key performance metrics (quality of care and financial performance vs contract targets) using paid medical claims and other external data sources. This role engages from end-to-end, serving both in a technical/data engineering role as well as assisting or leading the development of new dashboards, reports, and other analytical solutions.

Develop and Grow your Career! Invest in furthering your education through seeking certifications or advanced degrees by taking advantage of our Tuition Reimbursement! This position is eligible for up to $6,000 per year based upon your Full or Part Time status.

Join the Team! Like our patients, the Main Line Health Family encompasses a wide range of backgrounds and abilities. Just as each of our patients requires a personalized care plan, each of our employees, physicians, and volunteers, bring distinctive talents to Main Line Health. Regardless of our unique design, we all share a purpose: providing superior service and care.

Position-Specific Benefits include: You are eligible for 6 weeks of paid time off per year. We also offer a number of employee discounts to various activities, services, and vendors… And employee parking is always free!
Position: Population Health Data Scientist I
Shift: 40hr/wk

Experience:

• Maintains proficiency and expertise in Health Plan data applications, state of the art business intelligence software and reporting tools that include, but are not limited to:
  • MS SQL Server or similar SQL database technologies (Dashboarding products like MS Power BI or Tableau
  • Python, R, or other statistical programming languages
  • Version control tools such as Git.
  • Data ingestion pipelines using cloud infrastructure (Azure, AWS, Google Cloud etc.)
  • Grouper and predictive modeling software
  • Microsoft Office (Word, Excel, PowerPoint, and Access)
• Able to present findings and explain analyses to non-technical audiences.

Education:
Bachelor’s degree required, preferably in data science, analytics, actuarial science, risk management or a related field.

Additional Information

• Requisition ID: 66694
• Schedule: Full-time
• Shift: Day Job
• Employee Status: Regular

We are committed to the health and wellness of our employees. We offer competitive salaries, comprehensive benefits, generous paid time off, 403b savings plan, lucrative pension plan, tuition reimbursement, and more! Learn more about our benefits. If interested, please apply online at https://www.mainlinehealth.org/careers , Job ID 66694

We are an EOE/Veterans/Disabled/LGBTQ employer. Main Line Health celebrates our differences and our similarities. Learn more about our Diversity and Inclusion culture.

Applicants must certify that they have not used tobacco products or nicotine in any form in the 90-days prior to submitting an application to Main Line Health. This will be verified during pre-employment testing. We are an Equal Opportunity Employer. Please, no agency calls

Practice Transformation Coach

JOB SUMMARY:
Supports Clinical Services and Operations Team in their effort to monitor outcomes and create ongoing performance improvement initiatives at DVACO. Will be working across DVACO and with multiple CINs and ACO Members, and multiple EMRs. Work as a member of the DVACO Team to study and monitor care processes in a quality infrastructure and use data to drive ongoing performance improvement throughout DVACO. Must be able to coordinate, interpret, and translate performance data, and critically review metrics; data should permit evaluation of opportunities to implement change and monitor ongoing results of clinical quality outcomes. Collaborate with DVACO Leadership team on ongoing opportunities for improvement in Clinical Operations, Quality, Risk Reduction, Patient Outcomes; this may be in response to regulatory, payer, entity & health system requests as it relates to clinical quality.

ESSENTIAL ACCOUNTABIITIES:

1. Acts on a consistent basis to support the Mission, Vision and Values of DVACO.
2. Support DVACO goals, strategies, and mission as directed by the Leadership team/ Manager Of Practice Transformation
3. Primary administrative and project manager support for practice transformation using principles of PCMH and the NCQA application process, including managing overall timeline, facilitate scheduling of practice meetings, coordination of educational webinars, and formulation/dissemination of meeting minutes, assist with design of corresponding data reports, verification of application details, coordination and facilitation of uploading survey documents, etc.
4. Will serve as a key member of the DVACO team to help transform the practices into allowing them to excel at providing excellent patient experience, and quality medical care. Will help practices to be well-positioned to meet requirements of CPC+ (Comprehensive Primary Care Plus) and the CMS MIPS (Merit-Based Incentive Payment System)/ACI (Advancing Care Information) programs. Maintain contact with practices and serve as additional resource to practices in regards to their work toward NCQA Recognition. Focused efforts include the implementation/ process redesign of:
   1. Population Management
   2. Patient Access to care
   3. Proactive Outreach
   4. Patient activation and goal setting
   5. Test and Referral tracking processes
   6. Integration of continuous performance improvement activities.
   7. Assists Manager of Practice Transformation in building a quality-based infrastructure into current operations structure.
5. Supports Manager of Practice Transformation/DVACO implement change required to achieve the clinical quality goals through development of routine feedback mechanisms, guidelines, etc.
6. Participate in practice improvement meetings, providing expertise, coaching and guidance as necessary.
7. Engage in problem-solving with practices to improve access and patient-centered care
8. Monitor and assess performance across different aspects of delivering patient-centered care
9. Encourage culture of continuous quality improvement in practice
10. Design and facilitate improvement projects to build foundational capabilities at a site in order to improve its performance
11. Serve as the primary liaison, teacher, coach, and facilitator for Primary Care practices participating in DVACO
12. Perform practice assessments to provide both a baseline understanding and the basis on which to develop the practice redesign plan
13. Meet regularly with Manager of Practice Transformation/DVACO to monitor progress and barriers. Reports concerns to Sr. Staff/Leadership.
14. Maintains tracking of project tasks and deadlines for team; assist Manager of Practice Transformation in meeting deadlines.
15. Assist DVACO leadership team and CMO with data design and presentation- as well as support front line staff with data translation, interpretation, and performance improvement efforts.
16. In collaboration with CMO, monitor consistency, validity, and reliability of data for quality and safety.
17. Assist CMO in design and implementation of quality assurance activities related to quality reporting.
    1. Serve as front-line contact for end- users in practices including documenting any user issues with accessing reports or data integrity concerns;
    2. Responsible for perform validation tests of data integration/validity as it relates to front end user interfaces.
    3. Responsible for relaying any data (in/out) /support issues to CMO/Manager of Practice Transformation.
18. Provide project coordination and administrative support for key DVACO quality and performance improvement initiatives that require substantial interplay between practices and DVACO.
19. Consistently observes and reviews practice workflow processes for new ways of improving efficiencies, streamlining processing/preparation of reports.
20. Supports entity wide staff training and education efforts related to quality projects and performance improvement opportunities.
21. Participates in key meetings and completes other duties as assigned.

QUALIFICATIONS:

Education:

Bachelor’s degree required with minimum 3 years’ healthcare experience. In lieu of degree, at least 5 to 7 years of relevant experience is required. Working knowledge of ambulatory care service delivery, clinical operations/ workflows, and clinical data analysis and reporting desired.

Licensures & Certifications:
PCMH CCE preferred but not required

Experience:

• Excellent communication skills, approachable work style and a willingness to take on complex organizational and clinical project management activities.
• Demonstrate strong/solid knowledge and skill with computers, spreadsheets and databases.
• Proficiency in software applications that include, but are not limited to Microsoft Word, Excel, and PowerPoint.
• Working knowledge of EMR and report development would be helpful, but not required.
• Must be highly organized with the ability to work well with people.
• Must have ability to work with highly sensitive and confidential information.

WORKING CONDITIONS:
Will be required to meet with large groups and organize meetings.

We are committed to the health and wellness of our employees. We offer competitive salaries, comprehensive benefits, generous paid time off, 403b savings plan, lucrative pension plan, tuition reimbursement, and more! Learn more about our benefits. If interested, please apply online at https://www.mainlinehealth.org/careers , Job ID 65334

We are an EOE/Veterans/Disabled/LGBTQ employer. Main Line Health celebrates our differences and our similarities. Learn more about our Diversity and Inclusion culture.

Applicants must certify that they have not used tobacco products or nicotine in any form in the 90-days prior to submitting an application to Main Line Health. This will be verified during pre-employment testing. We are an Equal Opportunity Employer. Please, no agency calls