IT Data Engineer I - IT DATA ANALYTICS - Full-time - Day - Lawrenceville, NJ

Capital Health is the region's leader in providing progressive, quality patient care with significant investments in our exceptional physicians, nurses and staff, as well as advanced technology. Capital Health is a dynamic health care resource accredited by the DNV that includes two hospitals, an outpatient center, satellite ED, and an expansive network of primary and specialty care. Capital Health Medical Group is made up of more than 600 physicians and other providers who offer primary and specialty care, as well as hospital-based services, to patients throughout the region.

Capital Health recognizes that attracting the best talent is key to our strategy and success as an organization. As a result, we aim for flexibility in structuring competitive compensation offers to ensure we can attract the best candidates.

The listed pay range or pay rate reflects compensation for a full-time equivalent (1.0 FTE) position. Actual compensation may differ depending on assigned hours and position status (e.g., part-time).

Pay Range:

$86,964.80 - $113,672.00

Scheduled Weekly Hours:

40

Position Overview

SUMMARY (Basic Purpose of the Job)

Supports the design, development, and maintenance of data pipelines and architectures for our healthcare data systems. This entry-level position will work under the guidance of senior engineers to ensure data integrity, quality, and availability to support clinical and operational decision-making. Additionally, the Data Engineer I will help maintain off-the-shelf vendor applications for data analytics and work closely with data analysts in the quality and finance departments to reduce manual processes by building automated pipelines and connections.

MINIMUM REQUIREMENTS

Education: Bachelor's degree in computer science, Information Technology, Data Science, or a related field.

Experience: 0-2 years of experience in data engineering, data management, or related fields.

Other Credentials:

Knowledge and Skills: Basic understanding of data modeling, ETL (Extract, Transform, Load) processes, and database management systems. Proficiency in SQL and at least one programming language (e.g., Python, R, Java). Familiarity with data visualization tools (e.g., Power BI, Tableau, Crystal Reports). Basic knowledge of cloud platforms (e.g., Azure, AWS, GCP).

• Understanding of data modeling, ETL/ELT (Extract, Transform, Load) processes, and database management systems.
• Basic understanding of data modeling, database design, and data warehousing concepts.
• Understanding of data quality concepts, including validation, reconciliation, completeness, and accuracy.
• Familiarity with APIs, structured data formats, and application integration concepts.
• Proficiency in SQL and at least one programming language (e.g., Python, R, Java).
• Familiarity with data visualization tools (e.g., Power BI, Tableau, Crystal Reports; experience with Databricks a plus).
• Basic knowledge of cloud platforms (e.g., Azure, AWS, GCP).
• Strong analytical and problem-solving skills.
• Good communication skills, both written and verbal.
• Ability to work collaboratively in a team environment.
• Attention to detail and a commitment to data quality.

Preferred Technical Skills:

• Microsoft SQL Server

• Azure SQL Database

• SQL

• Python

• Databricks

• Microsoft Azure

• ETL/ELT tools

• REST APIs

• Familiarity with healthcare information systems, EMRs, or other healthcare data sources

Mental, Behavioral and Emotional Abilities: Strong analytical and problem-solving skills. Good communication skills, both written and verbal. Ability to work collaboratively in a team environment. Attention to detail and a commitment to data quality.

Usual Work Day:8 Hours  

 

ESSENTIAL FUNCTIONS

• Assist in the development, implementation, and maintenance of data pipelines.
• Support data extraction, transformation, and loading processes.
• Monitor and ensure the reliability, integrity, and efficiency of data systems.
• Collaborate with senior engineers and other stakeholders to understand data requirements and objectives.
• Perform basic data analysis and reporting as needed.
• Document data processes and workflows.
• Maintain off-the-shelf vendor applications for data analytics.
• Work closely with data analysts in the quality and finance departments and IT analysts to reduce manual processes by building automated pipelines and connections.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

Frequent physical demands include: Sitting, Keyboard use/repetitive motion
Occasional physical demands include: Standing, Walking, carry objects, Push/Pull, Twisting, Bending, Reaching forward, Wrist position deviation, Pinching/fine motor activities
Continuous physical demands include:
Lifting Floor to Waist 0 lbs. Lifting Waist Level and Above 0 lbs.
Sensory Requirements include: Accurate Near Vision, Accurate Far Vision, Color Discrimination, Accurate Depth Perception, Accurate Hearing

Anticipated Occupational Exposure Risks Include the following: N/A

This position is eligible for the following benefits:

• Medical Plan

• Prescription drug coverage & In-House Employee Pharmacy

• Dental Plan

• Vision Plan

• Flexible Spending Account (FSA)

- Healthcare FSA

- Dependent Care FSA

• Retirement Savings and Investment Plan

• Basic Group Term Life and Accidental Death & Dismemberment (AD&D) Insurance

• Supplemental Group Term Life & Accidental Death & Dismemberment Insurance

• Disability Benefits – Long Term Disability (LTD)

• Disability Benefits – Short Term Disability (STD)

• Employee Assistance Program

• Commuter Transit

• Commuter Parking

• Supplemental Life Insurance

- Voluntary Life Spouse

- Voluntary Life Employee

- Voluntary Life Child

• Voluntary Legal Services

• Voluntary Accident, Critical Illness and Hospital Indemnity Insurance

• Voluntary Identity Theft Insurance

• Voluntary Pet Insurance

• Paid Time-Off Program

The pay range 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 base salary and/or rate, several factors may be considered including, but not limited to location, years of relevant experience, education, credentials, negotiated contracts, budget, market data, and internal equity. Bonus and/or incentive eligibility are determined by role and level. 

The salary applies specifically to the position being advertised and does not include potential bonuses, incentive compensation, differential pay or other forms of compensation, compensation allowance, or benefits health or welfare. Actual total compensation may vary based on factors such as experience, skills, qualifications, and other relevant criteria.