Business Intelligence Engineer (On-Site)

Job description

Working Here | Experience Serving Your Community If you are looking to foster a fulfilling career path while serving your community, you are in the right place. All careers at CHAS Health allow you to make an impact on patient’s lives and our greater community. No matter what clinic or location you join, you become a part of the bigger picture – providing trustworthy, patient-centered, and attentive care to anyone who walks through our doors. We continue to expand operations and are regularly looking for talented and dedicated individuals to help us continue to make a difference in patient lives. 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. Compensation Range: $30.05 - $44.13 Check out our work perks here ! 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. * Offered benefits dependent upon employee eligibility and criteria Job Description: 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. Builds and maintains cubes (internal and client-facing). Optimizes database schemas, queries, cubes, and reports, implementing complex logic requirements. Conducts tuning reviews / assessments (DB and SQL tuning), reporting, and query monitoring. 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 the day from 25-40 lbs. Rarely is there a need to lift more than 41 lbs. Our core values are our foundation, the guiding sense of direction for our organization: Social Responsibility Patient-Centered Entrepreneurship Respect for Human Dignity Commitment to Continuous Quality Improvement Fun CHAS Health | 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.