Lead Software Engineer

Summary

In this role, you will lead the design, development, and support of data integration and engineering solutions within the Apexus technology team. You will provide technical leadership for the data engineering team that supports daily, weekly, and monthly feeds. You will guide new development efforts that enable ad‑hoc analytics, standardized reporting, operational workflows, and data‑driven solutions for internal and external customers.

You will work closely with business analysts, data architects, product owners, and other technology partners to deliver scalable, secure, and reliable data solutions.

• Lead the design, development, testing, deployment, and support of data integration solutions across Azure Data Factory (ADF), Azure Databricks, SQL Server Integration Services (SSIS), SQL Server, and related platforms.
• Work with business analysts, data architects, product owners, and stakeholders to understand business requirements and translate them into scalable technical solutions.
• Design, build, and optimize Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) pipelines to support reporting dashboards, data warehouse, analytics, and operational data needs.
• Lead development efforts for data movement between various systems, platforms, databases, APIs, and file types.
• Develop and maintain SQL objects, including tables, views, stored procedures, functions, indexes, and performance‑tuned queries.
• Provide technical leadership and guidance to software engineers and data developers, including code reviews, design reviews, mentoring, and troubleshooting support.
• Monitor, maintain, enhance, and optimize production ETL and data processing jobs to ensure reliability, accuracy, and performance.
• Lead efforts to modernize legacy SSIS and SQL‑based processes using cloud‑based technologies.
• Perform unit testing, integration testing, performance testing, and production validation for new and modified solutions.
• Manage source code versioning, branching, deployment, and release activities following established Dev Ops and change management practices.
• Collaborate with data architects to support data modeling, dimensional design, data warehousing, and data mart development.
• Troubleshoot complex data issues, job failures, performance bottlenecks, and production incidents.
• Support Agile and Waterfall software development life cycles, including estimation, sprint planning, backlog refinement, and delivery tracking.
• Identify opportunities to improve automation, monitoring, reliability, data quality, and overall platform performance.

• Relevant degree in computer science, information systems, data engineering, software engineering, or a related field preferred.
• 7 or more years of relevant software engineering, data engineering, ETL, or database development experience required.
• Experience with ADF required, including pipeline development, triggers, linked services, datasets, integration runtimes, monitoring, and error handling.
• Experience with Databricks preferred.
• Proficiency with Azure Dev Ops (ADO) for backlog management, delivery tracking, and operational visibility required.
• Experience supporting production data processes, job scheduling, monitoring, incident response, and root cause analysis required.
• Experience with healthcare, pharmaceutical, 340B or compliance‑related data preferred.
• Experience with reporting and visualization platforms such as Strategy (formerly Micro Strategy), Tableau, Power BI, or similar tools is preferred.
• Strong analytical, problem‑solving, communication, and collaboration skills required.
• Ability to work independently while also leading team‑based technical delivery efforts.