Data Engineer

Lucent Health combines top-tier claims management with a compassionate, human-focused, data-driven care management solution. This approach helps self-insured employers provide care management that enables health plan participants to make smarter, cost-saving healthcare decisions. Continuous data analytics offer ongoing insights, ensuring participants receive the right care, at the right cost, at the right time. Join us as we build a company that aims to be a better health benefits partner for self-insured employers. Company Culture We believe that the success of Lucent Health relies on having employees who are honest, ethical and hardworking. These values are the foundation of Lucent Health. Transparent Communication: be open and clear in all interactions without withholding crucial information Integrity: ensure accuracy in reporting, work outputs and any tasks assigned Truthfulness: provide honest feedback and report any issues or challenges as they arise Trustworthiness: build and maintain trust by consistently demonstrating reliable behavior Ethical Fair Decision Making: ensure all actions and decisions respect company policies and values Accountability: own up to mistakes and take responsibility for rectifying them Respect: treat colleagues, clients and partners with fairness and dignity Confidentiality: safeguard sensitive information and avoid conflicts of interest Hardworking Consistency: meet or exceed deadlines, maintaining high productivity levels Proactiveness: take initiative to tackle challenges without waiting to be asked Willingness: voluntarily offer to assist in additional projects or tasks when needed Adaptability: work efficiently under pressure or in changing environments Summary We are seeking an experienced Senior Data Engineer with over 15 years of hands‑on experience to design, build, optimize, and support enterprise‑grade data solutions within the healthcare and fintech domain. The role requires strong expertise in SQL Server–based data platforms, data integration, and performance optimization, along with modern serverless data orchestration tools such as Azure Data Factory and Microsoft Fabric Data Pipelines. This position will play a critical role in modernizing existing data workloads, improving performance of current jobs, and delivering scalable, reliable data solutions. The candidate is expected to take full ownership of design, development, delivery, and production support while mentoring junior engineers and collaborating closely with stakeholders. Responsibilities Design, develop, and maintain robust data integration solutions supporting healthcare payments platforms, including claims processing, eligibility, billing, remittance (835/837), and payment reconciliation workflows using SQL Server, SSIS packages, and SQL Server Agent jobs, with a strong focus on performance, reliability, and scalability. Analyze and optimize existing SQL jobs and ETL workflows to significantly improve execution time, resource utilization, and overall system efficiency. Build and manage serverless data pipelines using Azure Data Factory (ADF) and Microsoft Fabric Data Pipelines, supporting cloud and hybrid data architectures. Own end‑to‑end delivery of data solutions, including requirements analysis, technical design, development, testing, deployment, monitoring, and production support. Apply strong healthcare domain knowledge to ensure data solutions meet regulatory, compliance, and data governance requirements (e.g., data quality, security, and traceability). Collaborate with cross‑functional teams, including application developers, analysts, and infrastructure teams, to align data engineering solutions with business needs. Collaborate with finance and compliance teams to translate healthcare payment requirements into scalable, production‑ready data solutions that meet regulatory and reporting standards. Mentor and guide junior data engineers by conducting code reviews, promoting best practices, and supporting technical skill development. Troubleshoot and resolve production issues, perform root‑cause analysis, and implement preventive solutions to improve system stability. Contribute to architecture discussions and modernization initiatives, including migration from legacy ETL patterns to cloud‑native and serverless designs. Leverage .NET application development experience (nice to have) to support data‑driven applications, APIs, or custom integrations as needed. Qualifications 10+ years of hands‑on experience as a Data Engineer or similar role, with a strong focus on enterprise data platforms Deep expertise in SQL Server, including complex query development, performance tuning, indexing strategies, and optimization Strong experience building, maintaining, and optimizing SSIS packages and SQL Server Agent jobs Proven experience improving performance of existing ETL jobs and data workflows in production environments Hands‑on experience with Azure Data Factory (ADF) and serverless data pipeline architectures Experience working in the healthcare and fintech domain, with understanding of healthcare and PCI data concepts, compliance, and data governance Ability to own end‑to‑end delivery: requirements analysis, design, development, testing, deployment, and production support Strong troubleshooting, problem‑solving, and root‑cause analysis skills Experience mentoring junior developers and leading by example through best practices and code reviews Preferred Skills Experience with Microsoft Fabric Data Pipelines and modern analytics platforms Knowledge of SQL Server instance‑level maintenance activities, including maintenance plans, index and statistics maintenance, backup and cleanup jobs, monitoring, and routine health checks Experience with .NET application development for data‑driven applications, APIs, or custom integrations Experience with cloud‑native or hybrid data architectures beyond SQL Server (e.g., Azure storage and analytics services) Familiarity with CI/CD practices for data engineering and ETL workloads Experience supporting large‑scale, mission‑critical data platforms in regulated or compliance‑driven environments Equal Employment Opportunity Policy Statement Lucent Health is an Equal Opportunity Employer that does not discriminate based on actual or perceived race, color, creed, religion, alienage or national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth and related medical conditions), gender identity, gender expression, transgender status, sexual orientation, marital status, military service and veteran status. #J-18808-Ljbffr Lucent Health