Position Overview:
Aspirion is seeking a detail-oriented and performance-driven Senior Azure SQL Data Engineer to join our growing Data Engineering team. This role will focus on designing, building, and optimizing scalable data infrastructure and services that support real-time business operations and enable advanced analytics, including AI/ML initiatives. The engineer will be responsible for driving excellence in database architecture, SQL performance tuning, and Azure resource management, while also contributing to the buildout of our Azure Lakehouse and Microsoft Fabric environment.
Key Responsibilities:
– Write and optimize advanced T-SQL queries, stored procedures, views, and triggers.
– Analyze execution plans, tune indexes, and resolve deadlocks to maximize performance in OLTP environments.
– Design scalable and reliable schema changes for transactional and analytical systems.
– Provision, configure, and manage Azure SQL resources (Azure SQL Database, Managed Instances, SQL on Azure VMs).
– Implement capacity planning for compute and storage across OLTP and OLAP environments.
– Support and enhance Azure Data Lakehouse environments using Microsoft Fabric and OneLake.
– Develop ELT pipelines using Data Factory and Synapse Analytics.
– Integrate data governance practices using Microsoft Purview.
– Design and prepare data layers optimized for AI/ML use cases and business intelligence consumption.
– Collaborate with analysts and data scientists to ensure performant and accessible datasets.
– Implement proactive monitoring, logging, and alerting for SQL and data pipeline operations.
– Participate in incident response and continuous improvement of data reliability and performance.
Required Skills and Experience:
– Advanced T-SQL development (queries, procedures, triggers)
– OLTP performance analysis and optimization
– Execution plan review, index tuning, deadlock resolution
– Hands-on experience with Azure SQL (all service models)
– Capacity planning for Azure SQL workloads
– Familiarity with Azure networking, access, and security for data services
– Proficient with Azure Data Factory, Synapse Analytics, and Data Lake Storage
– Exposure to Microsoft Fabric and OneLake environments
– Understanding of Delta Lake and parquet formats
– Proven experience working with cross-functional teams including BI, AI/ML, and DevOps
– Strong documentation and communication skills
– 7+ years in data engineering with a focus on SQL and cloud data platforms
– at least 4 years of hands-on Azure SQL development and deployment
Preferred Qualifications:
Educational Requirements:
About Aspirion:
For over two decades, Aspirion has delivered market-leading revenue cycle services, specializing in complex reimbursement challenges. With over 1,400 teammates, our culture is rooted in innovation, excellence, and a shared mission to deliver exceptional outcomes for our healthcare clients. We embrace flexibility, personal growth, and the intelligent use of technology—especially AI—to drive results.
Benefits: