Job Details

ID #21393521
State Washington
City Tumwater
Job type Permanent
Salary USD Depends on Experience Depends on Experience
Source VIVA USA INC
Showed 2021-10-20
Date 2021-10-14
Deadline 2021-12-12
Category Et cetera
Create resume

Senior Level Data Warehouse Analyst

Washington, Tumwater, 98501 Tumwater USA

Vacancy expired!

Title: Senior Level Data Warehouse Analyst Mandatory skills: Grants Management Data Mart,Data Warehouse,Information Technology Division, ITD, Microsoft,Business Intelligence, Power BI,requirements gathering, technical documentation, source system, report development,Public Transportation Division, data validation,extract, load, and transform, ETL, Transact SQL, SQL Server Integration Services,Azure data lake, Azure Data Factory, Azure SQL database, Azure DevOps Description:

The Contractor shall then develop and perform the technical tasks required implement, maintain, enhance performance, and troubleshoot extract, load, and transform (ELT) processes that move data from the vendor-hosted Grants Management source system, and other sources, to an Azure data lake and Azure data mart, following the architecture and structure being developed between ITD and Microsoft.Finally, the Contractor shall develop, using Power BI, key reports identified in the requirements gathering sessions and provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse. All artifacts shall be developed using a modern cloud-first approach using Microsoft Azure technologies.

Minimum 5 years of experience in leading requirements gathering sessions and developing requirements and technical documents based on those requirementsMinimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes.Minimum 5 years of experience with data integration using ETL or ELT tool(s).Minimum 2 years of experience report development using Power BI.Minimum 2 years of experience creating and maintain data integration processes using Azure Data FactoryMinimum 2 years of experience developing with Azure SQL database.Minimum 2 years of experience employing Kimball data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.Minimum 2 years of experience using Azure DevOps for source control, task management, and deployments.Experience using Informatica Power CenterUnderstanding of database modeling and design principles and ability to use a data model diagram.Experience with SQL Server Integration Services for data integration.Experience with continuous integration and/or continuous deployment

VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions. Contact Details:Please send your resumes and one of our recruiter will get in touch with you. VIVA USA INC.3601 Algonquin Road, Suite 425Rolling Meadows, IL 60008http://www.viva-it.com

Vacancy expired!

Subscribe Report job