Lead SQL Database Developer, Remote, SC, USIntellibee • New York, New York, United States
Lead SQL Database Developer, Remote, SC, US
Intellibee
- New York, New York, United States
- New York, New York, United States
Über
A Senior Data Developer is needed to support the STD / HIV program area. Project work includes transition from our current to replacement Electronic Disease Surveillance System (EDSS), the continuing Data Warehousing project, Data Pipeline improvement, and supporting new solutions for eCR onboarding and utilization. This need includes requirements gathering with customers, providing technical advice, time and effort estimates, and project documentation including status reporting. Expected work includes process development and automation, ETL solutions, advanced querying, stored procedure creation, parsing various data formats including xml and HL7, SSIS development and debugging, and reporting. The developer will help with testing, validations, user acceptance testing, deployment, and postimplementation support. Continued support will consist of modifications to include new data elements. Ensure systems are following industry best practices to ensure strategic initiatives and compliance with federal and state regulatory laws and ensure business continuity. The candidate may also provide proactive monitoring processes for immediate identification and resolution of data processing issues.
This position will be a part of the team responsible for supporting critical systems and environments used by our STD HIV team, the Public Health Lab, and Disease Surveillance.
Daily Duties / Responsibilities: The candidate will work closely with members of the Systems Integration, Health Data Visualizations, and Database Administration teams as well as STD / HIV program staff.
The candidate should be self-motivated and team-oriented, work under limited supervision, and respond to priority tasks. The candidate must be able to independently research and design processes, create specifications and data flows, develop ETL processes, make stored procedures, advanced queries, and reports, assist with validations, actively engage with the Team and stakeholders, attend meetings, provide guidance, and respond promptly.
Participate in a team comprised of DPH and solution implementation staff providing STD HIV system and data migration support, data pipeline improvement and monitoring, data warehousing and reporting. New solutions for eCR onboarding, import and utilization will be included. Work can consist of planning, design, configuration, process development, SSIS and script coding, and automation of data flows. Will coordinate with the assigned IT Section Manager and Team Lead on daily assignments/tasks. Will coordinate and collaborate with contract and vendor staff, existing DPH staff, and other I. T. professionals working with the Office of Information Technology. Ensure assignments are completed accurately and on time, assist with problem resolution, mitigate issues, provide solutions, communicate, and elevate as needed to management, and report progress to the manager.
Will advise staff on code conversions, database and query design, optimization, process improvements and automation, validations, reporting, and report creation. Work with vendors and staff on deliverables, debugging, and converting current processes to SSIS and PowerBI. This includes rewriting existing SAS solutions to conform to best practices and updated coding standards and improving efficiency, performance, and maintenance.
Specific duties and responsibilities will include but are not limited to the following:
Prepare and maintain process documentation, data flows, and diagrams for assigned processes (new and existing).
Work with end users to perform gap analysis, gather and document functional requirements, and create necessary processes
Assist with project and time management including estimates and status reporting
Ability to plan, organize, review, and implement associated project milestones to completion.
Process Development, Process Automation, and ETL Solutions
SQL stored procedure creation, advanced query design, debugging, and optimization (MS T-SQL)
Rewriting of SAS code into SSIS Packages and Power B.I.; SSIS Debugging, Rewriting and optimization of remaining SAS code and queries as needed.
Data Pipeline and Reporting Development, Modification, Improvement, and Monitoring
Help format and automate data uploads into the Data Warehouse and Disease Surveillance Systems like CDC SAMS / eHARS and the new Electronic Disease Surveillance System (EpiTrax)
Parsing of multiple data formats including xml\, csv, SOAP, HL7
Assist with system, data and database migrations and related changes, testing, and validation
Help with eCR solutions including condition authoring, data import and utilization, process automation and troubleshooting, and data review, analysis, and reporting
Monitor production processing to ensure proper data flow and response times
Help to perform and automate daily maintenance processes
Debug, troubleshoot, and optimize new and existing processes.
Resolve processing issues.
Support related server, database, software upgrades, and new environment configuration
Ensure maximum system uptime for critical components to ensure business continuity.
Advise the Team on best practice and techniques. Mentor team and staff on advanced topics.
Modification / rewrite of existing processes and creation of new processes to be compliant with agency security requirements and following industry best standards
The candidate will work closely with the Systems Integration Section Manager and Project Manager(s) to identify, prioritize, and schedule workload and implementation to I. T. standards and procedures. The candidate will also work closely with customers and subject matter experts on process design, migration to the platforms, and testing.
This will also include compliance with DPH security policy/procedures and integrating systems, when possible, to streamline staff workflows, user security, data analytics, and reporting.
Module support of the project.
DPH will require that selected personnel sign the DPH confidentiality agreement and/or Business Associate (BA) agreement if applicable. All web services must be secure.
DPH will not accept any offers including an “up-lift” charge. The rate paid per consultant must not exceed the maximum rate established for this position described in the State contract terms.
Follow agency IT Standards, policies, and procedures to include documentation.
All source code (compiled and un-compiled) will become the sole property of the South Carolina Department of Public Health. Any source code, data, product, or functionality resulting from this SOW or previously owned/developed by DPH will remain the sole property of DPH and is not to be incorporated into the core product of any vendor's application. Any modifications and interfaces developed under said contract will not be used by the contractor for any independent project of the contractor or published or publicized by the contractor without written permission of DPH.
DPH has the final say on all programming choices.
DPH Support: DPH will provide:
All required information including formulas, data, and mechanisms to check output.
Staff to assist with any application or data questions.
Conference rooms and scheduling for any application demos.
A virtual workstation with required software.
Required Skills (rank in order of Importance):
3+ Years of Experience with MS T-SQL (Stored Procedures, Advanced Queries, Optimization)
3+ Years of Experience with ETL Process Development
1+ Year of Experience with SQL Server Integration Services (SSIS)
3+ Years of Experience with Report Development
3+ Years of Experience with Data Warehousing & Relational Databases
1+ Year of Experience HL7 v 2.3.1 -
2.5.1 and ORU Messages
3+ Years of Experience with XML
3+ Years of Experience with MS SQL Server 2016+
1+ Year of Experience with security and data classification related to CDC, HIPAA, CJIS, PHI, PII
Preferred Skills (rank in order of Importance):
Ability to manage large data sets (1 TB+)
Requirements Gathering & Documentation
Public Health / Disease Surveillance Systems Experience
Statistical Analysis System (SAS)
LOINC / SNOMED
FASTQ FILES AND DEMULTIPLEXING
R & RStudio
Microsoft SQL Server (2016+), T-SQL, SSMS
SQL Server Integration Services (SSIS) and ETL/Data Pipeline development
Data Warehousing environments and reporting tools (e.g., Power BI)
HL7 v2.x (including ORU), XML, CSV, and other structured data formats
Healthcare/public health data systems (e.g., EDSS, eHARS, CDC reporting systems)
Electronic Case Reporting (eCR) and data exchange integrations
SAS (legacy processes) and scripting for data transformation
HIPAA, PHI/PII, and CDC data standards and security compliance
Additional Skills (rank in order of Importance)
Ability to deal effectively with the needs of technical peers, technical and user management, users, vendors, and staff members, and to communicate clearly and effectively in spoken and written form
Solid background in data integration, staging, quality and distribution
Excellent written, oral, and interpersonal communication skills
Benefits at IntelliBee
Long-Term Stability:
Join us on a multi-year opportunities with room to grow.
Comprehensive Health Coverage:
Access quality healthcare benefits to keep you and your family well.
Future Planning:
Enroll in our 401(k) program and invest in your financial security.
GC Assistance:
We support immediate Green Card processing, if required.
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.