BusiNESS INTELLIGENCE SYSTEMS DEVELOPER 0778
DISTINGUISHING FEATURES OF THE CLASS
An employee in this class will be part of a centralized unit performing technical work in the design, development, implementation, enhancement and maintenance of countywide business intelligence and data warehouse solutions and systems. The employee will assist in the development of systems and technical strategies in support for the County Executive’s Performance Management Program and in the interpretation of data to enable the identification of new or improved operational opportunities and enhanced decision-making capabilities. Work is performed under the general supervision of a technical supervisor and is reviewed through discussions, observation and review of completed work. Does related work as required.
TYPICAL WORK ACTIVITIES
Assists in the development, analysis and application of business intelligence and data warehouse technology solutions in support of the County Executive’s Performance Management Program;
Works with operating departments to understand operational systems and data to enable the extraction of data from various sources to be uploaded to data warehouses and made accessible through portals and dashboards;
Uses various database scripting and software programming languages to support the development of Extraction, Transformation and Load (ETL) Routines;
Prepares charts, tables and diagrams and assists in the development of Key Performance Indicators (KPIs) and performance scorecards;
Creates and incorporates performance scorecards into dashboards and portals to allow for tracking and monitoring of staff activities;
Designs and maintains relational and multidimensional data structures including data warehouses and data marts to optimize data collection, distribution, accessibility and analysis;
Uploads data to warehouses from various operational sources and creates dashboards and portals providing users with easy data access and monitoring;
Integrates data sources with Open Data Portal to provide the public with easy access to open data as defined by the County’s open data policy.
Assists users in the use of dashboards and portals;
Performs historical data mining to provide insights to support improved decision making in various operations within the County;
Assists in writing user manuals as well as procedural manuals for other developers regarding technical architecture, system development and implementation.
FULL PERFORMANCE KNOWLEDGES, SKILLS, ABILITIES AND PERSONAL CHARACTERISTICS
Thorough knowledge of business intelligence and data warehousing principals and methods including online analytical processing (OLAP) and multidimensional analysis; thorough knowledge of data modeling, data mining and data analysis; ability to understand fact and dimension tables using both the star and snowflake techniques; thorough knowledge of data processing and business intelligence hardware and software including capabilities and application; ability to configure and/or develop complex business intelligence computer programs and databases; ability to analyze and solve problems; ability to follow detailed written and oral instructions; ability to establish effective working relationships with others; ability to compile and prepare comprehensive reports and diagrams; ability to express oneself clearly and concisely, both orally and in writing; physical condition commensurate with the demands of the position.
Graduation with a Bachelor's Degree in computer science, information systems, engineering, business or public administration or a related field from a college with federally-authorized accreditation or registration by NY State, plus two (2) years of experience utilizing Business Intelligence and/or data warehouse technology to manipulate data and to design and create databases and associated reports.
NOTE: Experience must be with products specifically recognized as Business Intelligence tools. Business Intelligence technologies include, Microsoft PerformancePoint, PowerBI, SQL Server Analysis Services (SSAS), IBM Cognos, SAS Analytics, QlikView, SAP BusinessObjects, Tibco, MicroStrategy, Information Builders WebFOCUS, Sisense Business Intelligence and Analytics software and Oracle Enterprise Business Intelligence. Data warehouse technologies include Microsoft, Oracle, SAP, IBM, Teradata and EMC. Experience in data warehouse technology must include designing and implementing fact and dimension tables using the star and snowflake techniques, as well as the implementation of extraction, transformation and load (ETL) routines to cleanse data and promote data quality for inclusion into a data warehouse. Experience in using the standard, non-data warehousing functionality of a traditional relational database management software (RDBMS) such as Microsoft SQL Server or Oracle does not qualify as experience with data warehouse technologies.
SPECIAL NOTE: Because of the rapid evolution of technology in this field, qualifying experience must have been gained within the last five (5) years.
Three (3) years of permanent competitive status as a Business Intelligence Applications Analyst.