Senior Data Warehouse Analyst
$92K - $116K/yr
Senior Data Warehouse Analyst Duration: Two (2 1/2) months Location:Tumwater/ olympia, WA Client: Washington Department of Transportation Scope of Work The Washington State Department of ...
$92K - $116K/yr
Senior Data Warehouse Analyst Duration: Two (2 1/2) months Location:Tumwater/ olympia, WA Client: Washington Department of Transportation Scope of Work The Washington State Department of ...
$92K - $116K/yr
Senior Data Warehouse Analyst Duration: Two (2 1/2) months Location:Tumwater/ olympia, WA Client: Washington Department of Transportation Scope of Work The Washington State Department of ...
Olympia, WA · On-site +1
$93K - $126K/yr
The DATA (Data Acquisition, Transformation and Analytics) team of the Health Care Authority, within the Strategy, Policy, and Innovation (SPI) division, is responsible for leading agency data ...
Olympia, WA · On-site +1
$93K - $126K/yr
The DATA (Data Acquisition, Transformation and Analytics) team of the Health Care Authority, within the Strategy, Policy, and Innovation (SPI) division, is responsible for leading agency data ...
Olympia, WA · On-site +1
$79K - $111K/yr
This Fiscal Information and Data Analyst role offers a high-impact, non-supervisory position managing a $2.6 billion behavioral health budget. Ideal for analytical professionals, it provides ...
Olympia, WA · On-site +1
$79K - $111K/yr
This Fiscal Information and Data Analyst role offers a high-impact, non-supervisory position managing a $2.6 billion behavioral health budget. Ideal for analytical professionals, it provides ...
Olympia, WA · Hybrid
$79K - $111K/yr
This Fiscal Information and Data Analyst role offers a high-impact, non-supervisory position managing a $2.6 billion behavioral health budget. Ideal for analytical professionals, it provides ...
Olympia, WA · Hybrid
$79K - $111K/yr
This Fiscal Information and Data Analyst role offers a high-impact, non-supervisory position managing a $2.6 billion behavioral health budget. Ideal for analytical professionals, it provides ...
$35.5K - $45.2K
4% of jobs
$45.2K - $54.9K
7% of jobs
$54.9K - $64.6K
13% of jobs
$65.1K is the 25th percentile. Wages below this are outliers.
$64.6K - $74.2K
18% of jobs
The median wage is $78.8K / yr.
$74.2K - $83.9K
16% of jobs
$83.9K - $93.6K
13% of jobs
$97.2K is the 75th percentile. Wages above this are outliers.
$93.6K - $103.3K
9% of jobs
$103.3K - $113K
5% of jobs
$113K - $122.7K
9% of jobs
$122.7K - $132.3K
3% of jobs
$132.3K - $142K
2% of jobs
$35.5K
$86.3K
$142K
| Aspect | Data Analyst | Data Scientist |
|---|---|---|
| Required Credentials | Bachelor's degree in statistics, mathematics, or related field; often certifications in data analysis tools | Bachelor's or master's in computer science, statistics, or related; often advanced certifications or degrees |
| Work Environment | Business settings, focusing on data reporting and visualization | Research and development environments, focusing on predictive modeling and complex algorithms |
| Employer & Industry Usage | Retail, finance, healthcare, and marketing companies | Tech firms, research institutions, and large enterprises |
While both roles analyze data, Data Analysts primarily focus on interpreting existing data to generate reports and insights, whereas Data Scientists develop predictive models and advanced algorithms to forecast trends and solve complex problems.
Data Analysts use a range of methods to chart, examine, and analyze data for their clients. As a Data Analyst, your job is to analyze a company’s data using a combination of mathematical inspection, transformation, and modeling techniques to simplify and condense it. You may also need to present your reports to stakeholders. Because companies often use the results of the data analysis to make business decisions, Data Analysts need to confirm the accuracy of the data.
Infojini 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 package
Title:Senior Data Warehouse Analyst
Duration: Two (2 1/2) months
Location:Tumwater/ olympia, WA
Client: Washington Department of Transportation
Scope of Work
The 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.
Required Skills
Minimum 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 purposes
Minimum 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 Skills
Understanding 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.
All your information will be kept confidential according to EEO guidelines.
Sourced by ZipRecruiter
Infojini Consulting is a full service IT consulting, services, and staffing firm with offices in Linthicum Heights ,Maryland, Washington, DC and Mumbai, India. 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.
Recruiting and staffing services
51 - 200 Employees
Columbia, MD, US
2006