Senior Data Warehouse Analyst — ETL & SQL Expert

Infojini Inc; Olympia (WA); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading IT consulting firm is seeking a Senior Data Warehouse Analyst for a project with the Washington Department of Transportation. The successful candidate will develop and implement ETL processes, troubleshoot issues, and provide support in writing complex data-mart queries. This position requires at least 5 years of experience in ETL processes, proficiency in SQL Server and data warehouse principles, with an ability to work in a large organizational environment.

Qualifications

• Minimum 5 years of experience in creating and maintaining ETL processes.
• Experience in writing complex queries using Transact SQL.
• Experience with SQL Server database administration.
• Experience working with large organizations (over 1000 employees).
• Understanding of data warehouse principles.

Responsibilities

• Develop and implement ETL processes to support WSDOT’s data warehouse.
• Troubleshoot extraction, transformation and load (ETL) routines.
• Provide technical assistance to staff in writing data-mart queries.

Skills

ETL processes using SQL Server Integration Services (SSIS)

Writing complex queries using Transact SQL

Using Microsoft SQL Server

Data warehouse principles and theories

Working with large organizations

Tools

Microsoft SQL Server

Informatica Power Center

Job description

A leading IT consulting firm is seeking a Senior Data Warehouse Analyst for a project with the Washington Department of Transportation. The successful candidate will develop and implement ETL processes, troubleshoot issues, and provide support in writing complex data-mart queries. This position requires at least 5 years of experience in ETL processes, proficiency in SQL Server and data warehouse principles, with an ability to work in a large organizational environment.