> Markdown version of [/jobs/ext/620836-sql-database-developer-project-lead](https://www.wearedevelopers.com/jobs/ext/620836-sql-database-developer-project-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # SQL Database Developer / Project Lead - **Company:** HTC Global Services, Inc. - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Databases, Extract Transform Load (ETL), Data Warehousing, Relational Databases, Database Design, Software Debugging, Microsoft SQL Server, Parsing, Query Optimization, Power BI, SAS (Software), Simple Object Access Protocol (SOAP), SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Data Streaming, Transact-SQL, Extensible Markup Language (XML), Data Import/Export, Data Classification, Health Level Seven International, Data Pipelines - **Published:** June 23, 2026 - **Apply:** https://www.dice.com/job-detail/5a9c0726-7d9b-4b10-8f10-0569349ea1b4 ## About the Role * 3+ years of experience with MS T-SQL, including stored procedures, advanced queries, and 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 and relational databases. * 1+ year of experience with HL7 v2.3.1 2.5.1 and ORU messages. * 3+ years of experience working with XML. * 3+ years of experience with Microsoft SQL Server 2016+. * 1+ year of experience with security and data classification related to CDC, HIPAA, CJIS, PHI, and PII. * Ability to work independently with limited supervision while collaborating effectively with technical teams and stakeholders. * Strong written, verbal, and interpersonal communication skills. * Experience preparing technical documentation, specifications, data flows, and process diagrams. * Ability to manage project tasks, estimates, status reporting, and milestone completion. ## Description * Support migration efforts related to Electronic Disease Surveillance Systems (EDSS). * Participate in data warehousing, reporting, and data pipeline improvement initiatives. * Gather and document functional requirements and perform gap analysis with end users. * Create and maintain process documentation, data flows, and diagrams. * Design, develop, automate, and optimize ETL processes. * Develop and maintain SQL stored procedures, advanced queries, and reports. * Perform query debugging, optimization, and performance improvements using MS T-SQL. * Rewrite and optimize existing SAS solutions into SSIS packages and Power BI solutions. * Develop, modify, monitor, and support data pipelines and reporting processes. * Assist with formatting and automating data uploads into data warehouse and disease surveillance systems. * Parse and process multiple data formats including XML, CSV, SOAP, and HL7. * Support system, database, and data migrations, including testing and validation activities. * Assist with eCR onboarding, data import, utilization, automation, troubleshooting, analysis, and reporting. * Monitor production processing to ensure proper data flow and response times. * Automate and support daily maintenance processes. * Troubleshoot, debug, optimize, and resolve processing issues. * Support server, database, software upgrades, and environment configuration activities. * Ensure business continuity and maximum uptime for critical systems. * Advise team members on database design, query optimization, automation, reporting, and best practices. * Mentor team members and staff on advanced technical topics. * Coordinate with managers, project managers, vendors, contractors, and technical teams on assignments and deliverables. * Provide project estimates, status reporting, and progress updates. * Ensure compliance with IT standards, security policies, procedures, and documentation requirements. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) ## Related Articles - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)