Lead Software Engineer

Vizient•Irving, TX

2d•Onsite

About The Position

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 data engineering team that support daily, weekly, and monthly feeds. In addition, you will guide new development efforts that enable ad-hoc analytics, standardized reporting, operational workflows, and data-driven solutions for internal and external customers. The Lead Software Engineer will work closely with business analysts, data architects, product owners, and other technology partners to deliver scalable, secure, and reliable data solutions using platforms such as Azure Data Factory, Databricks, SSIS, and SQL Server. This role is expected to provide hands-on development expertise, lead other engineers, promote engineering best practices, and help modernize legacy data integration processes.

Requirements

7 or more years of relevant software engineering, data engineering, ETL, or database development experience required.
Experience with Azure Data Factory required, including pipeline development, triggers, linked services, datasets, integration runtimes, monitoring, and error handling.
Proficiency with Azure DevOps (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.
Strong analytical, problem-solving, communication, and collaboration skills required.
Ability to work independently while also leading team-based technical delivery efforts.

Nice To Haves

Experience with Databricks preferred.
Experience with healthcare, pharmaceutical, 340B or compliance-related data preferred.
Experience with reporting and visualization platforms such as Strategy, Tableau, Power BI, or similar tools a preferred.

Responsibilities

Lead the design, development, testing, deployment, and support of data integration solutions across Azure Data Factory, Azure Databricks, 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 ETL and 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 DevOps 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.