Business Intelligence Engineer (On-Site)

CHAS Health; Iron Bridge (PA); On-site; USD 41,396 - 60,793; Full time

Benefits offered by this job

Annual milestone bonus up to $5,000

Health coverage (medical, dental, vision)

401(k) with employer match

Tuition assistance up to $7,500

Job summary

CHAS Health in Iron Bridge, Pennsylvania seeks individuals to improve community health by delivering superior customer service and technical support. The role involves designing databases, ETL routines, and enhancing data solutions while ensuring data quality.

Applicants should have an associate’s degree or relevant experience, with proficiency in Microsoft SQL Server and problem-solving abilities. Compensation ranges from $30.05 to $44.13 per hour, along with comprehensive benefits.

Qualifications

• Experience in database development using Microsoft SQL Server, SSIS, and SSAS preferred.
• Proficiency in building and optimizing SQL queries is necessary.
• Knowledge of healthcare data models is an advantage.

Responsibilities

• Design and implement databases, ETL routines, and OLAP solutions.
• Build and maintain cubes and optimize database schemas.
• Determine and enforce database policies and standards.

Skills

Database development

SQL queries

Communication skills

Problem-solving abilities

Education

Associate's degree or commensurate experience in a technical field

Tools

Microsoft SQL Server

SSIS

SSAS

Job description

Job Overview

Improve the overall health of the communities we serve by providing superior customer service and advanced technical support to ensure quality patient care and user satisfaction.

Essential Duties and Responsibilities

• Design and implement databases, ETL routines (using SSIS), stored procedures, and OLAP solutions, and provide support and enhancements to existing data solutions.
• Design and build normalized and denormalized database solutions using healthcare industry best practices for data warehousing for specific client requirements.
• Work on multiple concurrent deadline-driven projects while ensuring data quality and meeting service level agreements.
• Build and maintain cubes (internal and client-facing).
• Optimize database schemas, queries, cubes, and reports, implementing complex logic requirements.
• Conduct tuning reviews / assessments (DB and SQL tuning), reporting, and query monitoring.
• Determine, enforce, and document database policies, procedures, and standards.
• Perform other duties as assigned, including supporting the CHAS Health Mission and Core Values.

Qualifications

• Associate’s degree or commensurate experience in a technical field required.
• Prior experience in database development using Microsoft SQL Server, SSIS, and SSAS preferred; understanding performance, deployment, configuration, security, migration, and troubleshooting.
• Proficiency in building and optimizing SQL queries preferred.
• Previous experience building and supporting business intelligence / data warehousing solutions; knowledge of healthcare data models preferred.

Skills

• Excellent logical and problem‑solving abilities.
• Verbal and written communication skills required.
• Ability to work independently in a self‑directed environment, contribute to a team, maintain a positive attitude, and demonstrate very high attention to detail.
• Commitment to quality while working in a high availability environment.
• Commitment to supporting a safe and respectful environment.
• Valid driver’s license and insurance required.

Physical Demands

• Required to stand, sit, and be mobile up to two-thirds of the time.
• Required to read from text and computer screen over two-thirds of the time.
• Climbing or balancing, stooping, kneeling, or crouching occurs less than one-third of the time.
• Communicating occurs constantly throughout the day.
• Lifting occurs about half the time up to 10 lbs. and less than one-third of the day from 25-40 lbs.; rarely more than 41 lbs.

Core Values

• Social Responsibility
• Patient‑Centered
• Entrepreneurship
• Respect for Human Dignity
• Commitment to Continuous Quality Improvement
• Fun

Compensation and Benefits

• Compensation Range: $30.05 - $44.13 per hour.
• Annual milestone bonus for all eligible employees: $500 for each year worked, up to $5,000.
• Robust health coverage with employer‑offered medical, dental, vision, long‑term care, and life insurance.
• 401(k) with up to 6% employer match.
• More than six weeks of paid time off annually for full‑time employees.
• Tuition assistance and student loan repayment: up to $7,500 for childcare annually through reimbursement.
• CME and license fee reimbursement.

Equal Employment Opportunity

In order to provide equal employment and advancement opportunities to all individuals, employment decisions at CHAS Health will be based on merit, qualifications, and abilities. CHAS Health does not discriminate in employment opportunities or practices on the basis of race, color, religion, gender, gender identity and expression, sexual orientation, national origin, age, disability, or any other characteristic protected by law.