Business Intelligence Engineer (On-Site)
Purpose of Job
Improves 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 as follows:
Essential Duties And Responsibilities
- Designs and implements databases, ETL routines (using SSIS), stored procedures, and OLAP solutions in addition to providing support and enhancements to existing data solutions.
- Designs and builds normalized and denormalized database solutions using healthcare industry best practices for data warehousing for specific client requirements, using Microsoft SQL Server Database programming (stored procedures and database design).
- Works on multiple concurrent deadline-driven projects while ensuring data quality and meeting service level agreements.
- Buils and maintains cubes (internal and client-facing).
- Optimizes database schemas, queries, cubes, and reports, implementing complex logic requirements.
- Determines, enforces, and documents database policies, procedures, and standards.
- Performs other duties as assigned, including supporting the CHAS Health Mission and Core Values.
Qualifications
- Education/Experience: 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; as well as proficiency in building and optimizing SQL queries preferred. Previous experience building and supporting business intelligence/data warehousing solutions; and 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, demonstrate very high attention to detail, and a commitment to quality while working in a high availability environment is required. Commitment to supporting a safe and respectful environment is required. Valid drivers’ 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 day from 25-40 lbs. Rarely is there a need to lift more than 41 lbs.
Compensation Range
Competitive Compensation & Exceptional Benefits At CHAS Health Join a workforce that values your expertise as much as your wellbeing! CHAS Health's comprehensive compensation package* includes: Annual milestone bonus for all eligible employees! $500 for every 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 for a retirement plan that invests in your future.Work/life balance—enjoy more than six (6) weeks of paid time off (PTO) annually for full-time employees, to recharge and refresh.Tuition assistance and student loan repayment—let CHAS Health pay for your education!Up to $7,500 for childcare annually through reimbursement, to help you balance work and family life.CME and license fee reimbursement—we've got you covered.
Job Description
Challenging the status quo starts with you – get started today. Everyone Welcome From the beginning, we strongly believe that all people have the right to high-quality health care. Our goal is to remove barriers to care and provide high-quality, evidence-based care in a place that is convenient – in your neighborhood. We believe everyone deserves to be treated with dignity and respect regardless of their situation.