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