ETL Analyst

Vision Government Solutions Inc•Fayettville, AR

2d•Hybrid

About The Position

Vision: DataScout, a Vision Government Solutions company, is a high-tech Government Technology firm providing software and services to the public sector. The ETL Analyst supports data processing and data quality for public-sector clients by profiling and normalizing incoming data, operating and troubleshooting ETL processes, and helping onboard clients and data sources. The role works under the guidance of senior database team members on recurring ETL processes and routine database schema changes, while participating in design reviews for larger changes. The position translates and documents data issues for both business and technical audiences and documents ETL processes, data sources, and load schedules. The job is full-time and hybrid.

Requirements

Excellent organizational skills and a drive to meet and exceed goals.
A bachelor’s degree in information systems, computer science, data analytics, or a related field, or equivalent experience.
At least 2 years’ experience with Microsoft SQL Server relational databases.
Familiarity with a scripting or programming language such as C#, Python, or PowerShell for automating data tasks.
Ability to write and troubleshoot T-SQL code and write ad hoc queries for reports.
Ability to design stored procedures, tables, views, indexes, and constraints.

Nice To Haves

Experience with ETL design and operations using SQL Server Integration Services (SSIS), SQL Server Agent, and SQL Server Data Tools (SSDT); this is a plus, not required, and training on the company's stack is available.
Experience with Azure Data Factory and Azure cloud hosting environments.
Experience with server administration in a multi-server database environment.
Knowledge of indexes, index management, and database configuration.

Responsibilities

Profile and normalize incoming raw data files, including CSV, flat files, Excel, and database files.
Monitor and troubleshoot production ETL processes, investigating and resolving failures.
Build and modify SSIS packages for recurring ETL processes with guidance from senior database team members.
Make routine database schema changes under the direction of senior database team members and participate in design reviews for larger changes.
Assist with onboarding new clients and data sources, verifying that sources conform to existing data warehouse structures.
Run data quality checks and flag anomalies before they reach the customer.
Respond to data issues reported by internal teams, trace them to the source, and document the fix.
Translate data issues into plain language for Sales and Customer Relations and clear technical detail for Development.
Document ETL processes, data sources, and load schedules.