Hui Huliau Technology Services LLC is currently seeking an SQL Developer/Data Analyst to join their team. This role provides data analysis, report development, and support for ongoing data migration, integration, and quality monitoring activities. The ideal candidate combines strong SQL development skills with hands-on experience analyzing and validating clinical and operational datasets in support of electronic health record (EHR) modernization and reporting. This position requires U.S. citizenship, U.S. residency, and the ability to obtain and maintain a Public Trust clearance.

Responsibilities:

• Develop, maintain, and optimize SQL queries and scripts to support data validation, data extracts, and transformation logic across large clinical datasets.
• Analyze and interpret data from multiple systems to support business intelligence reporting, extract validation, and decision-making.
• Collaborate with developers, data engineers, and program stakeholders to understand data flows, transformation logic, and source-to-target mappings.
• Support the development and refinement of conceptual and physical data models used in federal healthcare data warehouses.
• Create and maintain data quality monitoring routines and reports used to track completeness, accuracy, and timeliness of data migration efforts.
• Document findings from exploratory data analysis, track anomalies, and support root-cause investigations with development and QA teams.
• Assist with the creation and maintenance of technical and user documentation, including data dictionaries, runbooks, and validation protocols.
• Support weekly and monthly reporting deliverables by generating custom queries, aggregating results, and formatting output for dashboards and briefings.
• Participate in stakeholder meetings and data review sessions, presenting findings and collaborating to resolve data discrepancies.

Required Qualifications:

• Bachelor’s degree in Computer Science, Data Analytics, Statistics, or a related technical field OR 8 years of additional relevant experience may be substituted for education
• 5+ years of experience developing advanced SQL queries and working with large, complex datasets in SQL Server environments.
• Experience analyzing healthcare or clinical data, including familiarity with data formats such as HL7, FHIR, or VistA.
• Strong understanding of data structures, indexing, performance tuning, and normalization techniques.
• Experience creating data visualizations and reports using tools such as Power BI, Tableau, or Excel.
• Excellent problem-solving skills, attention to detail, and ability to communicate technical findings to both technical and non-technical audiences.
• U.S. citizenship and ability to obtain and maintain a Public Trust clearance. Preferred

Qualifications:

• Experience supporting VA data systems, including VX130, Millennium, or the Corporate Data Warehouse (CDW).
• Familiarity with IRIS or Caché database environments and mirrored data architectures. .
• Exposure to Agile environments and tools such as JIRA or Azure DevOps.
• Experience supporting data quality or cutover verification activities in EHR transition projects.
• Knowledge of data governance practices and metadata documentation.

Physical Abilities

• Able to travel, as needed.
• Office computers and equipment, telephones, radios, Microsoft Office suite of tools, Web Based Applications, electronic spreadsheets and database analysis, outputs, and reporting, virtual data sharing platforms (e.g., SharePoint, Teams, etc.) and other forms of remote work-sharing tools.
• Must be able to sit, stand, and work at a computer for long periods of time. Ability up to lift 25lbs on occasion, stretching, climbing stairs, and walking.
• Must have personal computer with reliable Internet service.

Hui Huliau and its subsidiaries are participants of E-Verify.
Hui Huliau and its subsidiaries are drug free workplaces.

• Develop, maintain, and optimize SQL queries and scripts to support data validation, data extracts, and transformation logic across large clinical datasets.
• Analyze and interpret data from multiple systems to support business intelligence reporting, extract validation, and decision-making.
• Collaborate with developers, data engineers, and program stakeholders to understand data flows, transformation logic, and source-to-target mappings.
• Support the development and refinement of conceptual and physical data models used in federal healthcare data warehouses.
• Create and maintain data quality monitoring routines and reports used to track completeness, accuracy, and timeliness of data migration efforts.
• Document findings from exploratory data analysis, track anomalies, and support root-cause investigations with development and QA teams.
• Assist with the creation and maintenance of technical and user documentation, including data dictionaries, runbooks, and validation protocols.
• Support weekly and monthly reporting deliverables by generating custom queries, aggregating results, and formatting output for dashboards and briefings.
• Participate in stakeholder meetings and data review sessions, presenting findings and collaborating to resolve data discrepancies