Job Description
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
Preferred Skills
Responsibilities
Environment
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.
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
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.
Numbers & Facts
| Location | Cayce, SC (Remote) |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 2007 |
| Website | https://www.intersourcesinc.com/ |
About Company
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.
Skills
- Artificial Intelligence (AI)unmatched
- Automationunmatched
- Best Practicesunmatched
- Centers for Disease Control and Prevention (CDC)unmatched
- Cloud Applicationsunmatched
- Cloud Computingunmatched
- Code Reviewsunmatched
- Data Analysisunmatched
- Data Formatsunmatched
- Data Managementunmatched
- Data Mappingunmatched
- Data Migrationunmatched
- Data Processingunmatched
- Data Qualityunmatched
- Data Setsunmatched
- Data Warehousingunmatched
- Database Administrationunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Programmingunmatched
- Disease Investigationunmatched
- ERP (Enterprise Resource Planning)unmatched
- Editingunmatched
- HIPAA (Health Insurance Portability and Accountability Act)unmatched
- HL7 (Health Level 7)unmatched
- Healthcareunmatched
- ISO (International Organization for Standardization)unmatched
- Identify Issuesunmatched
- Information Technology Consultingunmatched
- International Electro-Technical Commission (IEC)unmatched
- Internet Securityunmatched
- Maintain Complianceunmatched
- Microsoft SQL Serverunmatched
- Microsoft Transact-SQL (T-SQL)unmatched
- Onboardingunmatched
- Online Marketingunmatched
- Oracleunmatched
- Power BIunmatched
- Process Developmentunmatched
- Process Flowunmatched
- Production Controlunmatched
- Production Supportunmatched
- Public Healthunmatched
- Quality Assuranceunmatched
- Query Optimizationunmatched
- Relational Databases (RDBMS)unmatched
- Reporting Dashboardsunmatched
- Reporting Skillsunmatched
- SOAP (Simple Object Access Protocol)unmatched
- SOAP Notesunmatched
- SQL (Structured Query Language)unmatched
- SQL Server Integration Services (SSIS)unmatched
- Software Developmentunmatched
- Statistical Analysis System (SAS)unmatched
- Stored Proceduresunmatched
- System Integration (SI)unmatched
- Systems Administration/Managementunmatched
- Technical Leadershipunmatched
- Technical Writingunmatched
- User Experience Design (UXD)unmatched
- User Interface Designunmatched
- Validation Testingunmatched
- Web Programmingunmatched
- XML (EXtensible Markup Language)unmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder