SENIOR BusiNESS INTELLIGENCE SYSTEMS DEVELOPER 0779

DISTINGUISHING FEATURES OF THE CLASS

As part of a centralized unit, an employee in this class evaluates and recommends business intelligence and data warehouse technology solutions and performs highly complex technical work in the design, development, implementation, enhancement and maintenance of countywide business intelligence and data warehouse solutions and systems in support for the County Executive’s Performance Management Program. A position at the senior level is distinguished from a Business Intelligence Systems Developer in that the employee will handle more complex programming, evaluate and analyze proposals for new systems and software and act with greater independence in the development of systems and technical strategies 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

Evaluates operational needs and makes recommendations for enhanced or additional applications of business intelligence technologies and solutions;

Refines the overall business intelligence environment to assure optimal system performance and maximize results in attaining programmatic and operational goals;

May provide technical guidance to lower level developers;

Develops highly complex business intelligence and data warehouse technology solutions including relational and multidimensional data structures in support of the County Executive’s Performance Management Program;

Uses application servers, logic analyzers and development environment software;

Works with operating departments to understand operational systems and data and to identify enhanced opportunities;

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 develops Key Performance Indicators (KPIs) and performance scorecards;

Performs historical data mining to provide insights to support improved decision making in various operations within the County.

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 moderately 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.

MINIMUM QUALIFICATIONS

OPEN-COMPETITIVE

a) Graduation from a college with federally-authorized accreditation or registration by NY State with a Bachelor's Degree in computer science, information systems, engineering, business or public administration or a related field, and three (3) years of experience utilizing Business Intelligence and/or data warehouse technology to manipulate data and to design and create databases and associated reports; or,

b) Graduation from a college with federally-authorized accreditation or registration by NY State with an Associate’s Degree in computer science, information systems, engineering, business or public administration or a related field, and five (5) years of experience utilizing Business Intelligence and/or data warehouse technology to manipulate data and to design and create databases and associated reports; or,

c) An equivalent combination of education and experience as defined by the limits of a) and b).

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.

PROMOTIONAL

Two (2) years of permanent competitive status as a Business Intelligence Systems Developer.

R 08/06/2019

SUFFOLK COUNTY

Competitive