Job Description :
Client: Direct
Rate: Market
new position 10/29 - rk_ets_in_wa
ETL Developer with SSIS
Bellevue, WA
Long Term
Contract
Position Description:
The ETL Developer will work with data modelers and business analysts to build Extract, Transform and Load jobs (ETL) to populate the company’s data warehouse.
· Design and develop Extraction, Transformation and Loading (ETL) processes using standard ETL tools to streamline and automate the collection of data from source systems, as well as the production and distribution of both ad-hoc and recurring reports.
· Design data products for end users based on specific needs (reports/tables/etc
· Develop repeatable and scalable data quality audits
Required Skills:
· Experience developing ETL packages
· Microsoft SQL Server and BI core skillset (SSIS)
· Able to write advanced SQL queries with multi-table joins, group functions, subqueries, set operations and functions.
· Able to develop ETL jobs and processes
· Able to create User Stories
· Strong documentation skills
· Must be able to work independently and present solutions to problems
Bonus Skills:
Experience with AWS Databases/Tools a plus (Redshift/Aurora/Glue/Athena)