"Alerted.org

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 (https://bluestonemd.com/2023/09/bluestone-aco-delivers-excellent-care-to-medically-complex-elderly-patients-saves-medicare-26-6-million/) 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.

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

Powered by JazzHR