Aspirion · 2 days ago
Data Warehouse Engineer
Columbus,GA,US
Full-time
Onsite
Mid Level
3+ years expAspirion has been a leader in revenue cycle services for over two decades, specializing in complex payment collections and providing exceptional outcomes for clients. The Data Warehouse Engineer will collaborate with various teams to build and maintain ETL solutions, ensuring the effective centralization and reporting of data from multiple sources.
Health CareHospitalMedicalTechnical Support
Responsibilities
Collaborate with our Business Intelligence team to understand business reporting requirements and define denormalized schema for the warehouse
Collaborate with our DBA team on capacity planning and deploying infrastructure resources
Build and maintain ETL solutions that centralize data from disparate sources into a centralized data warehouse
Collaborate with DBA, Security and Infrastructure teams to establish secure connections between data tiers
Build and maintain ETL solutions that denormalize OLTP source data into reportable OLAP data
Collaborate with stakeholders to RCA and remediate data and reporting defects and inconsistencies
Establish monitoring and alerting solutions to support the data warehouse and related ETL jobs
Qualification
Required
3+ years of experience building and maintaining an enterprise data warehouse - defining data requirements, schema and building ETL solutions
3+ years of experience using ETL tools (e.g. SSIS, ADF) to move data between databases/servers/environments
3+ years of experience denormalizing OLTP data for a data warehouse - may include T-SQL views, stored procedures, functions and ad hoc scripts
Experience optimizing T-SQL read and write performance in a large multi-terabyte data warehouse
Experience with SQL Server and Azure SQL Database
Experience using Microsoft Fabric or Azure Synapse Analytics
Familiar with message services (e.g. MSMQ, RabbitMQ, Azure Service Bus)
Familiar with source control, change control and security best practices
Familiar with healthcare industry data or EHR systems (e.g. EDI formats, common EHR data elements, live EHR integrations)
Company
Aspirion
Aspirion, a US-based, technology-leading revenue cycle management company, partners with healthcare providers to capture revenue from their most difficult to resolve claims.
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
unknown2022-06-21Acquired
2012-01-01Series Unknown
Leadership Team
Nick Giannasi
Chief Executive Officer
Brian Lefort
Chief People Officer
Recent News
2025-04-01
2024-12-05
Company data provided by crunchbase