SQL Developer, Analyst

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

📋 Description

• Create, sustain, and enhance complex SQL queries, scripts, and transformation logic for data extraction, validation, reconciliation, and analysis across extensive clinical and operational datasets in SQL Server.

• Examine and interpret healthcare data from various systems, identify trends and irregularities, and generate reports, dashboards, and visualizations utilizing Power BI, Tableau, Excel, and other business intelligence tools.

• Work collaboratively with developers, data engineers, and program stakeholders on data flows, source-to-target mappings, transformation requirements, and both conceptual and physical data models.

• Provide support for federal healthcare data warehouses and integration initiatives.

• Design and uphold data quality monitoring processes, validation routines, and reconciliation reports throughout migration and EHR modernization activities.

• Investigate data discrepancies, conduct exploratory data analysis and root cause examinations, document findings, and maintain data dictionaries, mapping specifications, runbooks, and validation protocols.

• Assist with recurring reporting deliverables.

• Assess AI-assisted tools for SQL optimization, automated data quality checks, anomaly detection, and technical documentation while validating generated outputs and ensuring data security and quality standards.

• Assume additional tasks and responsibilities as needed to achieve team objectives and project success.

⛳️ Requirements

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

• A minimum of five (5) years of pertinent professional experience.

• Extensive hands-on experience in developing advanced SQL queries, scripts, and data extraction processes using Microsoft SQL Server.

• Experience in managing large, complex datasets and enhancing query performance.

• Background in analyzing healthcare or clinical datasets.

• Familiarity with healthcare data standards and systems such as HL7, FHIR, or VistA.

• Experience in supporting data validation, transformation, and integration tasks.

• Strong comprehension of relational database structures, data modeling, indexing, normalization, and performance tuning.

• Proficient in developing reports and visualizations using Power BI, Tableau, or Microsoft Excel.

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

• Keen attention to detail and capability to identify data discrepancies, investigate root causes, and guarantee data accuracy and integrity.

• Excellent written and verbal communication, documentation, and collaboration skills.

• Ability to convey technical findings to both technical and non-technical stakeholders and work efficiently within interdisciplinary teams.

• Previous experience supporting Department of Veterans Affairs healthcare data systems, including VX130, Oracle Health Millennium, or the Corporate Data Warehouse (CDW) is a plus.

• Familiarity with InterSystems IRIS, Caché, mirrored database architectures, or EHR data migration and cutover verification activities is a plus.

• Experience working within Agile development environments using JIRA, Azure DevOps, or similar tools is a plus.

• Knowledge of healthcare data governance, metadata management, source-to-target mapping, data quality monitoring, and technical documentation practices is a plus.

• Experience using AI-assisted tools such as GitHub Copilot for SQL and data quality tasks is a plus.

• Understanding of AI output validation, PHI/PII protection, and responsible AI practices within federal healthcare environments is a plus.

• U.S. Citizenship is mandatory.

• Successful completion of a background check is required.

• Ability to obtain and maintain a Government/Public Trust clearance, including required fingerprinting, when necessary.

• Sponsorship is not available.

🏝️ Benefits

• Medical/Dental/Vision coverage.

• 401k with Employer Match.

• Paid Time Off (PTO) + Federal Holidays.

• Corporate Laptop provided.

• Opportunities for Training.

• Remote Work Opportunity.