Senior Azure SQL Data Engineer

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:

• Database Engineering & Optimization

– 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.

• Azure SQL Infrastructure

– 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.

• Lakehouse Architecture & Fabric Integration

– 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.

• AI & BI Readiness

– 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.

• Monitoring & Maintenance

– 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:

• Core SQL Expertise

– Advanced T-SQL development (queries, procedures, triggers)

– OLTP performance analysis and optimization

– Execution plan review, index tuning, deadlock resolution

• Azure Cloud Experience

– 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

• Data Engineering Tools

– 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

• Collaboration and Communication

– Proven experience working with cross-functional teams including BI, AI/ML, and DevOps

– Strong documentation and communication skills

• Experience

– 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:

• Microsoft Certified: Azure Data Engineer Associate or related Azure certifications

• Experience with Microsoft Fabric or early adoption of Lakehouse platforms

• Familiarity with data governance and cataloging via Microsoft Purview

• Exposure to tools supporting AI/ML pipelines in Azure

Educational Requirements:

• Bachelor’s degree in computer science, Data Engineering, Information Systems, or equivalent experience

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:

• Competitive compensation and performance-based incentives

• Health, dental, vision, and life insurance from day one

• 401(k) with company match

• Flexible work environment (remote/hybrid)

• Professional development and certification support

• Mission-driven, people-first culture