Senior Data Engineer (Remote based in the US)

JOB SUMMARY

The Senior Data Engineer is primarily responsible for participating in the design, development, and implementation of solutions for the data warehouse.

The primary focus of the data warehouse includes data and analytics that support business operations including Clinical, Patient Accounting, and Corporate functions.

This role is cloud facing and requires hands on experience in building and managing data engineering code in modern cloud-based technologies such as Google Big Query or equivalent.

We are looking for a high energy individual willing to learn and evolve and would like to contribute to high impact healthcare environment.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Include the following. Others may be assigned.

• Assembling large, complex sets of data that meet non-functional and functional business requirements
• Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
• Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using GCP and SQL technologies
• Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics
• Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues
• Working with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
• Participates in unit and system testing and follow existing change control processes for promoting solutions to production system, escalating issues as needed.
• Design, develop, review, test, and deploy using CICD to facilitate the data warehouse solutions.
• Identifies data integrity issues and analyzes data and process flows for process improvement opportunities.
• Monitoring system performance and evaluate query execution plans for improving overall system performance.
• Perform code reviews and assist developers in optimization and troubleshooting.
• Participate in troubleshooting and maintaining existing solutions as required.

KNOWLEDGE, SKILLS, ABILITIES

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and / or ability required.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Ability to build and optimize data sets, big data’ data pipelines and architectures
• Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions
• Excellent analytic skills associated with working on unstructured datasets
• Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata
• Demonstrated understanding and experience using software and tools including big data tools like Kafka, Spark; relational SQL databases including Big Query or equivalent;

workflow management and pipeline tools such as Airflow, and object function / object-oriented scripting languages including Scala, C++, Java and Python.

• Strong SQL and relational database design / development skills
• Development experience with cloud-based modern data warehouses such as Google Big Query or equivalent.
• Working knowledge of hospital information systems and understanding of health care system integration
• Databricks, Data Lakehouse architecture, modern data pipelines experience a plus.
• Building near real-time data pipelines a plus
• Cerner, Meditech, CPSI, Allscripts, EPIC, McKesson, NextGen data integration experience a plus
• Excellent written and verbal communications skills
• Strong interpersonal skills- ability to communicate with all levels of customers, vendors, and IT resources

Conifer requires its candidates, as applicable and as permitted by law, to obtain and provide confirmation of all required vaccinations and screenings prior to the start of employment.

This may include, but is not limited to, the COVID-19 vaccination, influenza vaccination, and / or any future required vaccines and screenings.

EDUCATION / EXPERIENCE

Include minimum education, technical training, and / or experience preferred to perform the job.

• Bachelors’ degree from an accredited college / university in technology related field or equivalent combination of education, training, and experience.
• Prior experience with health information systems and / or patient financial service systems preferred

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Must be able to work in sitting position, use computer and answer telephone

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Office Work Environment

As a part of the Tenet and Catholic Health Initiatives family, Conifer Health brings 30 years of healthcare industry expertise to clients in more than 135 local regions nationwide.

We help our clients strengthen their financial and clinical performance, serve their communities and succeed at the business of healthcare.

Conifer Health helps organizations transition from volume to value-based care, enhance the consumer and patient healthcare experience and improve quality, cost and access to healthcare.

Are you ready to be part of our solutions? Welcome to the company that gives you the resources and incentives to redefine healthcare services, with a competitive benefits package and leadership to take your career to the next step!

Compensation and Benefit Information

Compensation

• Pay : $85,280.00 - $136,032.00 annually. Compensation depends on location, qualifications, and experience.
• Management level positions may be eligible for sign-on and relocation bonuses.

Benefits

Conifer offers the following benefits, subject to employment status :

• Medical, dental, vision, disability, life, and business travel insurance
• Paid time off (vacation & sick leave) min of 12 days per year, accrued accrue at a rate of approximately 1.84 hours per 40 hours worked.
• 401k with up to 6% employer match
• 10 paid holidays per year
• Health savings accounts, healthcare & dependent flexible spending accounts
• Employee Assistance program, Employee discount program
• Voluntary benefits include pet insurance, legal insurance, accident and critical illness insurance, long term care, elder & childcare, AD&D, auto & home insurance.
• For Colorado employees, Conifer offers paid leave in accordance with Colorado’s Healthy Families and Workplaces Act.

LI-NO3

MAJOR AREAS OF RESPONSIBILITY : Beginning with the most important, briefly state the major duties and responsibilities of this job, percent of total job, frequency of each activity and whether or not it is an essential function.

An essential function is a basic, necessary, and a required part of the job. Is this function necessary to fulfill the job duties? Priority

Duties & Areas of Responsibility

what this person does)

of Total Job (should 100%)

Frequency

daily, weekly, monthly,

Essential Functions?

yes / no)

1 Lead data and analytics projects across all business areas. 60% Daily Y 2 Design and Architecture best practices 30% As needed Y 3 Manage developers and mentor them for growth 10% Daily Y 4 Create a future roadmap for data and analytics, including emerging technologies.

10% As Needed N 5 6 SUBORDINATES : Employees supervised by this position Exempt Non-Exempt Total number of employees directly reporting to this position (if any) : 0 5 Total number of employees indirectly reporting to this position (if any) : 0 10

• Bachelors’ degree from an accredited college / university in business related or technology related field or equivalent combination of education, training, and experience.
• 8+ years of experience in information technology
• 5 + years of Data Modeling experience; Delivering both logical models and physical designs. MPP technologies preferred.
• 5+ years of Advanced SQL Coding / Tuning Experience in one or more of the following : Netezza, SQL server or Oracle.
• 2+ years of experience in a healthcare environment, preferable provider.
• Knowledge of healthcare industry and working with various billing, registration and EMRs is strongly preferable.
• Possesses sound analytical, problem solving, and critical thinking ments may be complex in nature and modifications may be broader than the application have the ability to think creatively and incorporate current technical solutions with the end user in mind.

Assigned projects may be complex in nature and impact more than one system application

• Lead teams within a matrixed organization
• Effective communication and interpersonal skills
• Experience with SQL and stored procedures in Microsft, Oracle or Netezza
• Understanding of Data Management / Metadata Management process and principles is essential.
• Helps develop data warehouse and strategic direction for the department.

Defines and ensures standards for technology and business process are established