What are the responsibilities and job description for the Azure SQL Server & Healthcare ETL Developer position at Aspirion Health Resources LLC?
Company Overview:
For over two decades, Aspirion has been a leader in revenue cycle services, specializing in recovering challenging payments from third-party payers. Our expertise spans complex denials, aged accounts receivable, motor vehicle accidents, workers’ compensation, Veterans Affairs, and out-of-state Medicaid. We foster a results-oriented work environment that is both challenging and rewarding, offering opportunities for professional and personal growth.
Role Overview:
Aspirion is seeking a talented ETL Developer with strong expertise in Azure SQL Server and healthcare data pipelines to join our growing Data Engineering team. This position will play a key role in designing and maintaining robust ETL solutions focused on EDI integration, data warehousing, and data lakehouse architecture. You will work on ingesting client healthcare data into our secure data ecosystem, enabling downstream analytics, compliance, and operational decision-making.
This role is ideal for someone who thrives in a fast-paced, mission-driven environment, with a strong focus on data quality, security, and process automation.
Key Responsibilities:
- Develop, test, and maintain scalable ETL workflows using Azure SQL Server and industry-standard tools (e.g. EasyMorph, Azure Data Factory, SSIS, or other modern ETL platforms).
- Ingest and transform structured and semi-structured EDI healthcare data from external clients into the Azure Data Lakehouse environment.
- Build and maintain data integrations supporting Power BI dashboards, analytics use cases, and AI-driven data functions.
- Collaborate with BI, Product, and DevOps teams to align pipeline development with organizational goals and reporting needs.
- Apply best practices in data modeling, transformation logic, and optimization of T-SQL queries and procedures.
- Ensure data lineage, classification, and governance through tools such as Microsoft Purview.
- Design solutions compliant with HIPAA, supporting secure healthcare data handling across the ecosystem.
- Assist in integrating Microsoft Access and legacy systems as needed during data migrations or backfills.
- Participate in architectural discussions regarding Microsoft Fabric and enterprise data modernization strategies.
Required Skills & Qualifications:
- 3 years of hands-on experience in ETL development, preferably in a healthcare data environment.
- 5 years experience working with database systems.
- Advanced knowledge of Azure SQL Server, including stored procedures, indexing, performance tuning, and complex transformations.
- Experience with at least one ETL tool such as Azure Data Factory, SSIS, Informatica, or EasyMorph (preferred but not required).
- Familiarity with Databricks or other big data platforms is a plus.
- Understanding of EDI healthcare formats (e.g., X12 837/835) and payer-provider data structures.
- Strong grasp of data warehousing principles, star/snowflake schema, and data lake architecture.
- Knowledge of Microsoft Purview, Azure Data Lake, and Power BI integration.
- Solid understanding of HIPAA compliance and healthcare data security practices.
- Bonus: Exposure to AI-enhanced data pipelines or scripting for automation and quality monitoring.
Education Background:
- Bachelor’s degree in computer science, Data Engineering, Information Systems, or a related field preferred.
- Relevant certifications in Azure, ETL tools, or healthcare data management are a plus.
At Aspirion we invest in our employees by offering unlimited opportunities for advancement, a full benefits package, including health, dental, vision and life insurance upon hire, matching 401k, competitive salaries, and incentive programs.
The US base pay is determined by a number of factors including, but not limited to, job-related skills, experience, education, training, licensure or certifications obtained. Market, location and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates may be eligible to receive a bonus tied to achieved results.
Must reside in the United States within one of the states listed below:
Alabama, Arizona, Arkansas, Delaware, Florida, Georgia, Iowa, Indiana, Kansas, Kentucky, Louisiana, Massachusetts, Maine, Maryland, Michigan, Minnesota, Missouri, Mississippi, Montana, North Carolina, Nebraska, New Hampshire, Ohio, Oklahoma, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Virginia, Wisconsin, West Virginia, and Wyoming.
