Job description

ETL Developer- On Site

Responsibilities

Candidate will be responsible for data preparation jobs, data analysis, and data reporting.

You will regularly work with 3rd parties and government agencies to exchange data, which will require a familiarity with secure file exchanges, data encryption, change control, auditing best practices, as well as data matching logic.

We are looking for someone with a background in creating automation scripts and queries in an SQL environment.

Because this position regularly works with databases owned by government agencies outside of ELECT, you will need to be comfortable with technical troubleshooting, creating technical documentation, and using your ETL expertise to explain issues to stake holders with different levels of technical expertise across the Commonwealth of Virginia.

Required Skills

High level proficiency with working with large, complex data sets, relational databases, and data warehouses.

High level proficiency with creating, maintaining, and auditing ETL processes in relation with SQL server technologies

High level proficiency with SQL Server Integration services (SSIS)

High level proficiency with T-SQL and writing complex SQL queries

High level proficiency with business intelligence products

High level proficiency with scheduling and automation of ETL processes and file processing

Highly desired skills:

High level Proficiency in writing reports for high profile groups

Proficient in writing technical documentation

Proficient in SQL Server 2008,2012,2014,2016

Proficient with source control, change control, and software development life cycle (SDLC)

Proficient working with secure file exchange protocols like SFTP

Proficient in admin scripting to automate processes

Proficient working with data encryption methods

Desired Skills

Experience working with 3rd parties or government agencies to exchange data

Understanding of data matching logic or fuzzy lookups

Election Data Experience

Job Types: Full-time, Contract

Pay: $55.00 - $60.00 per hour

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Richmond, VA: Reliably commute or planning to relocate before starting work (Required)

Willingness to travel:

• 25% (Required)

Work Location: Hybrid remote in Richmond, VA

gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.