BusiNESS INTELLIGENCE APPLICATIONS ANALYST 0777

DISTINGUISHING FEATURES OF THE CLASS

An employee in this class will either be part of a centralized unit or work in a County Department to support the County’s Continuous Innovation Program by planning, designing and providing innovative representations of data in a graphical and user-friendly manner, working closely with Business Intelligence Systems Developers and higher level administrators. The employee will define technical requirements for reports, data extracts, etc., and perform complex data queries using Business Intelligence tools to support enhanced decision-making capabilities. The employee will work collaboratively with BI developers and higher level administrators. Work is performed under the general supervision of a higher level administrator and/or a technical supervisor and is reviewed through discussions, observation, and review of completed work. Does related work as required.

TYPICAL WORK ACTIVITIES

Serves as a resource person for the use of Business Intelligence (BI) applications including dashboards and portals and for solving user problems;

Gathers information, defines technical requirements, designs, produces and revises planned or ad hoc reports, data extracts, and visual presentations from BI systems and databases;

Designs and develops solutions to maximize the utilization of features and functionality of Business Intelligence software;

Works with developers and provides input into the ongoing design, development, and deployment of business intelligence and analytical solutions to improve departmental operations;

May identify data formats and best methods for conversion;

Reviews technical design documentation and performs quality assurance testing of BI solutions to ensure the accurate development of reporting solutions;

Assists in analyzing and documenting data management processes to achieve process efficiency;

Trains and assists personnel in the use of Business Intelligence solutions;

Maintains procedural manuals for the BI solutions in use;

May work with third party BI vendors (e.g. Cognos, Qlik, Tableau, SharePoint, etc.)

May manage timely flow of business intelligence information to users.

FULL PERFORMANCE KNOWLEDGES, SKILLS, ABILITIES AND PERSONAL CHARACTERISTICS

Good knowledge of business intelligence and data warehousing principals; good knowledge of data processing and Business Intelligence hardware and software including capabilities and application; good knowledge of data modeling, data mining and data analysis; ability to understand fact and dimension tables using both the star and snowflake techniques; ability to understand and gather complex reporting requirements and develop creative graphical data representations; 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 with a Bachelor's Degree in computer science, information systems or a related field from a college with federally-authorized accreditation or registration by NY State, plus one (1) year of reports design and development experience utilizing Business Intelligence and/or data warehouse technology; or,

(B) Graduation with an Associate's Degree in computer science, information systems or a related field from a college with federally-authorized accreditation or registration by NY State, plus three (3) years of reports design and development experience utilizing Business Intelligence and/or data warehouse technology; 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, Tableau, 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.

NECESSARY SPECIAL REQUIREMENT

Certification as a Salesforce Associate and Tableau Desktop Specialist within 1 year of appointment.

R 10/23/2023

SUFFOLK COUNTY

Competitive