Data Engineer jobs

ETL Analyst

Vision Government Solutions IncFayettville, ARFull-timeHybridFirst seen 21 days ago

Pay not listed

Key facts

Experience
2+ years
Degree
Bachelor's degree or equivalent

This job is closed.

The employer took it down 4 days ago, after 17 days open. Here are similar open jobs.

  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteJazzHR board
  • Checked: No reposts foundJazzHR board
  • Note: Last seen open 21 days agoLive check
  • Trust score 89 / 100 · Looks good
See all 5 checksShow fewer
How we check

Similar jobs

Data and AI Architect

Ascend Technologies · Remote · US only

$140k/yrFull-time

StrongChecked open todayPosted 18 days ago

Digital Analytics Engineer

TransPerfect · Remote · 13 countries

Pay not listedContract

Looks good2 to checkChecked open todayPosted 8 months ago

Data Engineer Semi Senior

Join ready · Remote · US, Peru

Pay not listedFull-time

Looks good2 to checkChecked open todayPosted 2 months ago

ETL Developer

GRVTY · McLean, VA

$150k–$250k/yr

StrongChecked open todayPosted 11 days ago

See more like this

What you’ll do

  • Profile and normalize incoming data files, and verify new data sources fit existing warehouse structures.
  • Monitor and troubleshoot production ETL processes; build and modify SSIS packages.
  • Make routine database schema changes and participate in design reviews for larger changes.
  • Run data quality checks, investigate reported data issues, trace them to their source, and document fixes and processes.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 2+ years’ experience with Microsoft SQL Server relational databases
  • Experience with ETL design and operations using SSIS, SQL Server Agent, and SSDT (preferred)
  • Experience with Azure Data Factory and Azure cloud hosting environments (preferred)
  • Experience with server administration in a multi-server database environment (preferred)

Education

  • Bachelor’s degree in information systems, computer science, data analytics, or a related field, or equivalent experience

Skills

  • Familiarity with 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
  • Knowledge of indexes, index management, and database configuration (preferred)

Benefits

Health insurance
Health insurance policies
Dental & vision
Dental and vision policies
Retirement plan
Eligible to participate in a 401(k) retirement plan with a company percentage match
Paid time off
Paid Time Off (PTO)
Life & disability insurance
Company-paid long- and short-term disability
Other
Competitive salary

Full job description

From Vision Government Solutions Inc’s careers site

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.
Show full descriptionShow less
  • 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). (a plus, not required. We’ll train you on our stack.)
  • 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

Something wrong with this job? Report it · This flag looks wrong