OLAP Engineer

General Characteristics Supports the user community in the use of business intelligence tools to query files and databases for report outputs. Assists customers in use of OLAP tools, extracts and collects data for performing queries and writing reports. Reviews queries for performance issues, making changes as needed. Participates in the design and development of reports, as well as creation of user documentation. Monitors customer usage, upgrades enterprise-wide OLAP query and reporting tools, monitors batch queries and ensures interoperability and security of various front-end components. Maintains meta data coordination and supports production system. Needed knowledge includes process and data modeling and data architectural development methodologies. Complexity Provides support for user community. Works on one or more projects as a project team member. Functions, relatively independent, under direction of senior professionals, supervisors, or managers. The Contractor shall be responsible for performing data preparation activities, including cleaning and preprocessing, to ensure accuracy, consistency, and reliability across all datasets. The Contractor shall apply appropriate statistical techniques to analyze trends, patterns, and relationships, and shall conduct exploratory data analysis to uncover insights. All analytical results shall be interpreted within the context of Florida Commerce’s objectives to ensure relevance and support informed decision-making. The Contractor shall develop and execute SQL queries to extract and manipulate data as required. Queries shall be optimized for efficiency and performance while maintaining strict data integrity standards. The Contractor shall ensure that all activities support accurate, timely, and actionable analysis aligned with Florida Commerce’s operational and strategic needs. A. Decision Support Administrator - Advanced (Job #3620) Contractor and/or Contractor’s Staff assigned to this Contract shall have the following knowledge, skills, and abilities: 1. Associate’s or Bachelor’s Degree or technical institute degree/certificate in Computer Science, Information Systems, or other related field, or; 1. Equivalent work experience (A minimum of seven (7) years of IT experience, five (5) years of experience in business intelligence tools and systems, and five (5) years of experience with economic and/or statistical analysis). • Works closely with customers and design teams in prioritizing data and information requirements. • Determines how Decision Support Systems (DSS) and Executive Information Systems (EIS) will provide the information required to make effective business decisions; translates requirements into applications that employ appropriate decision support and reporting tools. • Involved in the design, development, and maintenance of DSS. • Performs modeling of data sources and flows, works with data management staff to define an operational framework that will define, develop and implement DSS, EIS, policies, and security frameworks to ensure precise and secure delivery of knowledge and information. • Monitors system performance implements changes to optimize performance. • Involved in the selection of new products. • Needed skills and knowledge includes process and data modeling, DSS architecture and tools, development life cycle methodologies, IT planning methodology, extensive knowledge of the enterprise’s data and decision-making processes.