Clinical Business Analyst

Title: Clinical Business Analyst

Unit: FAC FINANCE ADMIN

Duration: 3 Months contract (Temp to hire)

Location: New York, NY 10037

Shift Time: Monday–Friday, 8:00 AM–4:00 PM or 9:00 AM–5:00 PM. Onsite only.

Purpose of position:

Primarily responsible to build and maintain data infrastructure and analytical tools for support the department needs. Full stack data professional working with both engineering/modeling and analytical aspects of data to fulfill organization’s data and analytical needs

Summary of duties and responsibilities:

Build infrastructure (pipelines and automated processes) required for optimal extraction, loading and transformation of data from a wide variety of sources using SQL, python and/or other technologies as needed

Provide analytics to drive operations as well as decisioning across domains like VBP, Revenue & Expense, Ambulatory Care etc.

Assemble raw and disjointed data sets and transform into efficient data models that can be leveraged for tracking, reporting and financial operations

Identify, design and implement process improvements, automating manual processes and optimizing operational efficiencies

Work with cross functional stakeholders and partners to assist with data related issues and support their needs

Prepare ad-hoc and recurring reporting and analyses and build analytical tools to support senior management and executive decision making

Create reports and dashboards from EPIC and its data to provide visibility into key metrics and trends

Create routine data validation rules and processes to ensure completeness and integrity

As needed, assist with Financial reconciliations and planning with an eye towards automation to improve efficiencies

Maintain clear, organized and complete documentation of data operations and curated datasets at all time to maintain operational resiliency and ensure the data is fit for purpose

Analyze and document business requirements and processes communicate requirements to technical personnel through the construction of basic conceptual data process models and flowcharts

Identify performance improvement opportunities and resolution

Other related tasks and/or projects

Computer programs/software operated:

SQL and relational databases

Python

Tableau

ETL/ELT and data pipelines

Microsoft Office

Advanced Excel

Healthcare Data/Epic experience

Education:

Master or Bachelor Degree in Computer Science, Informatics, Analytics or related field plus 1 year of relevant experience or;

4 years of experience in data analytics, software programming or related field

Skills:

SQL

RELATIONAL DATABASES

PYTHON

DATA PIPELINES

ETL/ELT

Additional:

FINANCIAL RECONCILIATION

FINANCIAL PLANNING

BUSINESS REQUIREMENTS ANALYSIS

FLOWCHART CREATION

DOCUMENTATION

MICROSOFT OFFICE

ADVANCED EXCEL

HEALTHCARE DATA

EPIC EXPERIENCE

TABLEAU

DATA ANALYTICS

SOFTWARE PROGRAMMING

DATA MODELING

PROCESS IMPROVEMENT

CONCEPTUAL DATA PROCESS MODELING

EEO: “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”