BUSINESS INTELLIGENCE SYSTEMS DEVELOPER
CIVIL SERVICE OPPORTUNITIES
<![if !supportLists]>· <![endif]>LAST FILING DATE: JANUARY 16, 2019
<![if !supportLists]>· <![endif]>COUNTY ANNUAL SALARY $54,438
<![if !supportLists]>· <![endif]>GRADE 24
SPECIFICATION # 0778
All statements made on the application may be verified and the backgrounds of successful candidates are subject to investigation by the appointing authority.
APPLICATION PROCESSING FEE and FEE WAIVER
The application processing fee is $40. Application may be made via the internet at www.suffolkcountyny.gov/civilservice. Payment must be made by VISA or MasterCard credit card and there will be an additional convenience fee of $1.95. An acknowledgement of receipt of application will be sent to all internet applicants via e-mail. Application may also be made using the Suffolk County Application for Employment (Forms CS-205A and CS-205B). Make your check or money order payable to the Suffolk County Department of Civil Service. Do not send cash. Please indicate the examination title and the last four digits of your Social Security number on the face of your check or money order. A separate application and processing fee are required for each examination (identified by examination number) for which you are applying. The application processing fee is non-refundable and non-transferable.
The application processing fee may be waived for Suffolk County residents who are veterans, auxiliary police, members in good standing of a local fire district or ambulance company, volunteer CERT members and members of the Suffolk County Police Explorers program. The fee may also be waived if you are unemployed and primarily responsible for the support of a household and for recipients of Medicaid, SSI, Public Assistance or those in a training program under the Job Training Partnership Act/Workforce Investment Act administered by a state or local social service agency. Internet applicants should complete the “Request for Application Fee Waiver and Certification” form online. All other applicants should complete a “Request for Application Fee Waiver and Certification” form and submit it with your application (Forms CS-205A and CS-205B). All claims for application fee waiver are subject to verification.
The eligible list for this title will be used to fill current and future vacancies for this title in Suffolk County Departments. There is currently one vacancy in the Suffolk County Department of Information Technology.
An employee in this class will be part of a centralized unit performing technical work in the design, development, implementation, enhancement and maintenance of countywide business intelligence and data warehouse solutions and systems. The employee will assist in the development of systems and technical strategies in support of the County Executive’s Performance Management Program 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.
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, plus two (2) years of experience utilizing Business Intelligence and/or data warehouse technology to manipulate data and to design and create databases and associated reports.
Notes: 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 Business Objects, 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 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.
*Please attach to the application a copy of your college transcript(s) which must have your name, college name and the date of graduation printed on it by the institution. Grade reports, incomplete transcripts and other similar documents are unacceptable.
SCOPE OF THE EXAMINATION
The only subject of the examination will be an evaluation of the candidates’ training and experience. Candidates who meet the minimum qualifications will receive a rating based on an evaluation of their training and experience against the background of the duties of the position.
All candidates should submit an application on or before the last filing date. After a preliminary review of qualifications, all approved candidates will be required to complete and return a questionnaire describing their relevant training and experience. The rating of training and experience will be based upon the information candidates provide on the questionnaire. Ambiguity and vagueness will not be resolved in the candidate’s favor. Additional information concerning a candidate’s training and experience will not be accepted after the questionnaire has been rated. Candidates who have not received a questionnaire by February 20, 2019 should contact the Department of Civil Service.
<![if !supportLists]>1. <![endif]>Should it become necessary to amend any part of this announcement, the Civil Service Department reserves the right to make such amendment on the Department’s web page without notification to applicants. The most current copy of this announcement is available during the filing period at www.suffolkcountyny.gov/civilservice.
<![if !supportLists]>2. <![endif]>Candidates who filed for this examination more than six months ago are advised to amend their applications to include current information.
DATE PREPARED: December 3, 2018
<![if !supportLists]>1. <![endif]>Candidates must submit Suffolk County Application forms. Applications are available at the Suffolk County Department of Civil Service in Hauppauge and at the Riverhead County Center display, or by sending a stamped, self-addressed 9 ½” X 4”envelope for each title to: Suffolk County Department of Civil Service, P.O. Box 6100, Hauppauge, NY 11788-0099.
<![if !supportLists]>2. <![endif]>Applications postmarked after midnight of the last filing date may not be considered eligible for this examination.
<![if !supportLists]>3. <![endif]>Unless otherwise stated, candidates must meet the minimum qualifications by the date of the written test, or last filing date in the case of training and experience evaluations. Unless otherwise stated part-time experience will be pro-rated.
<![if !supportLists]>4. <![endif]>Candidates found ineligible to compete in the training and experience examination may appeal to the Department of Civil Service for reconsideration prior to the written test date appearing on this announcement. Appeals received on or after the announced last filing date will not be considered.
<![if !supportLists]>5. <![endif]>Candidates who fail the examination, or who fail to appear for the examination as scheduled, will be eliminated from further consideration for purposes of this competition. Unless otherwise specified, the final rank order of the eligible list will be determined on the basis of the scored received on the written test, plus veterans’ credits where appropriate.
<![if !supportLists]>6. <![endif]>If an application is rejected, due notice will be sent.
<![if !supportLists]>7. <![endif]>Unless specifically prohibited by the examination instructions, candidates are permitted to use quiet, hand-held, solar or battery powered calculators. Devices with typewriter keyboards, spell-checker, personal digital assistant, address books, language translators, dictionaries and any similar devices are prohibited.
<![if !supportLists]>8. <![endif]>When the examination is prepared and rated by the Suffolk County Department of Civil Service, the provisions of the Suffolk County Civil Service Rules dealing with the rating of examination will apply.
<![if !supportLists]>9. <![endif]>When the written examination is prepared and rated by the New York State Department of Civil Service in accordance with Section 23-2 of the Civil Service Law, the provisions of the New York State Civil Service Rules and Regulations which deal with the rating of examination will apply.
<![if !supportLists]>10. <![endif]>The eligible list established as a result of this examination will remain in force for at least one year and may be extended by the Civil Service Department for a maximum of four years. Changing conditions may make it necessary to certify to future vacancies at higher or lower salaries than those announced.
<![if !supportLists]>11. <![endif]>Information regarding eligibility for veterans’ credits appears on the open-competitive application form.
<![if !supportLists]>12. <![endif]>Pursuant to Section 85-a of the Civil Service Law, children of firefighters and police officers killed in the line of duty shall be entitled to receive an additional ten points added to a passing score attained in a competitive examination for original appointment in the same municipality in which his or her parent served. If you are qualified to participate in this examination, and you are the child of a firefighter or police officer killed in the line of duty, please so notify us in writing when you submit your application for examination. A candidate claiming such credit must submit appropriate documentation to verify eligibility to receive these additional credits before the eligible list is established. No additional credits will be granted after the eligible list is established.
<![if !supportLists]>13. <![endif]>Inquiries may be made as to character and ability and all statements made by candidates are subject to verification. Some employers may require the candidate to be fingerprinted and to pass a background investigation.
<![if !supportLists]>14. <![endif]>Candidates must be medically, physically and psychologically capable of performing the duties of the job. Candidates who are appointed to positions in the Suffolk County service may be required to pass qualifying medical and/or physical and/or psychological evaluations.
<![if !supportLists]>15. <![endif]>Residency is not required for taking any examinations. However, some non-county jurisdictions, such as schools, libraries, etc., give hiring preference to residents. Some towns also require employees to establish residency within the township. For employment in a Suffolk County Department, with only limited exceptions set forth in Suffolk County Law, residency within Suffolk County is required throughout employment with the county. In any case in which residency preference is given, the appointee(s) must meet a specific residency standard as defined in the Civil Service Rules.
<![if !supportLists]>16. <![endif]>Saturday Sabbath Observers and handicapped persons: If special arrangements for testing are required, indicate this on your application.
<![if !supportLists]>17. <![endif]>No smoking is permitted in the building or on the grounds of the examination site.
<![if !supportLists]>18. <![endif]>If you will be on active military duty with the armed forces of the United States on the date of this test, please contact the Suffolk County Department of Civil Service before the last filing date appearing on this announcement for alternate test date information.
<![if !supportLists]>19. <![endif]>Multiple Examinations Scheduled for the Same Day: If you have applied to take a written test announced by either one or several local jurisdictions (county, town, city) scheduled to be held on the same test date as this written test, you must notify each of the local jurisdictions no later than two weeks before the test date, so they can make arrangements for taking all tests at one test site. All examinations for positions in State government will be held at a State examination center. If you have any questions please call the Suffolk County Department of Civil Service at (631) 853-5500.
<![if !supportLists]>20. <![endif]>For information regarding a weather-related cancellation of this examination, please refer to our website at www.suffolkcountyny.gov/civilservice click on the “Weather-Related Exam Cancellations” link. Civil Service Announcements are shown at the bottom of that page. The following stations will broadcast notice of cancellation:
WALK PATCHOGUE 97.5 FM
WBAB BABYLON 102.3 FM
WBLI BABYLON 106.1 FM
WLNG SAG HARBOR 92.1 FM
WBZO FARMINGDALE 103.1 FM
WRCN MEDFORD 103.9 FM
NEWS 12 LONG ISLAND TV CHANNEL 12 website: www.news12.com
SUFFOLK COUNTY DEPARTMENT OF CIVIL SERVICE
Announcements and Applications Also Available At
SUFFOLK COUNTY DEPARTMENT OF CIVIL SERVICE
725 VETERANS MEMORIAL HWY.
WILLIAM J LINDSAY COUNTY COMPLEX, BLDG. #158 Information Display Unit,
P.O. BOX 6100, HAUPPAUGE, NY 11788-0099 Phone: 853-5500 County Center, Riverhead