Analytics Engineer, Day Shift, Strategic Analytics

Adventist HealthCare; United States; Hybrid; USD 96,000 - 146,000; Full time

Benefits offered by this job

Medical, Prescription, Dental, and Vis

Vision coverage

Paid Time Off

Employer retirement contribution and 3

Tuition Reimbursement

Job summary

Adventist HealthCare is seeking an experienced Analytics Engineer for our Strategic Analytics Department to design, build, and optimize data pipelines, models, and reports. You will work with SQL Server, Snowflake, Power BI, and Tableau to support executive and operational decision making.

The role emphasizes data governance, data quality checks, and collaboration with stakeholders to translate requirements into scalable analytics solutions in a healthcare setting.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Data Analytics, Statistics, Finance, or equivalent.
• Experience with SQL Server, Snowflake, and complex SQL optimization.
• Hands-on experience with Power BI and Tableau dashboards.

Responsibilities

• Design, build, and maintain databases and data models; write and optimize SQL queries.
• Develop dashboards in Power BI and Tableau.
• Create ETL/ELT processes and data pipelines.
• Ensure data quality and governance across reporting assets.

Skills

SQL

Power BI

Tableau

ETL/ELT

Data modeling

Cerner Health data

Education

Bachelor’s degree in Computer Science, Information Systems, Data Science, Data Analytics, Statistics, Finance, or equivalent

Tools

SQL Server Management Studio

Snowflake

SQL Server

Job description

Adventist HealthCare seeks to hire an experienced Analytics Engineer for our Strategic Analytics Department who will embrace our mission to extend God’s care through the ministry of physical, mental, and spiritual healing.

Responsibilities

• Design, build, and maintain relational databases, data marts, and data models in SQL Server Management Studio, Snowflake, and comparable platforms; write and optimize complex SQL queries, views, and stored procedures to support analytics, reporting, and financial and operational modeling.
• Develop, maintain, and enhance interactive dashboards and self-service reporting in Power BI and Tableau, including data modeling, calculated measures, and visualization design, for financial, operational, productivity, quality, and regulatory performance reporting used by executive and operational leadership.
• Build and manage automated data pipelines and ETL/ELT processes that extract, transform, and integrate data from clinical, financial, and operational source systems (e.g., Cerner, cost accounting, and regulatory data feeds) into curated, analytics-ready datasets.
• Monitor and improve data pipeline performance, reliability, and query efficiency; implement data quality checks, validation routines, and version control to ensure accuracy and consistency across databases and reporting assets.
• Partner with Strategic Analytics team members and operational stakeholders to gather requirements, translate analytical needs into scalable data and reporting solutions, and support ad hoc data extracts and deep-dive analyses.
• Document data definitions, source mappings, business logic, and technical methodologies; establish and maintain data governance standards to ensure consistent, well-managed reporting across dashboards and databases.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Data Analytics, Statistics, Finance, or equivalent is required
• A technically proficient problem solver who can architect scalable data solutions and apply engineering best practices to novel and nuanced business and reporting needs.
• Demonstrated proficiency building and managing databases in SQL Server Management Studio, Snowflake, or comparable relational/cloud data platforms, including writing and optimizing complex SQL queries, views, and stored procedures.
• Hands‑on experience designing and developing interactive dashboards and reports in Power BI and Tableau, including data modeling, calculated measures, and performance optimization.
• Experience building and maintaining ETL/ELT processes and automated data pipelines, and integrating data across multiple source systems.
• Working knowledge of healthcare clinical and financial source systems; experience with Cerner Health data is preferred.
• Familiarity with data warehousing concepts, dimensional modeling, version control, and data quality and governance practices
• 2-4 years of experience in data engineering, business intelligence/dashboard development, database administration, or analytics development; healthcare or regulated‑industry experience preferred
• Bachelor’s degree in Computer Science, Information Systems, Data Science, Data Analytics, Statistics, Finance, or equivalent
• 2-4 years of experience in data engineering, business intelligence/dashboard development, database administration, or analytics development required.
• Healthcare data experience and experience with Cerner or other EMR health data preferred.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Data Analytics, Statistics, Finance, or equivalent is required
• A technically proficient problem solver who can architect scalable data solutions and apply engineering best practices to novel and nuanced business and reporting needs.
• Demonstrated proficiency building and managing databases in SQL Server Management Studio, Snowflake, or comparable relational/cloud data platforms, including writing and optimizing complex SQL queries, views, and stored procedures.
• Hands‑on experience designing and developing interactive dashboards and reports in Power BI and Tableau, including data modeling, calculated measures, and performance optimization.
• Experience building and maintaining ETL/ELT processes and automated data pipelines, and integrating data across multiple source systems.
• Working knowledge of healthcare clinical and financial source systems; experience with Cerner Health data is preferred.
• Familiarity with data warehousing concepts, dimensional modeling, version control, and data quality and governance practices
• 2-4 years of experience in data engineering, business intelligence/dashboard development, database administration, or analytics development; healthcare or regulated‑industry experience preferred
• Bachelor’s degree in Computer Science, Information Systems, Data Science, Data Analytics, Statistics, Finance, or equivalent
• 2-4 years of experience in data engineering, business intelligence/dashboard development, database administration, or analytics development required.
• Healthcare data experience and experience with Cerner or other EMR health data preferred.

Work Schedule: Employment Type: Full‑time
Hours per Week: 40 hours/week
Typical Daily Schedule: 8 am-5 pm Monday through Friday
Shift Type: Day Shift -Hybrid Schedule
Holiday Requirements: Follow the company holiday calendar
Pay Range: $96,058.56 - $145,995.20
If the salary range is listed as $0 or if the position is Per Diem (with a fixed rate), salary discussions will take place during the screening process.
Under the Fair Labor Standards Act (FLSA), this position is classified as: United States of America (Exempt)

Benefits

• Work life balance through nonrotating shifts
• Recognition and rewards for professional expertise
• Free Employee parking
• Medical, Prescription, Dental, and Vision coverage for employees and their eligible dependents effective on your date of hire
• Employer-paid Short & Long‑Term Disability, Basic Life Insurance and AD&D, (short‑term disability buy‑up available)
• Paid Time Off
• Employer retirement contribution and match after 1-year of eligible employment with a 3‑year vesting period
• Voluntary benefits include flexible spending accounts, legal plans, and life, pet, auto, home, long term care, and critical illness & accident insurance
• Subsidized childcare at participating childcare centers
• Tuition Reimbursement
• Employee Assistance Program (EAP) support

Adventist HealthCare was the first and is the largest healthcare provider in Montgomery County. If you want to make a difference in someone’s life every day, consider a position with a team of professionals who are doing just that, making a difference.

COVID-19 Vaccination Adventist HealthCare strongly recommends all applicants to be fully vaccinated for COVID-19 before commencing employment. Applicants may be required to furnish proof of vaccination.

Tobacco and Drug Statement Tobacco use is a well‑recognized preventable cause of death in the United States and an important public health issue. In order to promote and maintain a healthy work environment, Adventist HealthCare will not hire applicants for employment who either state that they are nicotine users or who test positive for nicotine and drug use. While some jurisdictions, including Maryland, permit the use of marijuana for medical purposes, marijuana continues to be classified as an illegal drug under the federal Controlled Substances Act. As a result, medical marijuana use will not be accepted as a valid explanation for a positive drug test result. Adventist HealthCare will withdraw offers of employment to applicants who test positive for Cotinine (nicotine) and marijuana. Those testing positive are given the opportunity to re‑apply in 90 days, if they can truthfully attest that they have not used any nicotine products in the past ninety (90) days and successfully pass follow‑up testing. ("Nicotine products" include, but are not limited to: cigarettes, cigars, pipes, chewing tobacco, e‑cigarettes, vaping products, hookah, and nicotine replacement products (e.g., nicotine gum, nicotine patches, nicotine lozenges, etc.).

Equal Employment Opportunity Adventist HealthCare is an Equal Opportunity/Affirmative Action Employer. We are committed to attracting, engaging, and developing the best people to cultivate our mission‑centric culture. Our goal is to have a welcoming, equitable, and safe place to work and grow for all employees, no matter their background. AHC does not discriminate in employment opportunities or practices on the basis of race, ethnicity, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, pregnancy and related medical conditions, protected veteran status, or any other characteristic protected by law. Adventist HealthCare will make reasonable accommodations for applicants with disabilities, in accordance with applicable law. Adventist HealthCare is a religious organization as defined under applicable law; however, it will endeavor to provide reasonable accommodations for applicants’ religious beliefs. Applicants who wish to request accommodations for disabilities or religious belief should contact the Support Center HR Office.

Our Mission: We extend God's care through the ministry of physical, mental and spiritual healing. Adventist HealthCare, based in Gaithersburg, MD., is a faith‑based, not‑for‑profit organization of dedicated professionals who work together each day to improve the health and well‑being of people and communities through a ministry of physical, mental and spiritual healing. Our comprehensive approach to caring for our community includes three acute‑care hospitals – Shady Grove Medical Center, White Oak Medical Center and Fort Washington Medical Center – as well as two Physical Rehabilitation hospitals, Outpatient centers, Imaging Centers, Urgent Cares, Home Care Services, Employer Health Programs and Physician Networks. We are nationally recognized and honored especially for our Cardiac, OB, Cancer, Stroke, Orthopedic, Rehabilitation and Mental Health services. Consider joining our team of over 6,000 employees and become part of one of the longest serving healthcare systems in the Washington, D.C., area that has a long‑standing tradition as the largest provider of charity care and community benefit in Montgomery County.