BI/Data Engineer (Must be local to Twin Cities, MN Metro Area)

St. Paul, MN

Full Time

Minnesota Professional, Clinical & Support Services

Experienced

Bluestone Physician Services delivers great outcomes by bringing exceptional care to patients living with complex, chronic conditions and disabilities. Our unique, robust model of care goes beyond primary care services — our multidisciplinary care teams collaborate with patients, their families and other healthcare providers to deliver care that is preventative, proactive and tailored to their unique needs.

Using an evidence-based approach focused on quality care management and data-driven medical decisions, Bluestone care teams collaborate to manage patients’ chronic conditions, address social determinants of health, manage transitions to and from inpatient settings, provide behavioral health support and more. Under our model of care, Bluestone patients experienced 21% fewer ER visits, 36% fewer hospitalizations and 41% fewer hospital readmissions compared to patients with similar conditions and complexities over the same time period.

Our care teams travel directly to patients who reside in Assisted Living, Memory Care and Group Home communities throughout Minnesota, Wisconsin and Florida and are supported by clinical operations and administrative colleagues who work remotely or at our corporate offices in Stillwater, Minnesota, and Tampa, Florida.

Our success is only possible through the hard work of our employees who bring our core values of Dedication, Excellence, Collaboration and Caring to life every day. Bluestone has been named to the Star Tribune's Top Workplace list for the 13th year in a row! Bluestone also achieved Top Workplace USA 2021-2025! In 2022, Bluestone Accountable Care Organization (ACO) was the best performing ACO in the country as measured by the overall savings per Medicare beneficiary.

Position Overview:

The BI/Data Engineer will play a key role in executing our data strategy, acting as the technical bridge between our raw healthcare data and the business insights used by our clinical and operational teams.

This is a hands-on execution role. You will work directly with our Data Architect and Data Analysts to implement scalable solutions, spending your time building robust data pipelines in Snowflake/BigQuery and developing a clean, user-friendly semantic layer in Looker.

Schedule: Full time position, regular business hours Monday thru Friday with the an infrequent need of working nights or weekends.

Location: This position will be a work from home position, and may occasionally come in-office located in downtown Stillwater, MN as requested.

Salary: $110k to $135k annually. Salary will be commensurate with experience.

*** Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Responsibilities:

1. Data Warehousing & SQL Transformation

Execute the Architecture: Build table structures and data models exactly as defined by the Architecture team while contributing to the design.
Advanced SQL Development: Write performant, version-controlled SQL to transform raw data (Claims, EHR, Enrollment) into analytical tables.
Performance Tuning: Monitor query performance and apply clustering/partitioning strategies to keep our warehouse (Snowflake or BigQuery) fast and cost-efficient.
Pipeline Maintenance: troubleshoot daily load failures and ensure data quality SLAs are met.
Collaboration & Stakeholder Support: Work closely with Business Analysts to ensure that stakeholder data requests are met and the correct data is available for reporting.

2. Looker & LookML Development

Semantic Layer: Manage the LookML repository, creating dimensions, measures, and derived tables that accurately reflect business logic.
Dashboard Support: Support business stakeholders by building complex Explores and troubleshooting dashboard performance issues.
Code Governance: Maintain a clean Git workflow, ensuring all LookML code is peer-reviewed and error-free before deployment.

3. Healthcare Data Compliance

HIPAA Adherence: Handle all data with strict adherence to HIPAA regulations, ensuring PHI (Protected Health Information) is only accessible to authorized users.

Security Implementation: Apply Row-Level Security (RLS) and Column-Level Security protocols within the database and Looker to enforce governance policies.

Qualifications:

Education/Certification/Experience

Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field.
3-5+ years of professional experience in Data Engineering, BI Development, or Analytics Engineering.

Knowledge/Skills/Abilities

SQL Mastery: You are an expert in SQL (Window functions, CTEs, JSON parsing) and can write complex transformations from scratch.
Cloud Data Warehouses: Deep familiarity with Snowflake or Google BigQuery.
Looker Expertise: Strong proficiency in LookML.
Healthcare Domain: Proven experience working with healthcare data standards and compliance requirements.
API Experience: Familiarity with extracting data from REST/SOAP APIs.
Scripting: Basic knowledge of Python for automation tasks.
Demonstrated compatibility with Bluestone’s purpose, core focus, and core values
Demonstrated ability to read, write, speak, and understand the English language

Bluestone Benefits:

Health Insurance
Dental Insurance
Vision Materials Insurance
Company paid Life Insurance
Company paid Short and Long-term Disability
Health Savings Account (with employer contribution)
Flexible Spending Account (FSA)
Retirement plan with 4% matching contributions
Eight (9) paid holidays for office closures plus two (1) floating holidays
Three weeks (15 Days) Paid Time Off (PTO)
Company sponsored cell phone, laptop and computer accessories

Apply for this position

Required*

First Name*

Last Name*

Email Address*

Phone*

Address*

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Cover Letter

Who referred you to this position? Enter their first and last name here.

What's your highest level of education completed?*

College or University*

Desired salary*

In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye!*

150

Which Business Intelligence (BI) tools have you used professionally to create dashboards and generate analytics? **

Are you legally authorized to work in the United States?*

Do you currently reside within a reasonable distance to commute to downtown Stillwater, MN?*

Will you now or in the future require sponsorship for employment visa status (e.g., H-1B visa status)?*

Are you proficient in Snowflake, BigQuery, Looker, or LookML? Please briefly explain level of experience with these systems.*

The following questions are entirely optional.

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Gender

Race/Ethnicity

Invitation for Job Applicants to Self-Identify as a U.S. Veteran

A “disabled veteran” is one of the following:
- a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
- a person who was discharged or released from active duty because of a service-connected disability.
A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Veteran status

I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE
I AM NOT A PROTECTED VETERAN
I DON’T WISH TO ANSWER

Voluntary Self-Identification of Disability

Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

Alcohol or other substance use disorder (not currently using drugs illegally)
Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
Blind or low vision
Cancer (past or present)
Cardiovascular or heart disease
Celiac disease
Cerebral palsy
Deaf or serious difficulty hearing
Diabetes
Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
Epilepsy or other seizure disorder
Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
Intellectual or developmental disability
Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
Missing limbs or partially missing limbs
Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
Partial or complete paralysis (any cause)
Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
Short stature (dwarfism)
Traumatic brain injury

Please check one of the boxes below:

YES, I HAVE A DISABILITY, OR HAVE HAD ONE IN THE PAST NO, I DO NOT HAVE A DISABILITY AND HAVE NOT HAD ONE IN THE PAST I DO NOT WANT TO ANSWER

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Name	Date

Human Check*

Submit Application