Data Engineer

CHAS Health; Spokane (WA); On-site; USD 60,000 - 90,000; Full time

Benefits offered by this job

Annual milestone bonus

Robust health coverage

401(k) with employer match

Tuition assistance

Childcare reimbursement

CME and license fee reimbursement

Job summary

CHAS Health in Spokane is hiring a Data Engineer to enhance community health through superior technical support and customer service. Responsibilities include designing databases, implementing ETL routines, and optimizing existing data solutions using Microsoft SQL Server.

The ideal candidate will possess an Associate’s degree and experience with SSIS and healthcare data models. In addition to a supportive work environment, CHAS Health offers competitive compensation and a range of benefits.

Qualifications

• Prior experience in database development using Microsoft SQL Server, SSIS and SSAS preferred.
• Knowledge of healthcare data models preferred.
• Excellent problem-solving abilities and communication skills required.

Responsibilities

• Designs and implements databases and ETL routines.
• Works on multiple deadline-driven projects ensuring data quality.
• Optimizes database schemas, queries, cubes, and reports.

Skills

Database development

SSIS

SQL Server

ETL processes

Healthcare data models

Education

Associate’s degree or commensurate experience

Tools

Microsoft SQL Server

SSAS

Job description

## Data EngineerApplylocations: CHAS Health Administration - Spokane, WAtime type: Full timeposted on: Posted Yesterdayjob requisition id: REQ-666# **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.