Data Warehouse Engineer

Overview

Aspirion has delivered market-leading revenue cycle services for over two decades. We specialize in collecting challenging payments from third-party payers, focusing on complex denials, aged accounts receivables, motor vehicle accident, workers’ compensation, Veterans Affairs, and out-of-state Medicaid. United by a shared commitment to client excellence, we focus on achieving outstanding outcomes for our clients, aiming to consistently provide the highest revenue yield in the shortest possible time.

We are committed to creating a results-oriented work environment that is challenging and rewarding, fostering flexibility, and encouraging personal and professional growth. Joining Aspirion means becoming a part of an industry leading team, where you will have the opportunity to engage with innovative technology, collaborate with a diverse and talented team, and contribute to the success of our hospital and health system partners.

Aspirion maintains a strong partnership with Linden Capital Partners, serving as our trusted private equity sponsor.

• 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

• 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, Rabbit
  
  MQ, 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)