Lead Software Engineer

Vizient; Irving (TX); On-site; USD 110,000 - 130,000; Full time

Job summary

Vizient, located in Irving, Texas, is looking for a data integration lead to oversee the design and development of innovative data engineering solutions. This role involves collaboration with various technology teams to ensure scalable and reliable data solutions.

The ideal candidate will have more than 7 years of experience in software and data engineering, proficiency with Azure Data Factory, and a strong background in ETL processes. This position offers a dynamic work environment and opportunities for professional development.

Qualifications

• 7+ years of relevant software engineering or data engineering experience.
• Experience in ETL and database development.
• Proficiency with Azure DevOps required.

Responsibilities

• Lead the design and support of data integration solutions.
• Develop and optimize ETL and ELT pipelines.
• Troubleshoot complex data issues and job failures.

Skills

Data integration solutions

Azure Data Factory

SQL Server Integration Services

ETL pipelines

Database development

Azure DevOps

Agile methodologies

Data warehousing

Education

Degree in computer science or related field

Tools

Azure Databricks

Tableau

Power BI

Job description

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.

Responsibilities

• 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 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.

Qualifications

• 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 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.
• Experience with healthcare, pharmaceutical, 340B or compliance‑related data preferred.
• Experience with reporting and visualization platforms such as Strategy (formerly MicroStrategy), 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.