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
Physical Therapist Assistant / PTA - Full-time Belleville IL / Illinois & Aviston IL / Illinois Continuum Therapy Partners has an opportunity for a full-time Physical Therapist Assistant / PTA! This position will be split between Four Fountains, in Belleville,...
...Join our network of remote Psychiatric Mental Health Nurse Practitioners (PMHNPs) and enjoy the freedom and flexibility of working from home. Benefits: Guaranteed Pay: You are fully compensated for cancellations and no-shows. Set Your Schedule: You can work...
...The Bay Delta Region 3 Timberland Conservation & Wildfire Resiliency Program is hiring an Environmental Scientist, final filing date is 10/2/2023 . If you enjoy hiking in the redwood forests of Santa Cruz, San Mateo, Napa, and Sonoma counties, and are passionate about...
...Apply for this job.Click the button below to apply for this job.Apply NowAlready have an account? Log in firstBoys Golf CoachSchool in Cincinnati, Ohio is looking for a Boys Golf Coach.Requirements:Previous coaching experience and knowledge of the sport....
...Growing National firm looking to add a talented Electrical Transmission Project Manager to their Pittsburgh team! Responsibilities: Responsible for project management duties including design, modeling, development, and drawing of a transmission line structure...