Senior Data Engineer

Location: Addison, TX (Hybrid – 2–3 days/week onsite) About the Role We're looking for a Senior Data Engineer to lead the design, optimization, and integration of enterprise data platforms. You'll work at the intersection of SQL Server performance engineering and modern Azure-based data integration — building the pipelines and architecture that power analytics, reporting, and operational decision-making across the business. This is a hands‑on technical leadership role: you'll write and tune high-performance T-SQL, architect scalable ETL/ELT pipelines in Azure Data Factory, and mentor engineers as part of a growing data team. Healthcare data experience is a strong plus — you'll be working with data from clinical systems, EMRs, and other regulated data sources alongside HR, Finance, and CRM data. What You'll Do Lead integration efforts across Clinical/Practice Management systems, EMRs, HR, Accounting, CRM, and other enterprise sources Design and optimize SQL Server objects — tables, views, stored procedures, functions, triggers, indexes, and data warehouse structures Tune complex T-SQL queries and ETL workloads using execution plans, indexing strategies, and query rewrites Troubleshoot performance issues: long-running queries, blocking, deadlocks, tempdb pressure, and inefficient ETL patterns Architect and build scalable ETL/ELT pipelines using Azure Data Factory, Python, and other Azure services Design pipelines that leverage AI/LLMs for extracting structured data from documents and unstructured sources Drive Master Data Management (MDM) strategy to ensure consistency and integrity across systems Establish data lineage, monitoring, and operational tracking practices Mentor junior engineers and help build a culture of technical excellence and knowledge sharing Partner with stakeholders to translate evolving business requirements into scalable technical solutions Evaluate emerging Azure capabilities through proofs of concept What You Bring 7+ years of database development experience 3+ years of hands‑on Azure Data Factory experience 2+ years working with healthcare, financial, or other highly regulated data 1+ years of experience with Python Advanced T-SQL and SQL Server expertise, including query tuning and indexing strategy Strong data modeling and schema design skills A track record of taking projects from concept to production Strong communication skills and comfort working across technical and business stakeholders Bachelor's degree or higher Nice to Have Experience with Healthcare EDI file formats (835, 837, etc.) Experience using AI/LLMs for document-based data extraction #J-18808-Ljbffr