Senior Database Developer (SQL) Project Lead

InterSources Inc.

Cayce, SC(remote)

Apply

JOB DETAILS

SKILLS

Artificial Intelligence (AI), Automation, Best Practices, Centers for Disease Control and Prevention (CDC), Cloud Applications, Cloud Computing, Code Reviews, Data Analysis, Data Formats, Data Management, Data Mapping, Data Migration, Data Processing, Data Quality, Data Sets, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Database Programming, Disease Investigation, ERP (Enterprise Resource Planning), Editing, HIPAA (Health Insurance Portability and Accountability Act), HL7 (Health Level 7), Healthcare, ISO (International Organization for Standardization), Identify Issues, Information Technology Consulting, International Electro-Technical Commission (IEC), Internet Security, Maintain Compliance, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Onboarding, Online Marketing, Oracle, Power BI, Process Development, Process Flow, Production Control, Production Support, Public Health, Quality Assurance, Query Optimization, Relational Databases (RDBMS), Reporting Dashboards, Reporting Skills, SOAP (Simple Object Access Protocol), SOAP Notes, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Software Development, Statistical Analysis System (SAS), Stored Procedures, System Integration (SI), Systems Administration/Management, Technical Leadership, Technical Writing, User Experience Design (UXD), User Interface Design, Validation Testing, Web Programming, XML (EXtensible Markup Language)

LOCATION

Cayce, SC(remote)

POSTED

3 days ago

Title: Senior Database Developer (SQL) – Project Lead (11508)
Location: Cayce, SC (100% Remote – Nationwide Candidates Accepted)
Duration: 12 Months
Interview Process: One Round Virtual Interview

Required Skills

3+ years of experience with MS T-SQL (Stored Procedures, Advanced Queries, Query Optimization)
3+ years of experience developing ETL processes and data pipelines
1+ year of experience with SQL Server Integration Services (SSIS)
3+ years of experience with report development and reporting solutions
3+ years of experience with Data Warehousing and Relational Databases
1+ year of experience working with HL7 v2.3.1 – v2.5.1 and ORU Messages
3+ years of experience processing and parsing XML data
3+ years of experience with Microsoft SQL Server 2016+
1+ year of experience with CDC, HIPAA, CJIS, PHI, and PII security/data classification requirements

Preferred Skills

Experience managing large data sets (1TB+)
Requirements Gathering and Documentation
Public Health / Disease Surveillance Systems experience
Statistical Analysis System (SAS)
LOINC and SNOMED
FASTQ Files and Demultiplexing
R and RStudio
CDC Reporting Systems
Electronic Case Reporting (eCR)

Responsibilities

Design, develop, and maintain ETL processes, data pipelines, and automation solutions
Create, optimize, and troubleshoot complex T-SQL stored procedures, functions, and advanced queries
Develop and support SSIS packages and integration solutions
Participate in EDSS migration and data modernization initiatives
Design and maintain Data Warehouse solutions
Develop reports, dashboards, and reporting processes
Parse and process healthcare data formats including XML, HL7, CSV, and SOAP messages
Support eCR onboarding, data imports, process automation, troubleshooting, and reporting
Monitor production data processing and ensure successful data flow
Perform data validation, testing, deployment, and post-production support
Rewrite and convert legacy SAS processes into SSIS and Power BI solutions
Support system upgrades, database migrations, and environment configurations
Create technical documentation, process flows, and data mapping documents
Gather business requirements and perform gap analysis with stakeholders
Ensure compliance with DPH, CDC, HIPAA, CJIS, PHI, and PII security requirements
Provide technical guidance, code reviews, and best practices to team members

Environment

Microsoft SQL Server 2016+
T-SQL
SQL Server Management Studio (SSMS)
SQL Server Integration Services (SSIS)
Power BI
ETL/Data Pipeline Development
HL7 v2.x (ORU Messages)
XML, CSV, SOAP
Data Warehousing
CDC Reporting Systems
Electronic Disease Surveillance Systems (EDSS)
eHARS
EpiTrax
SAS
Healthcare/Public Health Data Systems

About Us:
InterSources Inc , is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.

About the Company

InterSources Inc.

It’s all about harnessing the real power of data. InterSources Inc was founded in 2007 providing intelligent data solutions to clients across industries and geographies.

Over the years, we have built products on Business Intelligence & Big Data platform simplifying and transforming the way business intelligence and real-time data analytics empower Corporations and end-users using Softwares like Tableau, Business Objects, MicroStrategy, etc.

In the process, we have enabled companies to use data analytics to help better understand, predict and influence consumer behavior, identify new market opportunities as they emerge, provide to users the data they need, alert the user when and why key business metrics have changed and enable them to make smart decisions.

COMPANY SIZE

100 to 499 employees

INDUSTRY

Computer/IT Services

FOUNDED

2007

WEBSITE

https://www.intersourcesinc.com/