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

Bluestone Physician Services•Saint Paul, MN

5d•$110,000 - $135,000•Remote

About The Position

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.

Requirements

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.
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

Responsibilities

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.
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.
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.