ETL Analyst

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

About Vision: DataScout, a Vision Government Solutions company, is a leading high-tech Government Technology firm providing cutting-edge software and services to the public sector. Through our efforts, local communities have the funding needed to maintain roads, schools and emergency services. Responsibilities

• Profiling and normalizing incoming raw data files (CSV, flat files, Excel, database files).
• Monitoring and troubleshooting production ETL processes, investigating and resolving failures.
• Building and modifying SSIS packages for reoccurring ETL processes, with guidance from senior database team members.
• Making routine database schema changes, under the direction of senior database team members, and participating in design reviews for larger changes.
• Assisting with onboarding new clients and new data sources. Verifying data sources conform with existing data warehouse structures.
• Running data quality checks and flagging anomalies before they reach the customer.
• Responding to data issues reported by internal teams, tracing them back to the source and documenting the fix.
• Translating data issues into plain language for Sales and Customer Relations and into clear technical detail for Development.
• Documenting ETL processes, data sources, and load schedules.

Qualifications

• 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:
  • 2+ years' experience in Microsoft SQL Server relational databases and familiarity with a scripting or programming language (C#, Python, or PowerShell) for automating data tasks.
• Ability to write and troubleshoot T‑SQL Code, write ad hoc queries for reports, and design (stored procedures, tables, views, indexes, constraints)

Other desirable skills

• Experience with ETL design and operations: SQL Server Integration Services (SSIS), SQL Server Agent, and SQL Server Data Tools (SSDT).
• 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.

What we offer

• A competitive salary
• A comprehensive benefits package which includes:
  • Paid Time Off (PTO)
  • Eligible for 401K retirement plan participation with a company percentage match
  • Health, dental and vision policies
  • Company paid long and short term disability

Job Type: Full-Time, Hybrid

Equal Employment Opportunity

Vision Government Solutions is an Equal Opportunity Employer and committed to a diverse and inclusive workplace. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

We're proud to be an equal opportunity employer and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability and Veteran status.

Vision Government Solutions maintains a drug-free workplace.