SQL Developer, Analyst Team Lead

Job Description:

• Lead and mentor a team of 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 within SQL Server environments
• Establish coding standards, peer review practices, and database performance optimization guidelines
• Oversee healthcare data analysis, integration, and migration activities
• Evaluate data flows, source-to-target mappings, conceptual and physical data models, and data warehouse structures
• Direct data quality monitoring, validation, and reconciliation activities for clinical datasets
• Lead root cause investigations and coordinate corrective actions with development and QA teams
• Serve as 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
• Support SQL optimization, data analysis, automated validation, and documentation using responsible AI-assisted development practices
• Take on additional tasks and responsibilities as needed to support team objectives and project success
• Collaborate in a remote, multidisciplinary Agile environment with SQL developers, data analysts, data engineers, QA personnel, program leadership, and federal stakeholders

Requirements:

• Bachelor's degree in Computer Science, Electronics Engineering, or another engineering or technical discipline, or eight (8) years of additional relevant experience in lieu of a degree
• Minimum of eight (8) 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
• Experience applying indexing, normalization, and performance tuning techniques
• Experience leading or serving as a technical lead for SQL development, data analysis, or data engineering teams
• Experience assigning work, establishing technical standards, reviewing deliverables, and providing technical guidance
• Strong experience analyzing healthcare or clinical datasets
• Familiarity with HL7, FHIR, or VistA
• Experience with data migration and validation processes
• Knowledge of relational database structures
• Experience with reporting tools such as Power BI, Tableau, or Microsoft Excel
• Excellent analytical, troubleshooting, and problem-solving skills
• Strong attention to detail
• Ability to investigate complex data discrepancies, assess technical risks, and implement effective solutions
• Strong leadership, organizational, communication, and interpersonal skills
• Ability to mentor technical personnel, manage competing priorities, and communicate complex technical findings to technical teams, non-technical stakeholders, and program leadership
• Previous experience supporting Department of Veterans Affairs (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 within Agile development environments using JIRA, Azure DevOps, or similar tools
• Experience with 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
• Ability to establish review standards, validate AI-generated outputs, protect PHI/PII, and ensure compliance with federal responsible AI guidance
• U.S. Citizenship is required
• All selected candidates must successfully complete a background check
• Ability to obtain and maintain a Government/Public Trust clearance, including required fingerprinting, when required for the position
• Sponsorship is not available

Benefits:

• Medical/Dental/Vision
• 401k with Employer Match
• PTO + Federal Holidays
• Corporate Laptop
• Training Opportunities
• Remote Opportunity