Spire Orthopedic Partners logo
Spire Orthopedic Partners

Driving the future of orthopedic medicine.

BI Engineer

Business Intelligence DeveloperBusiness Intelligence DeveloperFull TimeRemoteSeniorTeam 1,001-5,000Since 2021H1B No SponsorCompany SiteLinkedIn

Location

Connecticut

Posted

16 hours ago

Salary

$113.2K - $169.8K / year

Seniority

Senior

Bachelor Degree4 yrs expEnglishAirflowAzureCloudETLMatillionPythonSQL

Job Description

BI Engineer

Spire Orthopedic Partners

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

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

Related Job Pages

More Business Intelligence Developer Jobs

Role Description Under the direction of the USL Technology & Data Strategy team, the Business Intelligence UWEP supports the department by assisting with maintaining and developing league-wide dashboards. The Participant will assume an integral role in the production of data analytics and distribution of the results. Duties and Responsibilities - Assist with the routine collection of data and updating of established Tableau dashboards. - Build Tableau dashboards to track performance in key metrics towards league goals and initiatives. - Identify opportunities to implement procedures for new data collection processes and/or data reporting. - Translate data across key revenue-driving verticals (e.g., ticketing, corporate partnerships, and consumer products) into targeted analyses, providing insights and recommendations to critical organizational stakeholders that lead to actionable business decisions. - Support ad-hoc requests for data; build reports, visualizations, executive dashboards, and presentations. - Act in a quality assurance role to ensure dashboards/reports are functioning correctly and to provide any recommendations for improvements. - Assist other departments and operational areas as requested to provide a well-rounded overview of working in sports. Qualifications - Participants must be working towards a bachelor’s or master’s degree in a related field and/or training and must certify that they are able to receive college course credit from an accredited college or university for their participation. - Solid computer skills and proficiency with MS Word, Excel, PowerPoint, Outlook are a must. - Excellent verbal and written communication skills are required. - Positive attitude and strong work ethic are a must. Must have a “team-first” mentality with an eagerness to learn. - Should be extremely organized and detail oriented, with a focus on quality and consistency. - While completing the USL Work Experience Program remotely, participants must have access to a computer or laptop with reliable internet connection. - Familiarity of Tableau, or another data visualization software. - Familiarity of SQL, or other programming languages. Requirements - Must be able to receive college course credit for participation. - Access to a computer or laptop with reliable internet connection. Benefits - Gain practical sport management experience in a professional sports league setting. - Work on various strategic projects and initiatives. - Interact with all league departments across the organization.

United States
CRG Solutions logo

Lead BI Engineer

CRG Solutions

Enabling People and Businesses for Success

Full TimeRemoteTeam 201-500Since 2015H1B No Sponsor

• Architect, build, and optimize distributed data pipelines using Apache Spark in a high‑volume, mission‑critical environment. • Design and maintain enterprise Lakehouse architecture with Delta Lake, ensuring ACID compliance, lineage, auditability, and data governance. • Develop automated ingestion frameworks (batch, streaming, and event‑driven) across multiple cloud services and integration points. • Enable machine‑learning workflows by preparing feature‑ready datasets and establishing reproducible ML deployment patterns. • Lead platform‑wide data quality, access control, and cataloging frameworks. • Implement advanced cost‑optimization, cluster tuning, and performance engineering strategies. • Collaborate with Finance, BI, Operations, and ML teams to translate complex business needs into scalable data solutions. • Own production reliability, troubleshooting, and root‑cause analysis for data and ML pipelines.

United States
Full TimeRemoteTeam 51-200Since 2006H1B Sponsor

• Build, maintain, and optimize dashboards, reports, and data models using Power BI and other visualization tools. • Design, build, and maintain data ETL pipelines from sources such as SQL databases, SharePoint, and Excel • Collaborate with end users and technical resources to understand and integrate data outputs into visualizations effectively. • Translate complex data findings into clear, digestible insights for stakeholders to support data-driven decision-making. • Ensure data accuracy, consistency, and integrity across reports and dashboards.

District Of Columbia + 1 moreAll locations: District Of Columbia | Washington
$110K - $130K / year
Full TimeRemoteTeam 1,001-5,000H1B Sponsor

• Provide first hand support to business units with respect to their adhoc data and reporting requests • Works with internal and external customers and suppliers to understand the business requirements behind requested computing initiatives • Develops and deploys reports and dashboards in SSRS and Power BI • Provide inputs on data sources and quality into high-level data flow architecture • Design and develop ETL and integration solutions • Implement design patterns and industry best-practices to develop secure robust integration applications • Actively collaborate with developers and other project resources • Questions existing processes and procedures (both administrative and technical), and offers suggestions and opinions for continuous improvement. • Communicates technical ideas and concepts in non-technical language to the business. • Takes directions from and works with senior members of the development team on projects and tasks • Adheres to and promotes the environmental, health & safety policies of AFL. • Ability to effectively communicate with and educate business users and mid/senior management about data warehousing/business intelligence technology in business terms.

South Carolina