SQL Developer & Analyst Team Lead (Remote Opportunity)

VetsEZ•Charleston, SC

3d•Remote

About The Position

VetsEZ is seeking a SQL Development / Data Analysis Team Lead for a fully remote role supporting a large federal government healthcare modernization project for the Department of Veterans Affairs (VA). The role leads a team responsible for SQL development, clinical data analysis, reporting, and data quality monitoring in support of electronic health record (EHR) modernization initiatives. It combines technical leadership with hands-on expertise in SQL Server, data migration, data integration, and business intelligence reporting, with a focus on the accuracy, integrity, and reliability of healthcare data. The position works in a remote, multidisciplinary Agile environment with SQL developers, data analysts, data engineers, quality assurance personnel, program leadership, and federal stakeholders. The Team Lead oversees technical deliverables, establishes development standards, mentors team members, and coordinates data validation and reporting activities. The role also supports continuous improvement and responsible adoption of AI-assisted development tools. Candidates must reside within the continental United States. U.S. citizenship is required, and selected candidates must successfully complete a background check and be able to obtain and maintain a Government/Public Trust clearance, including fingerprinting when required. Sponsorship is not available.

Requirements

Bachelor's degree in Computer Science, Electronics Engineering, or another engineering or technical discipline, or eight years of additional relevant experience in lieu of a degree.
At least eight years of relevant professional experience.
Extensive hands-on experience developing, reviewing, and optimizing advanced SQL queries, scripts, and data transformation processes using Microsoft SQL Server, including work with large, complex datasets and indexing, normalization, and performance tuning.
Demonstrated experience leading or serving as a technical lead for SQL development, data analysis, or data engineering teams, including assigning work, establishing technical standards, reviewing deliverables, and providing technical guidance.
Strong experience analyzing healthcare or clinical datasets, including familiarity with HL7, FHIR, or VistA; data migration and validation processes; relational database structures; and reporting tools such as Power BI, Tableau, or Microsoft Excel.
Strong analytical, troubleshooting, and problem-solving skills, attention to detail, and ability to investigate complex data discrepancies, assess technical risks, and implement effective solutions.
Strong leadership, organizational, communication, and interpersonal skills, including ability to mentor technical personnel, manage competing priorities, and communicate complex technical findings to technical teams, non-technical stakeholders, and program leadership.
U.S. citizenship.
Ability to successfully complete a background check and obtain and maintain a Government/Public Trust clearance, including fingerprinting when required.
Must reside within the continental United States.

Nice To Haves

Previous experience supporting VA healthcare data systems, including VX130, Oracle Health Millennium, or the Corporate Data Warehouse (CDW).
Familiarity with InterSystems IRIS, Caché, mirrored database architectures, EHR data migration, cutover verification, and healthcare data governance practices.
Experience leading technical teams in Agile environments using JIRA, Azure DevOps, or similar tools, including sprint planning, backlog management, peer code reviews, technical documentation, metadata management, and coordination of data quality and reporting deliverables.
Experience implementing and overseeing AI-assisted development practices using tools such as GitHub Copilot, including establishing review standards, validating AI-generated outputs, protecting PHI/PII, and ensuring compliance with federal responsible AI guidance.

Responsibilities

Lead and mentor SQL developers and data analysts; assign tasks, establish priorities, monitor deliverables, conduct technical reviews, and support team development, onboarding, and performance improvement.
Develop, review, and optimize advanced SQL queries, scripts, and transformation logic in SQL Server; establish coding standards, peer review practices, and database performance optimization guidelines.
Oversee healthcare data analysis, integration, and migration, including evaluation of data flows, source-to-target mappings, conceptual and physical data models, and data warehouse structures.
Direct data quality monitoring, validation, and reconciliation to ensure clinical datasets are complete, accurate, consistent, and timely; lead root cause investigations and coordinate corrective actions with development and QA teams.
Serve as the primary technical point of contact for program leadership and VA stakeholders; coordinate data review sessions, communicate technical findings, manage risks, and review reports, dashboards, and recurring deliverables before release.
Establish and maintain technical documentation and development practices, including data dictionaries, runbooks, validation protocols, Agile workflows, and responsible AI-assisted development standards.
Support responsible use of AI-assisted tools for SQL optimization, data analysis, automated validation, and documentation.
Take on additional tasks and responsibilities as needed to support team objectives and project success.