ETL Analyst
Core
Profiling, normalizing, and monitoring ETL processes for public sector data; building SSIS packages and managing SQL Server databases to ensure data quality for customers.
Role type
ETL Analyst (SQL Server)
Builds
Production ETL pipelines and data warehouse structures for public sector clients
Domain
Government Technology / Data Engineering
Required skills
Microsoft SQL Server, T-SQL, SSIS, C#/Python/PowerShell, Database Schema Design, Data Quality Checks, Troubleshooting ETL Failures
Preferred skills
Azure Data Factory, Azure Cloud Hosting, Server Administration, Index Management
Responsibilities
Profile and normalize incoming raw data files; Monitor and troubleshoot production ETL processes; Build and modify SSIS packages; Make routine database schema changes; Run data quality checks and flag anomalies; Document ETL processes and data sources
Seniority
Mid-level, hands-on IC