Job ID: VA-704281 (98190301)

Hybrid /Local SSIS ETL Developer with T-SQL, BI, SFTP, scripting, encryption, fuzzy lookups, and Election data experience

Location: Richmond VA (ELECT)
Duration: 9 months

Skills:
High level proficiency with working with large, complex data sets, relational databases, and data warehouses Required 5 Years
High level proficiency with creating, maintaining, and auditing ETL processes in relation with SQL server technologies Required 5 Years
High level proficiency with SQL Server Integration services (SSIS) Required 5 Years
High level proficiency with T-SQL and writing complex SQL queries Required 5 Years
High level proficiency with business intelligence products Required 5 Years
High level proficiency with scheduling and automation of ETL processes and file processing Required 5 Years
High level Proficiency in writing reports for high profile groups Highly desired 4 Years
Proficient in writing technical documentation Highly desired 4 Years
Proficient in SQL Server 2008,2012,2014,2016 Highly desired 4 Years
Proficient with source control, change control, and software development life cycle (SDLC) Highly desired 4 Years
Proficient working with secure file exchange protocols like SFTP Highly desired 4 Years
Proficient in admin scripting to automate processes Highly desired 4 Years
Proficient working with data encryption methods Highly desired 4 Years
Experience working with 3rd parties or government agencies to exchange data Desired 2 Years
Understanding of data matching logic or fuzzy lookups Desired 2 Years
Election Data Experience Desired 2 Years

Virginia Department of Elections (ELECT) is seeking a skilled and experienced ETL Developer to join our team. As an ETL Developer, you 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.

VA_ERTR-704281 rtr .docx

VA-704281Skills -.docx

Hybrid /Local SSIS ETL Developer with T-SQL, BI, SFTP, scripting, encryption, fuzzy lookups, and Election data experience

Leave a Reply

Your email address will not be published. Required fields are marked *

Discover more from innoSoul

Subscribe now to keep reading and get access to the full archive.

Continue reading