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