Hybrid ETL Analyst: Data Pipelines & Quality

Vision-Government-Solution; Fayetteville (AR); Hybrid; USD 65,000 - 105,000; Full time

Benefits offered by this job

PTO

401K match

Health insurance

Dental insurance

Vision insurance

Disability insurance

Job summary

Vision Government Solutions seeks a data-focused professional to profile and normalize data files, monitor ETL processes, and build SSIS packages. You will work with SQL Server, T-SQL, and scripting languages to automate data tasks and support data warehouse initiatives.

You will onboard new data sources, perform data quality checks, and document ETL processes and load schedules while collaborating with multiple teams in a hybrid environment.

Qualifications

• Bachelor's degree or equivalent experience in information systems, CS, data analytics.
• 2+ years' experience with Microsoft SQL Server and scripting languages for automating data tasks.

Responsibilities

• Profile and normalize incoming data files (CSV, Excel, flat files, DB files).
• Monitor and troubleshoot ETL processes; resolve failures.
• Build/modify SSIS packages for recurring ETL tasks with guidance.
• Make routine schema changes under supervision and participate in design reviews.
• Onboard new clients and data sources; verify data sources align with data warehouse structures.
• Run data quality checks and flag anomalies before reaching customers.
• Respond to data issues; trace to source and document fixes.
• Translate data issues for Sales/Customer Relations and for Development.
• Document ETL processes, data sources, and load schedules.

Skills

SQL Server

T-SQL

Python

PowerShell

ETL scripting

Education

Bachelor's degree in Information Systems / Computer Science / Data Analytics

Tools

SSIS

SSDT

SQL Server Agent

Azure Data Factory

Job description

Vision Government Solutions seeks a data-focused professional to profile and normalize data files, monitor ETL processes, and build SSIS packages. You will work with SQL Server, T-SQL, and scripting languages to automate data tasks and support data warehouse initiatives.

You will onboard new data sources, perform data quality checks, and document ETL processes and load schedules while collaborating with multiple teams in a hybrid environment.