SQL Developer, Analyst

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

📋 Description

• Design, maintain, and enhance sophisticated SQL queries, scripts, and transformation logic within SQL Server.

• Facilitate data extraction, validation, reconciliation, and analysis across extensive clinical and operational datasets.

• Evaluate healthcare data from various systems, recognize trends and anomalies, and generate reports, dashboards, and visualizations.

• Utilize Power BI, Tableau, Excel, and other business intelligence tools for program reporting and informed decision-making.

• Partner with developers, data engineers, and program stakeholders on data flows, source-to-target mappings, transformation requirements, and data models.

• Create and uphold data quality monitoring processes, validation routines, and reconciliation reports.

• Assess data completeness, accuracy, consistency, and timeliness during migration and EHR modernization initiatives.

• Examine data discrepancies, conduct exploratory data analysis and root cause investigations, and document findings.

• Maintain data dictionaries, mapping specifications, runbooks, validation protocols, and other essential technical documentation.

• Assist with regular reporting deliverables.

• Evaluate AI-assisted tools for SQL optimization, automated data quality checks, anomaly detection, and technical documentation.

• Validate generated outputs while maintaining data security and quality standards.

• Undertake additional tasks and responsibilities as necessary to support team objectives and project success.

⛳️ Requirements

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

• At least five (5) years of pertinent professional experience.

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

• Proven experience working with large, complex datasets and optimizing query performance.

• Experience 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 understanding of relational database structures, data modeling, indexing, normalization, and performance tuning.

• Experience in generating reports and visualizations using Power BI, Tableau, or Microsoft Excel.

• Exceptional analytical, troubleshooting, and problem-solving skills with a keen attention to detail.

• Ability to identify data discrepancies, investigate root causes, and ensure data accuracy and integrity.

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

• Capability to present technical findings to both technical and non-technical stakeholders and collaborate effectively within multidisciplinary teams.

• Prior experience supporting Department of Veterans Affairs (VA) healthcare data systems, including VX130, Oracle Health Millennium, or the Corporate Data Warehouse (CDW) (additional qualification).

• Familiarity with InterSystems IRIS, Caché, mirrored database architectures, or EHR data migration and cutover verification activities (additional qualification).

• Experience working within Agile development environments using JIRA, Azure DevOps, or similar tools (additional qualification).

• Knowledge of healthcare data governance, metadata management, source-to-target mapping, data quality monitoring, and technical documentation practices (additional qualification).

• Experience utilizing AI-assisted tools such as GitHub Copilot for SQL and data quality efforts, along with an understanding of AI output validation, PHI/PII protection, and responsible AI practices (additional qualification).

• U.S. Citizenship is mandatory.

• Successful completion of a background check is required.

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

• Sponsorship is not available.

🏝️ Benefits

• Medical/Dental/Vision coverage.

• 401k plan with Employer Match.

• Paid Time Off (PTO) plus Federal Holidays.

• Corporate Laptop provided.

• Opportunities for training and development.

• Remote work opportunity available.