SQL Developer, Analyst

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

📋 Description

• Assist in a major federal government healthcare modernization initiative for the Department of Veterans Affairs.

• Conduct SQL development, data analysis, reporting, and oversee data quality monitoring for electronic health record modernization projects.

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

• Analyze and interpret healthcare data across various systems.

• Detect trends and anomalies within the data.

• Generate reports, dashboards, and visualizations utilizing Power BI, Tableau, Excel, and other business intelligence tools.

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

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

• Evaluate data completeness, accuracy, consistency, and timeliness during migration and EHR modernization processes.

• Investigate data discrepancies and conduct exploratory data analysis and root cause assessments.

• Document findings and maintain data dictionaries, mapping specifications, runbooks, and validation protocols.

• Support ongoing reporting deliverables.

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

• Validate outputs generated and uphold data security and quality standards.

• Assume additional tasks and responsibilities as necessary to achieve team objectives and ensure 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 place of a degree.

• At least 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 with large, complex datasets and optimizing query performance.

• Background in analyzing healthcare or clinical datasets.

• Knowledge of healthcare data standards and systems, including HL7, FHIR, or VistA.

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

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

• Familiarity with developing reports and visualizations using Power BI, Tableau, or Microsoft Excel.

• Strong analytical, troubleshooting, and problem-solving capabilities.

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

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

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

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

• Familiarity with InterSystems IRIS, Caché, mirrored database architectures, or EHR data migration and cutover verification tasks.

• Experience working in Agile development environments using JIRA, Azure DevOps, or similar tools.

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

• Experience utilizing AI-assisted tools such as GitHub Copilot.

• Understanding of AI output validation, PHI/PII protection, and responsible AI practices within federal healthcare settings.

• 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.

• Unfortunately, we are unable to provide sponsorship at this time.

🏝️ Benefits

• Medical/Dental/Vision coverage.

• 401k plan with Employer Match.

• Paid Time Off (PTO) plus Federal Holidays.

• Corporate Laptop provided.

• Opportunities for Training.

• Remote Work Opportunity.