ETL Analyst - Data Integration, QA & Troubleshooting

VGSI; Fayetteville (AR); On-site; USD 55,000 - 70,000; Full time

Benefits offered by this job

PTO

401K with company match

Health, dental and vision insurance

Disability insurance

Job summary

Vision Government Solutions in Fayetteville, AR seeks a data ETL specialist to profile and normalize diverse data sources, monitor ETL workflows, and build SSIS packages. You will work with the database team to implement schema changes and ensure data quality for customer deployments.

Qualifications include a bachelor’s degree or equivalent, 2+ years with SQL Server, and scripting skills (C#, Python or PowerShell).

Qualifications

• Bachelor's degree in information systems, computer science, data analytics, or 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.

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 recurring ETL processes with guidance from senior database team members.
• Making routine database schema changes under direction of senior team members and participate 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.
• Translating data issues into plain language for Sales/Customer Relations and into clear technical detail for Development.
• Documenting ETL processes, data sources, and load schedules.

Skills

SQL Server

T-SQL

Scripting (C#, Python or PowerShell)

Education

Bachelor's degree in information systems / computer science / data analytics

Tools

SSIS

SSDT

Azure Data Factory

Job description

Vision Government Solutions in Fayetteville, AR seeks a data ETL specialist to profile and normalize diverse data sources, monitor ETL workflows, and build SSIS packages. You will work with the database team to implement schema changes and ensure data quality for customer deployments.

Qualifications include a bachelor’s degree or equivalent, 2+ years with SQL Server, and scripting skills (C#, Python or PowerShell).