Suffolk County

Senior Business Intelligence Developer

Company: Suffolk County

Location: Hauppauge - New York - USA

Posted on: September 22

As part of a centralized unit - an employee in this class evaluates and recommends business intelligence and data warehouse technology solutions and performs highly complex technical work in the design - development - implementation - enhancement and maintenance of countywide business intelligence and data warehouse solutions and systems in support for the County Executive s Performance Management... Program. A position at the senior level is distinguished from a Business Intelligence Systems Developer in that the employee will handle more complex programming - evaluate and analyze proposals for new systems and software and act with greater independence in the development of systems and technical strategies 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.ESSENTIAL SKILLS:Evaluates operational needs and makes recommendations for enhanced or additional applications of business intelligence technologies and solutions;Refines the overall business intelligence environment to assure optimal system performance and maximize results in attaining programmatic and operational goals;May provide technical guidance to lower level developers;Develops highly complex business intelligence and data warehouse technology solutions including relational and multidimensional data structures in support of the County Executive's Performance Management Program;Uses application servers - logic analyzers and development environment software;Works with operating departments to understand operational systems and data and to identify enhanced opportunities;Uses various database scripting and software programming languages to support the development of Extraction - Transformation and Load (ETL) Routines;Prepares charts - tables and diagrams and develops Key Performance Indicators (KPIs) and performance scorecards;Performs historical data mining to provide insights to support improved decision making in various operations within the County.ADDITIONAL POSITION DETAILS:Support Suffolk County's Continuous Improvement Program. This position is in the Department of Information Technology and is located at various facilities in Suffolk County NY. Responsibilities/Duties may include but are not limited to:Assists in the development - analysis and application of business intelligence and data warehouse technology solutions in support of the County's Continuous Improvement Program.Designs and maintains relational database and multidimensional data structures to optimize data collection.Works with executives and business leaders to identify opportunities for improvementCreates and incorporates performance scorecards into dashboardsCreates reports - establishes KPIs and uses graphs - infographics and other methods to visualize dataPerforms historical data mining to provide insights to support improved decision making in various operations within the CountyWorks with continuous improvement analysts to analyze processes and recommend improvementsExperiences with Tableau is a plusExperiences with UKG data and reporting a plusSalary range from $64K-$106KThis position does not offer relocation assistance at this timeSponsorship is not available for this roleMINIMUM REQUIREMENTS:OPEN-COMPETITIVEa) 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 three (3) 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 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 - c) An equivalent combination of education and experience as defined by the limits of a) and b).NOTE : For Business Intelligence Titles: 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.This role is a Provisional AppointmentA provisional appointment - which occurs only in the competitive class - is a temporary appointment to a position for which no eligible list exists or for which an eligible list exists with fewer than three candidates who are willing to accept the position. In order to become permanent - the employee who is provisionally appointed must take the next examination for the position in question. The appointment to the position is then made from among the three highest scoring passing candidates who indicate their willingness to accept the position. Civil Service law does not compel the appointing authority to choose the provisional employee should he or she be one of the three candidates.Additional details regarding a Provisional Appointment can be reviewed at:Suffolk County's Commitment to Diversity - Inclusion & Equity:Our focus is to promote - support - and implement the County-wide diversity and inclusion strategic plan.We achieve results in all our responsibilities through the use of diversity and inclusion best practices.We maintain a familiarity with Diversity & Inclusion trends and best practices.Suffolk County is an Equal Employment Opportunity Employer and does not discriminate against applicants or employees on the basis of race - color - religion - creed - national origin - ancestry - disability that can be reasonably accommodated without undue hardship - sex - sexual orientation - gender identity - age - citizenship - marital or veteran status - or any other legally protected status