SQL Developer & Analyst Team Lead (Remote Opportunity)

VetsEZ•Charleston, SC

4d•Remote

About The Position

VetsEZ is seeking a SQL Development / Data Analysis Team Lead for a fully remote position 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. The Team Lead provides technical leadership and hands-on expertise in SQL Server, data migration, data integration, and business intelligence reporting while ensuring healthcare data accuracy, integrity, and reliability. The position operates in a remote, multidisciplinary Agile environment, collaborating 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. 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.
Experience working with large, complex datasets and applying indexing, normalization, and performance-tuning techniques.
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 solutions.
Strong leadership, organizational, communication, and interpersonal skills, including the ability to mentor technical personnel, manage competing priorities, and communicate technical findings to technical and non-technical audiences and program leadership.
U.S. citizenship.
Ability to successfully complete a background check and obtain and maintain a Government/Public Trust clearance, including required fingerprinting when applicable.
Must reside within the continental United States.

Nice To Haves

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 to optimize SQL queries, automate data validation and reconciliation, analyze trends, and maintain technical documentation.
Experience establishing AI-assisted development 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 reviewing 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; investigate root causes 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 program 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.
Take on additional tasks and responsibilities as needed to support team objectives and project success.