| Location | Addison, Texas |
| Job Type | Full-time |
The Senior Data Engineer will play a lead role in acquiring, transforming, optimizing, and integrating data from enterprise systems into scalable data platforms.
This role requires strong hands-on expertise in Microsoft SQL Server, advanced TSQL development, query optimization, indexing strategies, stored procedure performance tuning, and Azure Data
Factory-based integration. The individual will design high-performance data solutions, mentor junior engineers, and collaborate across functions to deliver reliable enterprise data platforms.
Healthcare data experience highly preferred.
NOTE: THIS IS A HYBRID ROLE. MUST BE WILLING TO COMMUTE TO THE ADDISON, TX. OFFICE 3 DAYS PER WEEK!
Responsibilities:PRIMARY DUTIES
• Lead the integration of data from Clinical/Healthcare Practice Management Systems, Electronic Medical Record
(EMRs), HR, Accounting, Customer Relationship Management (CRM), and other enterprise systems.
• Design, develop, and optimize SQL Server database objects, including tables, views, stored procedures,
functions, triggers, indexes, staging tables, and data warehouse structures.
• Tune complex T-SQL queries, stored procedures, and ETL workloads using execution plans, indexing strategies,
statistics, query rewrites, and other troubleshooting techniques.
• Monitor and troubleshoot SQL Server performance issues related to long-running queries, blocking, deadlocks,
tempdb usage, data volume growth, and inefficient ETL patterns.
• Drive and oversee scalable database architectures and data platforms supporting multiple business lines.
• Design and optimize complex ETL/ELT data pipelines using Azure Data Factory, other Azure services and python,
ensuring high reliability and performance.
• Orchestrate pipelines that leverage AI/LLMs for data extraction from various documents and sources.
• Conduct advanced data profiling, cleansing, and transformation for analytics and reporting teams.
• Drive implementation of Master Data Management (MDM) strategies to ensure data consistency and integrity.
• Identify process improvement opportunities and spearhead automation to reduce delivery time and increase
quality.
• Establish and maintain comprehensive data lineage, monitoring, and operational tracking systems.
• Provide hands-on support while mentoring junior engineers and contributing to a culture of knowledge sharing
and continuous improvement.
• Collaborate closely with stakeholders to gather evolving data requirements and translate them into scalable
technical solutions.
• Maintain high standards for code quality through documentation, source control, code reviews, and rigorous
testing practices.
• Identify integration gaps, recommend solutions, and ensure continuous improvement of data processes.
• Establish and enforce best practices for data engineering and integration across the team.
• Explore and evaluate emerging Azure features, leading proofs of concept to assess fit for purpose.
MINIMUM QUALIFICATIONS AND REQUIREMENTS
• 7+ years of experience in database development.
• 3+ years of deep hands-on experience with Azure Data Factory (ADF).
• 2+ years of experience with healthcare and/or financial data or other highly regulated vertical segments.
• 1+ years of experience using python
• Strong working knowledge of Azure ecosystem tools.
• Advanced proficiency in T-SQL and SQL Server.
• Strong grasp of data modeling, indexing, and schema design principles.
• Proven ability to manage multiple priorities and drive solutions from conception to production.
• Effective collaborator and communicator, capable of interfacing with all stakeholders.
• Bachelor's degree or higher.
PREFERRED EXPERIENCE
• Experience working with data integration related to Healthcare EDI files, such as 835, 837, etc.
• Experience working on data extraction from documents using AI/LLMs.
NOTE: This position follows a hybrid work model with a minimum of 3 days per week in our Addison, TX office.