SQL Developer, Analyst Team Lead

This is a fully remote position, open to applicants in United States.

📋 Description

• Lead and guide a team of SQL developers and data analysts.

• Delegate tasks, set priorities, oversee deliverables, perform technical reviews, and foster team development, onboarding, and performance enhancement.

• Create, assess, and optimize complex SQL queries, scripts, and transformation logic within SQL Server environments.

• Set coding standards, peer review protocols, and guidelines for database performance optimization.

• Supervise healthcare data analysis, integration, and migration efforts.

• Analyze data flows, source-to-target mappings, conceptual and physical data models, and data warehouse architectures.

• Lead data quality monitoring, validation, and reconciliation processes for clinical datasets.

• Conduct root cause analyses and coordinate corrective measures with development and QA teams.

• Act as the primary technical liaison for program leadership and VA stakeholders.

• Organize data review sessions, convey technical insights, manage risks, and evaluate reports, dashboards, and periodic program deliverables prior to release.

• Develop and uphold technical documentation and development methodologies, including data dictionaries, runbooks, validation procedures, Agile workflows, and responsible AI-assisted development standards.

• Assist with SQL optimization, data analysis, automated validation, and documentation utilizing responsible AI-assisted development methods.

• Undertake additional tasks and responsibilities as required to meet team goals and ensure project success.

• Collaborate in a remote, multidisciplinary Agile setting with SQL developers, data analysts, data engineers, QA staff, program leadership, and federal stakeholders.

⛳️ Requirements

• Bachelor's degree in Computer Science, Electronics Engineering, or a related engineering or technical field, or eight (8) years of additional relevant experience in place of a degree.

• At least eight (8) years of pertinent professional experience.

• Extensive practical experience in developing, reviewing, and optimizing advanced SQL queries, scripts, and data transformation techniques using Microsoft SQL Server.

• Experience handling large and complex datasets.

• Proficient in applying indexing, normalization, and performance tuning strategies.

• Experience leading or acting as a technical lead for SQL development, data analysis, or data engineering teams.

• Proven experience in task assignment, establishing technical standards, reviewing deliverables, and offering technical guidance.

• Significant experience analyzing healthcare or clinical datasets.

• Familiarity with HL7, FHIR, or VistA.

• Experience in data migration and validation processes.

• Understanding of relational database architectures.

• Proficient with reporting tools such as Power BI, Tableau, or Microsoft Excel.

• Exceptional analytical, troubleshooting, and problem-solving abilities.

• Strong attention to detail.

• Capability to investigate complex data discrepancies, evaluate technical risks, and implement effective solutions.

• Excellent leadership, organizational, communication, and interpersonal skills.

• Ability to mentor technical staff, manage competing priorities, and articulate complex technical findings to both technical teams and non-technical stakeholders, including 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 in Agile development environments utilizing JIRA, Azure DevOps, or similar tools.

• Familiarity with sprint planning, backlog management, peer code reviews, technical documentation, metadata management, and coordination of data quality and reporting deliverables.

• Experience implementing and managing AI-assisted development practices using tools such as GitHub Copilot.

• Ability to set review standards, validate AI-generated outputs, protect PHI/PII, and ensure adherence to federal responsible AI guidelines.

• U.S. Citizenship is required.

• All selected candidates must successfully pass a background check.

• Ability to obtain and maintain a Government/Public Trust clearance, including necessary 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.