Data Warehouse Specialist jobs in Lacey, 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)
Recently Added Data Warehouse Specialist jobs
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.
- 1 Month Ago
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...
- 14 Days Ago
Warehouse Slotting Specialist
- Harbor Wholesale Foods
-
Lacey, WA
FULL_TIME
- Slotting Specialist Pay: $23.00 - $26.00/hr. Full time plus $2000 sign on bonus with full benefits Hours: Monday - Friday, 6:00AM until completion General Summary:The slotting specialist primary purpo...
- 1 Month Ago
GIS and Data Systems Specialist (TPS4)
- State of Washington
-
Seattle, WA
FULL_TIME
- About WSDOTWashington State Department of Transportation (WSDOT) is the steward of an integrated, multimodal transportation system that helps to ensure people and goods move safely and efficiently thr...
- 2 Days Ago
DSHS FFA IT DATA MANAGEMENT - SENIOR/SPECIALIST
- State of Washington
-
Thurston, WA
FULL_TIME
- The IT Data Management Senior/Specialist reports to a Senior Research Scientist leading a Research and Evaluation Center in the Research and Data Analysis Division (RDA) of the Facilities, Finance, an...
- 6 Days Ago
Natural and Working Lands Greenhouse Gas Data Specialist (Environmental Specialist 4)
- State of Washington Dept. of Ecology
-
Lacey, WA
FULL_TIME
- Description Keeping Washington Clean and Evergreen The Climate Pollution Reduction Program (CPRP) is looking to fill the Natural and Working Lands Greenhouse Gas Data Specialist (Environmental Special...
- Just Posted
Filters
- Filter Jobs By posted time
- Within 1 Day
- Within 2-7
- Within 1 Month
- Within 3 Months
0 Data Warehouse Specialist jobs found in Lacey, WA area
Sales VP’s, National Account Manager, and / or Regional Sales Managers
- GHA Technologies, Inc
-
Lacey, WA
- Financial Highlights – Enjoy an Immediate Pay Raise! $2,500 First Week Training Pay for the first five training days. $5...
- 4/26/2024 12:00:00 AM
Human Resources Manager
- Accurate Personnel LLC
-
Lacey, WA
- JOB DESCRIPTION AND RESPONSIBILITIES Job Title: Human Resources Manager Reports to: Human Resources Manager (Administrat...
- 4/26/2024 12:00:00 AM
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...
- 4/26/2024 12:00:00 AM
Water Restoration Technician
- ServiceMaster of Tacoma
-
Olympia, WA
- Job Description Job Description ServiceMaster of Tacoma is seeking bright, motivated, hardworking individuals to join ou...
- 4/24/2024 12:00:00 AM
Sales VP’s, National Account Manager, and / or Regional Sales Managers
- GHA Technologies, Inc
-
Tacoma, WA
- Financial Highlights – Enjoy an Immediate Pay Raise! $2,500 First Week Training Pay for the first five training days. $5...
- 4/24/2024 12:00:00 AM
Water Restoration Technician
- ServiceMaster of Tacoma
-
Tacoma, WA
- Job Description Job Description ServiceMaster of Tacoma is seeking bright, motivated, hardworking individuals to join ou...
- 4/24/2024 12:00:00 AM
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...
- 4/22/2024 12:00:00 AM
(Remote) Data Entry Research Panelist Work From Home
- Maxion Research
-
Olympia, WA
- We appreciate you checking us out! Work At Home Data Entry Research Panelist Jobs - Part Time, Full Time This work-from-...
- 4/22/2024 12:00:00 AM
About Lacey, Washington
Lacey is a city in Thurston County, Washington, United States. Established as a suburb of Olympia, its population was 42,393 at the 2010 census out of a county population of 252,264.
According to the United States Census Bureau, the city has a total area of 16.51 square miles (42.76 km2), of which, 16.06 square miles (41.60 km2) is land and 0.45 square miles (1.17 km2) is water....
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Data Warehouse Specialist jobs
$118,914 to $146,605
Lacey, Washington area prices
were up 2.9% from a year ago
were up 2.9% from a year ago
What does a Data Warehouse Specialist do?
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