Senior SQL Server ETL / BI Developer

Overview

Remote
$80,000 - $180,000
Full Time
10% Travel
Able to Provide Sponsorship

Skills

ADF
Apache Parquet
Business Analysis
Business Intelligence
Call Center
Cloud Computing
Collaboration
Communication
Computer Science
Conflict Resolution
Critical Thinking
Customer Relationship Management (CRM)
Data Governance
Data Lake
Data Quality
Data Warehouse
Database
Decision-making
Healthcare Information Technology
ETL Architecture
Extract
Transform
Load
HIPAA
Health Care
Leadership
Management
Master Data Management
Mentorship
Microsoft Azure
Microsoft SQL Server
Microsoft SSIS
Optimization
Presentations
Problem Solving
Quality Assurance
Regulatory Compliance
SQL
Software Engineering
Stored Procedures
Streaming
Transact-SQL
Workflow

Job Details

ETL Development & Architecture:

Lead design and development of complex, scalable ETL frameworks supporting SQL Server, ADF, Synapse, and Azure Data Lake.

Build reusable, high-performance ETL processes integrating diverse data sources, including Parquet files and streaming data via ksql.

Contribute to enterprise lakefront and cloud BI strategies, evaluating ETL tools, automation, and pipeline optimization.

Data Quality & Governance:

Implement advanced QA, validation, and data quality processes to ensure integrity and reliability.

Ensure all ETL processes meet HIPAA and enterprise data governance standards.

Collaborate with architects, compliance, and business teams to define and enforce security, quality, and compliance standards.

Leadership & Mentorship:

Mentor and guide junior developers, sharing best practices and overseeing code quality.

Troubleshoot and resolve complex ETL and data challenges, recommending proactive solutions.

Document ETL architecture, workflows, dependencies, and transformations for enterprise reference.

Required Qualifications:

Education & Experience:

Bachelor s Degree in Computer Science, Software Engineering, or equivalent experience.

8+ years of experience in SQL Server ETL/BI development, including large-scale enterprise data warehouses and platforms.

Experience with application/business analysis techniques and cross-functional collaboration.

Technical Expertise:

ETL Tools: SQL Server Integration Services (SSIS), Azure Data Factory (ADF)

Cloud Platforms: Azure Synapse, Azure Data Lake

Databases & SQL: SQL Server, T-SQL (stored procedures, triggers, views, indexing, optimization)

Data Formats & Streaming: Parquet files, ksql

Enterprise Platforms: Data lakefront architectures, enterprise data warehouses

Governance & Compliance: Data governance, master data management, enterprise data quality frameworks, HIPAA compliance

Monitoring & Diagnostics: Performance and troubleshooting tools

Soft Skills:

Exceptional problem-solving, critical thinking, and decision-making skills

Excellent written and verbal communication for cross-team and executive-level presentations

Proven ability to lead projects independently in a fast-paced, high-growth environment

Preferred Skills:

Knowledge of CRM systems and call center data processes

Expertise in dynamic ETL frameworks and automating data workflows

Experience in the HealthCare / Health IT domain

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About StratEdge It consulting INC