> Markdown version of [/jobs/ext/1233721-bi-engineer](https://www.wearedevelopers.com/jobs/ext/1233721-bi-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI Engineer - **Company:** Spire Inc. - **Location:** Stamford, CT, United States (Remote available) - **Experience:** Experienced - **Salary:** $113,200.0 - $169,800.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Microsoft Excel, Application Programming Interfaces (APIs), Airflow, Amazon Web Services, Data Analysis, Microsoft Azure, Big Data, Cloud Computing, Code Review, Information Systems, Databases, Data Validation, Data Dictionary, Information Engineering, Data Governance, Data Infrastructure, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Security, Data Structures, Data Warehousing, Database Queries, Dimensional Modeling, Executive Information Systems, Python (Programming Language), Operational Databases, Performance Tuning, Query Optimization, Power BI, SQL Databases, Technical Data Management Systems, Data Processing, File Transfer Protocol (FTP), Data Ingestion, EHR Systems, Azure Data Factory, Fast Healthcare Interoperability Resources, Snowflake, Electronic Medical Records, Powerquery, Data Layers, Git Flow, Information Technology, Health Level Seven International, Data Inconsistencies, Data Pipelines - **Published:** July 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=97ca3daded6ed547 ## About the Role * 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., * Experience in healthcare, physician practice, MSO, revenue cycle, payer, or healthcare operations data environments. * Familiarity with practice management or EHR platforms such as Athena, Modernizing Medicine (ModMed), SIS, or similar systems. * Exposure to healthcare data types such as charges, payments, adjustments, claims, denials, appointments, CPT codes, provider/location hierarchies, or payer data. * Experience working with 835/837 files, ERA data, HL7/FHIR, or other healthcare integration formats. * Experience with cloud platforms such as Azure, AWS, or GCP. * Advanced Excel skills helpful for validation, reconciliation, and stakeholder support. * Bachelor's degree in computer science, data engineering, information systems, analytics, mathematics, statistics, or a related field; equivalent professional experience may be considered., The final pay offered to a successful candidate will be dependent on several factors that may include but are not limited to the type and years of experience within the job, the type of years and experience within the industry, education, etc. ## Description The Data Engineer will help build and support the data foundation that powers enterprise reporting, analytics, and operational decision-making across Spire. This role is responsible for creating reliable data pipelines, well-structured data models, automated quality checks, and documented datasets that analytics, finance, operations, and revenue cycle teams can trust. This is a technical role first. Healthcare or revenue cycle experience is helpful, but deep RCM expertise is not required. The successful candidate will be comfortable learning the business context while bringing strong engineering discipline to data ingestion, transformation, testing, performance, and production support. Spire's leadership is actively investing in data and analytics capabilities. This role will help modernize the data environment, improve reporting reliability, and create scalable structures that reduce manual work and make data easier to use across the organization. Responsibilities/Duties: * 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 ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Why Git Still Matters](https://www.wearedevelopers.com/videos/100288-why-git-still-matters) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)