Jobs via Dice
Job Summary
The Senior Developer will be responsible for developing and optimizing SQL-based back-end systems, designing complex stored procedures, and managing data warehousing and reporting processes that ensure data accuracy, reliability, and scalability. This role requires deep technical expertise in Microsoft SQL Server and experience supporting public health or healthcare data systems with strong data governance and compliance requirements.
Key Responsibilities
Database Development & Maintenance - Design, develop, and maintain complex stored procedures, functions, and triggers to support data collection, validation, and reporting functions within the eSHARE system.
Performance Optimization - Analyse, troubleshoot, and resolve performance bottlenecks in SQL queries, indexes, and execution plans. Implement database tuning and query optimization strategies to ensure efficient data processing at scale.
ETL and Data Integration - Develop and manage ETL workflows for data ingestion and transformation between eSHARE and other systems, ensuring data integrity and consistency across multiple health program databases.
Reporting & Data Warehousing - Design and maintain database schemas and data marts to support complex reporting, dashboards, and analytics requirements across multiple HIV‑related programmes.
Quality Assurance & Data Validation - Create and maintain data validation routines to ensure completeness and accuracy of public health data in compliance with federal reporting requirements (e.g., Ryan White Services Report [RSR]).
Security & Compliance - Implement secure database access controls and support data governance activities to maintain HIPAA and CJIS compliance for health data.
Collaboration & Documentation - Work closely with application developers, data analysts, and programme managers to design back‑end solutions that meet program needs. Document database designs, ETL logic, and operational processes for ongoing maintenance and audits.
Required Skills & Qualifications
Bachelor s degree in Computer Science, Information Systems, or a related field.
7+ years of experience in database design, development, and performance optimisation.
Strong expertise in:
Microsoft SQL Server (2016 or later)
Advanced T‑SQL programming, including complex stored procedures, functions, triggers, and query logic
Query optimisation, index tuning, and performance troubleshooting
Database design and normalisation principles
Data extraction, transformation, and loading (ETL) workflows
Experience with data warehousing, reporting, and health data systems supporting large‑scale public health or clinical programmes.
Demonstrated experience working with data privacy and security standards, including HIPAA and PII data handling.
Strong analytical, diagnostic, and problem‑solving abilities.
Preferred Qualifications
Experience with eSHARE, AIRS, or other public health data management systems.
Familiarity with HL7, FHIR, or other healthcare data exchange standards.
Experience using Azure SQL Database, SSIS, or Data Factory for ETL and integration.
Proficiency with Power BI, SSRS, or other reporting and visualisation tools.
Knowledge of data warehouse modelling (star/snowflake schemas) and performance tuning for large data sets.
Experience in Agile environments supporting continuous integration and delivery.
Job Details
Seniority level: Mid‑Senior level
Employment type: Full‑time
Job function: Information Technology
Industries: Software Development
Contact Location: NY LIC, Hybrid Duration: Long Term
#J-18808-Ljbffr
Key Responsibilities
Database Development & Maintenance - Design, develop, and maintain complex stored procedures, functions, and triggers to support data collection, validation, and reporting functions within the eSHARE system.
Performance Optimization - Analyse, troubleshoot, and resolve performance bottlenecks in SQL queries, indexes, and execution plans. Implement database tuning and query optimization strategies to ensure efficient data processing at scale.
ETL and Data Integration - Develop and manage ETL workflows for data ingestion and transformation between eSHARE and other systems, ensuring data integrity and consistency across multiple health program databases.
Reporting & Data Warehousing - Design and maintain database schemas and data marts to support complex reporting, dashboards, and analytics requirements across multiple HIV‑related programmes.
Quality Assurance & Data Validation - Create and maintain data validation routines to ensure completeness and accuracy of public health data in compliance with federal reporting requirements (e.g., Ryan White Services Report [RSR]).
Security & Compliance - Implement secure database access controls and support data governance activities to maintain HIPAA and CJIS compliance for health data.
Collaboration & Documentation - Work closely with application developers, data analysts, and programme managers to design back‑end solutions that meet program needs. Document database designs, ETL logic, and operational processes for ongoing maintenance and audits.
Required Skills & Qualifications
Bachelor s degree in Computer Science, Information Systems, or a related field.
7+ years of experience in database design, development, and performance optimisation.
Strong expertise in:
Microsoft SQL Server (2016 or later)
Advanced T‑SQL programming, including complex stored procedures, functions, triggers, and query logic
Query optimisation, index tuning, and performance troubleshooting
Database design and normalisation principles
Data extraction, transformation, and loading (ETL) workflows
Experience with data warehousing, reporting, and health data systems supporting large‑scale public health or clinical programmes.
Demonstrated experience working with data privacy and security standards, including HIPAA and PII data handling.
Strong analytical, diagnostic, and problem‑solving abilities.
Preferred Qualifications
Experience with eSHARE, AIRS, or other public health data management systems.
Familiarity with HL7, FHIR, or other healthcare data exchange standards.
Experience using Azure SQL Database, SSIS, or Data Factory for ETL and integration.
Proficiency with Power BI, SSRS, or other reporting and visualisation tools.
Knowledge of data warehouse modelling (star/snowflake schemas) and performance tuning for large data sets.
Experience in Agile environments supporting continuous integration and delivery.
Job Details
Seniority level: Mid‑Senior level
Employment type: Full‑time
Job function: Information Technology
Industries: Software Development
Contact Location: NY LIC, Hybrid Duration: Long Term
#J-18808-Ljbffr