Data Analytics Firstny and New Data Warehousing and Analytic Solutions

The vendor required to provide data analytics, firstny, and new data warehousing and analytic solutions for include:
- Lead data warehouse developer
•    Acquiring data from various sources including cloud services and utilizing secure ftp and other transfer protocols; 
•    Maintaining and developing PL and SQL for several data analytics initiatives currently in production;
•    Serving as a database architect to review current data analytics infrastructure and making recommendations on how to structure going forward; 
•    Providing technical support for interfacing between the backend data and the front-end tools such as tableau; 
•    Leveraging existing in-house technology to support extract/transform/load (ETL) such as attunity compose; 
•    Reviewing current architecture and systems with the goal of integrating the data analytics environment with enterprise standards and best practices;
•    Parsing xml files into meaningful datasets that can be consumed by OSC analysts; 
•    Creating documentation for current environment and any changes going forward; 
•    Offering guidance when reviewing user stories as to the best mechanism and platform to use that will meet user needs; and 
•    Creating or assisting with the creation of dashboards and visualizations in tableau or similar data visualization products.
- Data warehouse developer
•    Maintaining and developing SQL and PL and SQL for the Paris application; 
•    Maintaining, converting and developing all bi publisher reports for the Paris application; 
•    Performing database modeling in the context of an online transaction processing (“OLTP”) system; 
•    Performing database modeling in the context of an online analytic processing (“OLAP”) system for the firstny data warehouse; 
•    Tuning SQL for performance; 
•    Developing new ETL processes using an enterprise ETL tool; 
•    Maintaining existing ETL processes using oracle warehouse builder (OWB) and attunity compose; 
•    Converting existing OWB ETL processes to attunity compose; 
•    Maintaining and developing the physical, logical and business layers in the oracle analytics server (OAS) repository database (RPD) in a multi-user development environment (MUDE); and 
•    Maintaining and developing dashboards, reports, visualizations and analyses in OAS.

- Contract Period/Term: 3 years
- Questions/Inquires Deadline: December 9, 2025