Data Warehouse Specialist jobs in Olympia, WA

Data Warehouse Specialist performs technical administration duties for the development and maintenance of data warehouses. Provides technical support and coordination during warehouse design, testing and movement to production. Being a Data Warehouse Specialist acts as a liaison between engineers, data architects, programmers, and analysts. Implements and enforces standards and procedures to ensure data is managed consistently and properly integrated within the warehouse. Additionally, Data Warehouse Specialist manipulates and combines data from various sources to enlarge and enhance the data warehouse. Requires a bachelor's degree. Typically reports to a manager or head of a unit/department. The Data Warehouse Specialist work is generally independent and collaborative in nature. Contributes to moderately complex aspects of a project. To be a Data Warehouse Specialist typically requires 4 -7 years of related experience. (Copyright 2024 Salary.com)

I
Senior Data Warehouse Analyst
  • Infojini Inc
  • Olympia, WA FULL_TIME
  • Company DescriptionInfojini Consulting is a full service IT consulting, services, and staffing firm with offices in Edison, NJ.Infojini Consulting is recognized as one of the fastest growing IT services and software development Companies. With a partnership of all major technology vendors, Infojini Consulting has built a strong Government and commercial customer base including fortune 100 companies and most state and federal agencies such as State of North Carolina, State of South Carolina, State of Maryland, State of California, State of Pennsylvania, State of Virginia, State of Washington and many others.Infojini Consulting is an equal opportunity employer and considers all qualified individuals for employment irrespective of their race, gender, age, color, sexual orientation. We offer an excellent compensation packageJob DescriptionTitle:Senior Data Warehouse AnalystDuration: Two (2 1/2) monthsLocation:Tumwater/ olympia, WAClient: Washington Department of TransportationScope of WorkThe Washington State Department of Transportation (WSDOT), Office of Information Technology (OIT) requires one (1) senior level Data Warehouse Analyst to develop and implement extract, transform, and load processes needed to support WSDOT’s data warehouse The contractor shall perform the technical tasks required to set up, maintain, enhance performance, and troubleshoot extraction, transformation and load (ETL) routines that move data from transactional databases and flat files to the data warehouse. The contractor shall provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse.The data warehouse operating environment is SQL Server 2012 and 2016 on Windows 10 and our ETL tool is Informatica Power Center 10.1.Specific duties include: Using client requirements and database design specifications, the contactor shall: Determine how the data sources identified can provide the required data.Test data structures to verify that the target databases will work as designed.Set up ETL routines: write the code using Informatica mappings that move data from the specified sources; transform it as required and write it into the data mart. The outcome of this task shall be error-free ETL routines that meet requirements and design specifications, and are regularly scheduled within the Department’s Data Warehouse loading process.Provide technical assistance to staff in writing complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines. The outcome of this task shall be the provision of technical information and ideas to support staff and query-tools experts who are assisting users with advanced, complex data-mart queries.Contractor Roles and Responsibilities:The successful candidate will report to the Manager of WSDOT ITD Data Resource Management. The contractor will organize, schedule and conduct their work in harmony with other data maintenance activities in the ITD office, and is expected to report occasionally to the Data Warehouse Technical Team, the management group. The contractor may be required to work on multiple, concurrent data mart projects. The contractor will coordinate their efforts with WSDOT Data Management Services to ensure that backup schedules and system service hours are accommodated. It is not acceptable to disrupt production database services during business hours without the expressed approval of the Data Warehouse Administrator or the Managers of Data Resource Management and Data Management Services. The consultant will be provided a computer, desk and phone on WSDOT premises. 2.5.1 Specific duties include: The successful candidate will: Participate in project team meetings and work closely with the data warehouse administrator, ETL staff, data modelers, database administrators, support analysts, report writers, and the data warehouse project manager to create ETL routines. Creating ETL routines includes writing the code that creates the transformations and processes that move data from the specified sources, transform it as required and write it into the data mart. Client requirements and database design specifications will be provided by WSDOT staff.Test target data structures to ensure that all works as designed.Verify identified data sources to ensure that the needed data can be properly provided.Write technical documentation of ETL routines to explain how the routines operate to meet requirements and design specifications.Provide technical assistance to write complex data-mart queries, based on the detailed knowledge gained during the construction of ETL routines.Assist in troubleshooting data loading and data warehouse performance issues.QualificationsRequired SkillsMinimum 5 years of experience in creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS) and / or Informatica Power Center.Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposesMinimum 5 years of experience using Microsoft SQL Server 2000, 2005, and 2008 r2 software tools to administer and/or manage SQL Server databases.Minimum 5 years of experience working with large organizations (over 1000 employees).Minimum 5 years of experience employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.Desired SkillsUnderstanding of database modeling and design principles and ability to use a data model diagram.Experience using PowerExchange for Mainframe ADABAS.Tuning and optimizing SQL Server databases.Performing mainframe-to-server automation, bulk copy and FTP download.Programming in .Net. Or COBOL and/or Natural running on an MVS/zOS platform.Additional InformationAll your information will be kept confidential according to EEO guidelines.
  • 14 Days Ago

A
Warehouse Worker - Anytime Pay
  • Amazon Warehouse
  • Olympia, WA FULL_TIME
  • Amazon Fulfillment Center Warehouse Associate Job Overview You’ll be part of the Amazon warehouse team that gets orders ready for customers relying on Amazon services. Our fast-paced, physical roles t...
  • 26 Days Ago

A
Amazon Fulfillment Center Warehouse Associate
  • Amazon Warehouse
  • Lacey, WA FULL_TIME
  • Shift: Thu, Fri, Sat, Sun 07:00pm - 05:30am Duration: Seasonal Start Date: 2023-04-13 Amazon Fulfillment Center Warehouse Associate Job Overview You’ll be part of the Amazon warehouse team that gets o...
  • 24 Days Ago

T
Office Specialist - Medical Office
  • TruGreen - Lawn Specialist
  • Olympia, WA FULL_TIME
  • TruGreen is Now Hiring Lawn Specialists!00 per Hour - Comprehensive Benefits 00 per hour Average income is $850 - $1,200 per week* - Based on hourly rate and average bonuses earned for qualifying spec...
  • 20 Days Ago

T
Lawn Specialist - Earn $13-$22/Hour + Benefits
  • TruGreen - Lawn Specialist
  • Olympia, WA FULL_TIME
  • TruGreen is Now Hiring Lawn Specialists! Earn Up to $22.00 per Hour - Comprehensive BenefitsAt TruGreen, we are committed to our customers, our teams, our values, and the science of lawn care. A caree...
  • 1 Month Ago

F
Data entry specialist
  • FocusGroupPanel
  • Olympia, WA FULL_TIME
  • We appreciate you checking us out! Work At Home Data Entry Research Panelist Jobs - Part Time, Full Time This work-from-home position is ideal for anyone with a diverse professional background, includ...
  • 1 Day Ago

Filters

Clear All

  • Filter Jobs by companies
  • More

0 Data Warehouse Specialist jobs found in Olympia, WA area

A
Human Resources Manager
  • Accurate Personnel LLC
  • Lacey, WA
  • JOB DESCRIPTION AND RESPONSIBILITIES Job Title: Human Resources Manager Reports to: Human Resources Manager (Administrat...
  • 3/28/2024 12:00:00 AM

D
DSW Store Associate Part-Time
  • DSW (Designer Brands Inc.)
  • Olympia, WA
  • General Summary Store Associates provide friendly service to customers shopping in-store and those engaging through omni...
  • 3/28/2024 12:00:00 AM

C
GIS & Asset Management Technician
  • City of Shelton, WA
  • Shelton, WA
  • Salary: $59,998.20 - $78,171.23 Annually Location : Shelton, WA Job Type: Full-time Job Number: 2024-006 Department: Pub...
  • 3/28/2024 12:00:00 AM

G
National Account Manager
  • GHA Technologies, Inc
  • Lacey, WA
  • $50 an hour, $2,500 New Hire Training Bonus for the first five training days! GHA Technologies, Inc. has become the #1 E...
  • 3/27/2024 12:00:00 AM

D
Store Associate Part-Time
  • DSW Inc
  • Olympia, WA
  • You must apply through our internal portal: ** Store Associate Part-Time** DATE: May 20, 2021 CITY: Olympia BRAND: DSW R...
  • 3/27/2024 12:00:00 AM

M
Entry-Level Data Entry Specialist (Remote)
  • Maxion Research
  • Lakewood, WA
  • We appreciate you checking us out! Work At Home Data Entry Research Panelist Jobs - Part Time, Full Time This work-from-...
  • 3/27/2024 12:00:00 AM

C
Crime Analyst
  • City of Tacoma, WA
  • Tacoma, WA
  • Salary : $76,523.20 - $97,635.20 Annually Location : Tacoma, WA Job Type: Classified Job Number: 1101-24 Department: Tac...
  • 3/26/2024 12:00:00 AM

C
ASSA ABLOY Inventory and Operations Planning Specialist
  • Careerbuilder
  • Olympia, WA
  • **ASSA ABLOY Inventory & Operations Planning Specialist** Located in Kent, Washington (hybrid - remote/onsite position),...
  • 3/26/2024 12:00:00 AM

Olympia is the capital of the U.S. state of Washington and the county seat of Thurston County. European settlers claimed the area in 1846, with the Treaty of Medicine Creek initiated in 1854, and the Treaty of Olympia initiated in January 1856. Olympia was incorporated as a town on January 28, 1859, and as a City in 1882. The population was 46,479 as of the 2010 census, making it the 24th largest city in the state. The city borders Lacey to the east and Tumwater to the south. Olympia is a cultural center of the southern Puget Sound region. Olympia is located 60 miles (100 km) southwest of Seat...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Data Warehouse Specialist jobs
$117,558 to $144,934
Olympia, Washington area prices
were up 2.9% from a year ago

Data Warehouse Specialist in Albany, GA
Are you an experienced, highly motivated Data Warehouse Specialist? Do you like to work in a dynamic and dedicated team of IT professionals? Then this might be a role for you.
December 31, 2019
Data Warehouse Specialist in Charleston, WV
The main role of the incumbent is to perform the design, development, implementation, and management of an enterprise data warehouse solution for the Global IP Platform.
January 18, 2020
Data Warehouse Specialist in Lancaster, PA
·          provide continuity in all major data warehousing solution decisions.
January 07, 2020