Production Specialist (ETL)
Core
Executes dataset onboarding, ETL script configuration, database provisioning, and quality assurance for data assets primarily from CDD/Data IQ sources.
Role type
Production Specialist (ETL)
Builds
ETL databases and reference databases across Dev, Demo, and Live environments
Domain
Healthcare intelligence / Life sciences data infrastructure
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
SQL query writing, Microsoft SQL Server Management Studio, Visual Studio 2022, Snowflake, Gitlab, ID Gatekeeper, SSIS package execution, database backup and restore, row count validation, documentation maintenance, issue escalation
Preferred skills
JIRA, ARA, Microsoft Excel macros and functions, basic Git terminology
Technologies
Microsoft SQL Server, Snowflake, Visual Studio, Gitlab, SSIS, ID Gatekeeper
Responsibilities
Execute dataset onboarding from CDD/Data IQ sources; Configure and execute ETL scripts; Provision ETL databases across Dev, Demo, and Live environments; Perform post-load analysis comparing row counts; Manage roles and permissions across environments; Execute integration scripts in Snowflake and SQL servers; Conduct QA in Dev and Demo before live deployment; Update database documentation; Serve as first escalation point for issues; Evaluate existing processes for continuous improvement.
Seniority
Mid-level, hands-on IC