BusiNESS INTELLIGENCE APPLICATIONS
ANALYST 0777
DISTINGUISHING FEATURES OF THE CLASS
An employee in this class will be part of a centralized unit providing support
for the County Executive’s Performance Management 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
operating departments. 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 with all levels of
operating departments. 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
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,
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.
R 07/06/2017
SUFFOLK COUNTY
Competitive