Bluestone Physician Services · 20 hours ago
BI/Data Engineer (Must be local to Twin Cities, MN Metro Area)
St. Paul, MN
Full-time
Hybrid
Mid, Senior Level
$110K/yr - $135K/yr
3+ years expBluestone Physician Services is dedicated to delivering exceptional care to patients with complex conditions. The BI/Data Engineer will be responsible for executing the data strategy, building data pipelines, and ensuring data quality to support clinical and operational teams.
Health CareMedical
No H1B
Responsibilities
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
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
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
Qualification
Required
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
Deep familiarity with Snowflake or Google BigQuery
Strong proficiency in LookML
Proven experience working with healthcare data standards and compliance requirements
Familiarity with extracting data from REST/SOAP APIs
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
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
Company
Bluestone Physician Services
Bluestone Physician Services is a medical practice company that provides geriatrics and integrated care solutions.
501-1000 employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
The Blue Venture FundWindRose Health Investors
2021-08-02Private Equity
2021-04-14Private Equity
Leadership Team
Rajiv Patel, MD, MBA, FACP
Chief Executive Officer
David Nelsen
Chief Financial Officer
Recent News
2023-12-22
Company data provided by crunchbase