
SQL Developer, Analyst
Posted 3 days ago

Posted 3 days ago
This is a fully remote position, open to applicants in United States.
• Design, maintain, and enhance sophisticated SQL queries, scripts, and data transformation workflows.
• Assist in data extraction, validation, reconciliation, and analysis tasks.
• Evaluate intricate healthcare and operational datasets to uncover trends, anomalies, and data inconsistencies.
• Create reports, dashboards, and visual representations utilizing Power BI, Tableau, and Excel.
• Partner with developers, data engineers, and stakeholders for data integration, source-to-target mapping, transformation specifications, and database modeling.
• Establish and uphold data quality monitoring systems, validation processes, and reconciliation reports.
• Conduct exploratory data analysis and root cause analysis.
• Record findings and maintain technical documentation, encompassing data dictionaries, mapping specifications, and validation protocols.
• Aid in the delivery of recurring reporting requirements.
• Utilize AI-assisted tools to enhance SQL development, data quality monitoring, anomaly detection, and technical documentation.
• Ensure the security and accuracy of data.
• Undertake additional responsibilities as needed to advance project goals and foster organizational innovation initiatives.
• Bachelor's degree in Computer Science, Electronics Engineering, or a related engineering or technical field.
• Over 5 years of experience in developing advanced SQL queries, scripts, and data extraction techniques using Microsoft SQL Server.
• Proven experience with large datasets and optimizing query performance.
• Background in analyzing healthcare or clinical datasets.
• Knowledge of healthcare data standards and systems such as HL7, FHIR, or VistA.
• Strong grasp of relational databases, data modeling, indexing, normalization, and performance tuning.
• Experience in creating reports, dashboards, and data visualizations with Power BI, Tableau, or Microsoft Excel.
• Excellent analytical, troubleshooting, and problem-solving abilities.
• Strong written and verbal communication skills.
• Capability to document technical insights and collaborate with both technical and non-technical stakeholders.
• Previous experience supporting Department of Veterans Affairs (VA) healthcare programs and data systems.
• Familiarity with VA systems and technologies, including VX130, Oracle Health Millennium, Corporate Data Warehouse (CDW), InterSystems IRIS, Caché, and mirrored database architectures.
• Experience with EHR data migration, integration, validation, and cutover verification tasks.
• Background in Agile environments using JIRA, Azure DevOps, or similar project management software.
• Knowledge of healthcare data governance, metadata management, source to target mapping, and data quality monitoring.
• Proficient in using AI-assisted development tools like GitHub Copilot.
• Understanding of AI output validation, PHI/PII protection, and responsible AI practices in federal healthcare settings.
• Eligibility to obtain a government clearance.
• Selected candidates must undergo fingerprinting at a government facility and complete a background check.
• Candidates must reside within the continental US.
• Currently, we are unable to provide sponsorship.
• Medical/Dental/Vision coverage.
• 401k plan with Employer Match.
• Paid Time Off (PTO) plus Federal Holidays.
• Corporate Laptop provided.
• Opportunities for training and professional development.
• Remote work opportunity available.
Lygos Finance
Strategic Tech Solutions LLC
Intelura
Get handpicked remote jobs straight to your inbox weekly.