PRINCIPAL BusiNESS INTELLIGENCE SYSTEMS DEVELOPER 0780

DISTINGUISHING FEATURES OF THE CLASS

An employee in this class acts as a technical supervisor for developers in a centralized unit who perform technical work in the design, development, implementation, enhancement and maintenance of countywide business intelligence and data warehouse solutions and systems. The employee supervises the development of systems, develops technical strategies in support for the County Executive’s Performance Management Program, and identifies new or improved operational opportunities and enhanced decision-making capabilities. Work is performed under the general supervision of an administrative supervisor and is reviewed through discussions, observation and review of completed work. Does related work as required.

TYPICAL WORK ACTIVITIES

Identifies training programs and materials available for technical staff;

Trains and provides technical supervision to developers in business intelligence and data analytics methods and procedures;

Assigns and manages technical aspects of specific business intelligence projects and tasks;

Supervises the design and maintenance of relational and multidimensional data structures;

Employs complex statistical techniques to analyze current and historical data to enable predictive analysis and improved decision making;

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

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;

FULL PERFORMANCE KNOWLEDGES, SKILLS, ABILITIES AND PERSONAL CHARACTERISTICS

Comprehensive knowledge of business intelligence and data warehousing principals and methods including online analytical processing (OLAP) and multidimensional analysis; comprehensive knowledge of data modeling, data mining and data analysis; ability to understand fact and dimension tables using both the star and snowflake techniques; comprehensive 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; ability to supervise a staff in a manner conducive to full performance and high morale; 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 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,

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 seven (7) 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 eight (8) years.

PROMOTIONAL

Two (2) years of permanent competitive status as a Senior Business Intelligence Systems Developer; or,

Four (4) years of permanent competitive status as a Business Intelligence Systems Developer.

R 08/06/2019

SUFFOLK COUNTY

Competitive