BI Engineer

🔥 0 minutes ago

🦌 Connecticut – Remote

🦌 Connecticut – Remote

💵 $113.2k - $169.8k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Business Intelligence Developer

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Spire Orthopedic Partners

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 2021

🤝 B2B

🏢 Enterprise

B2B • Enterprise

Spire Orthopedic Partners is a forward-looking capital and management partner for leading orthopedic and spine surgeons, operating as a management services organization (MSO) that provides administrative infrastructure and strategic support. The company partners with high-growth orthopedic practices across the Northeastern United States (Connecticut, New York, Massachusetts, Rhode Island), enabling around 165 physicians and 1,800 employees across 40 locations to grow, specialize, and focus on patient care while Spire handles operations, practice integration, and business development.

📋 Description

• Design, build, and maintain scalable data pipelines that ingest, transform, and publish data from practice management, EHR, billing, finance, and operational source systems. • Develop and optimize SQL-based data models in Snowflake to support Power BI reporting, executive dashboards, recurring analytics, and ad hoc business analysis. • Use dbt or similar transformation frameworks to create tested, version-controlled, and documented data models. • Build data integration processes using APIs, SFTP files, flat files, database extracts, and third-party vendor feeds. • Create automated data quality checks, reconciliation processes, anomaly detection routines, and alerting to identify issues before they affect downstream reporting. • Partner with analytics, finance, RCM, and operations stakeholders to translate reporting needs into reliable data structures and reusable datasets. • Improve data reliability by standardizing definitions, mapping source system fields, documenting lineage, and resolving data inconsistencies across systems. • Tune query performance, manage large datasets efficiently, and troubleshoot pipeline failures or report performance issues. • Support secure data handling practices, access controls, and HIPAA-aligned data governance expectations for healthcare information. • Maintain clear technical documentation, including source-to-target mappings, transformation logic, data dictionaries, and operational runbooks. • Collaborate using Git-based workflows, code review, and deployment practices appropriate for production data environments. • Provide production support for scheduled data jobs, recurring reporting datasets, and critical analytics workflows.

🎯 Requirements

• 4+ years of experience in data engineering, analytics engineering, business intelligence engineering, or a closely related technical data role. • Strong SQL skills, including complex joins, window functions, CTEs, query optimization, data validation, and performance tuning. • Hands-on experience with Snowflake or another modern cloud data warehouse. • Experience building ELT/ETL pipelines and transforming raw source data into modeled, analysis-ready datasets. • Proficiency with Python for automation, data processing, validation, or pipeline support. • Experience with dbt, Airflow, Dagster, Fivetran, Matillion, Azure Data Factory, or comparable data transformation/orchestration tools. • Understanding of dimensional modeling, semantic layers, data marts, and structures that support reliable BI reporting. • Working knowledge of Power BI datasets, Power Query, DAX, or BI consumption patterns, even if dashboard development is not the primary focus. • Comfortable working with messy, high-volume, multi-source data and turning it into clean, trustworthy, documented outputs. • Strong problem-solving skills and the ability to troubleshoot data issues from source extraction through final report output. • Clear communication skills, including the ability to explain technical issues and tradeoffs to non-technical stakeholders. • High attention to detail, strong ownership, and a low tolerance for unexplained data discrepancies.

🏖️ Benefits

• Excellent growth and advancement opportunities • Dynamic environment • Access to a diverse network of practitioners • Broad infrastructure of tools and programs to enhance the employee experience • Competitive Compensation • Generous PTO • Benefits package: health, dental, vision, 401(k), etc.