Data Engineer
Company: Northwell Health
Location: Westbury
Posted on: January 25, 2023
Job Description:
Job Description
Job Description
Analyzes and implements information systems to manage financial
functions for Patient Financial Services/Accounts. Ensures systems
compliance to applicable laws, regulatory standards and
policies.
Job Responsibility
- Design, analyze code, optimize, and maintain Microsoft SQL
Server databases, tables, stored procedures, indexes, triggers,
data extraction, transformation, and validation.
- The ability to develop SSIS packages to address complex
business needs as well as troubleshoot and maintain existing SSIS
packages.
- Implements the information system initiatives to meet user
requirements; communicates with user departments and project teams
regarding implementation activities and system changes to ensure
feasibility; develops system specifications that appropriately meet
department requirements.
- Assesses the patient management inpatient and outpatient
registration pathways for constant improvement and enhancement;
incorporates financial regulatory requirements; administers system
support for patient management system users; evaluates information
technology to promote operational efficiency and financial
reimbursement.
- Oversees managed care contracts; compiles and tracks managed
care financial and statistical information related to contract
development and financial impact analysis; maintains rate database
and contractual terms of managed care contracts (prosthetics and
implants, MR copying charges, etc.).
- Develops systems to track data in comprehensive and innovative
ways; collaborates with hospital departments and outside vendors to
facilitate managed care contract implementation; facilitates the
implementation of managed care contracts.
- Responds to inquiries and interprets contract language as it
relates to managed care; coordinates and maintains communication
between the hospital and vendor(s) regarding system applications;
coordinates communication with the vendor representative regarding
enhancements, issues, etc. for the system applications.
- Reviews contractual obligations, ensures status of
deliverables, and resolves related issues; performs periodic
post-installation reviews of system initiatives.
- Reviews and evaluates post-installation processing per
documented specifications; creates ad-hoc reports to ensure system
builds are functioning according to specifications and ensures
accurate payments.
- Develops and conducts in-services for Patient Financial
Services/Accounts; creates appropriate in-service training
materials.
- Conducts system-wide in-services with managers and staff, as
necessary; ensures systems compliance to applicable laws,
regulatory standards and policies.
- Operates under general guidance and work assignments are varied
and require interpretation and independent decisions on course of
action.
- Performs related duties as required. All responsibilities noted
here are considered essential functions of the job under the
Americans with Disabilities Act. Duties not mentioned here, but
considered related are not essential functions.
Preferred Skills:
- 3+ years experience with Microsoft SQL Server
- Experience in SSIS
- Experience in reporting tools like SSRS and/or PowerBI
- Skilled at optimizing large, complicated T-SQL statements and
index design.
Job Qualification
- Bachelor's Degree required, or equivalent combination of
education and related experience. Minimum of two (2) years of
experience with Apache Hadoop, NoSQL, setting up cloud clusters,
Apache Spark, and other advanced data science and big data
technologies, required.
- Experience in software development in enterprise/ web/ cloud
applications, solutioning, architecture and frameworks.
- Big data expertise with cloud and enterprise level
design/implementation.
- Experience in architecting data warehouses and/or data lakes
with traditional database enterprise-class RDBMS technologies.
- Strong knowledge of programming languages/tools including:
Java, Python, Spark, SQL, R, and Shell Scripts.
*Additional Salary Detail
The salary range and/or hourly rate listed is a good faith
determination of potential base compensation that may be offered to
a successful applicant for this position at the time of this job
advertisement and may be modified in the future.When determining a
team member's base salary and/or rate, several factors may be
considered as applicable (e.g., location, specialty, service line,
years of relevant experience, education, credentials, negotiated
contracts, budget and internal equity).
Keywords: Northwell Health, New Rochelle , Data Engineer, Engineering , Westbury, New York
Didn't find what you're looking for? Search again!
Loading more jobs...