Job Description:
- High-level proficiency in working with large, complex data sets, relational databases, and data warehouses.
- High-level proficiency in creating, maintaining, and auditing ETL processes in relation to 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.
- 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 in working with secure file exchange protocols like SFTP.
- Proficient in admin scripting to automate processes.
- Proficient in working with data encryption methods.
- Experience working with 3rd parties or government agencies to exchange data.
- Understanding of data matching logic or fuzzy lookups.
- Election Data Experience.
Skills:
- Experience performing data warehouse architecture development and management.
- Exceptional experience developing codes, testing for quality assurance, and monitoring databases.
- Gathering of business requirements and creating architectural designs.
- Strong experience with technologies such as SQL Server, SSIS, and stored procedures.
Business Intelligence (BI) SQL Server Integration Services (SSIS) SDLC SFTP SQL data-warehouse ETL T-SQL Microsoft SQL Server