New York State Civil Service Business Intelligence Developer in New York, New York

Minimum Qualifications

Appointment method:

This is an appointment to a position in the exempt jurisdictional class. As such, the incumbent of this position would serve at the pleasure of the appointing authority. ## Duties Description Under the provisions of the Paid Family Leave (PFL) program, the Department of Financial Services (DFS) has been charged with implementing a data warehouse that will not only be used by DFS, but also the Workers Compensation Board, the Department of Health and other agencies. DFS is seeking applicants for the position of Business Intelligence Development Manager to assist in leading agency efforts to establish a data store for the PFL program. This includes playing an important and sensitive role in decision-making and policy-making activities.

The incumbent will assist in overseeing the PFL data warehouse team efforts, ranging from directing technical strategies and tasks to formulating policies and procedures. The incumbent will also serve as a liaison in representing DFS to agency staff, governmental officials and industry representatives.

Under supervision, the Business Intelligence Development Manager duties will include, but not be limited to, the following:

  • Extensive experience in Oracle database and Microsoft SQL, including SSRS, SSIS, DTS;

  • Strong DAX /MDX skills to query the data models;

  • Experience in Microsoft MS-SQL analysis services, including the use of the tabular/multi dimension models to create complex cubes;

  • Become knowledgeable about industries’ main systems and business processes, as well as our complete BI data structure;

  • Leverage expertise in Microsoft BI Stack (SSMS, SSIS, SSAS, SSRS) and work on design, development, and implementation of data warehousing, reporting and analytics solutions;

  • Develop policies and deliver strategy for transitioning current solutions into well integrated SSAS cubes;

  • Suggest new ideas for data visualization (SSRS/Power BI) and work with BI team to deliver on new ideas;

  • Solid experience with relational databases and multidimensional modeling;

  • Should be well familiar with data warehousing concepts (dimensional analysis, building Star schema data warehouse, building multi-dimensional cubes);

  • Should be knowledgeable about statistical concepts and can analyze large data set for correlations and patterns;

  • Expert level experience with Power BI (in a hybrid environment including the use of the MS Gateway) and writing complex formulas with DAX;

  • Creating KPI's and translating business requirements into dashboards and reports; and

  • Mapping Strategic Objectives to metrics.

Skills Requirements

  • Advanced relational data modeling and database design (SQL Server, MS Access);

  • Multidimensional modeling and experience building and fine tuning OLAP cubes (SSAS);

  • Data transformation and ETL (SSIS);

  • Advanced experience with Microsoft Excel (Pivot, PowerPivot and VBA);

  • Experience designing dashboards with reporting tools such as Power BI; and

  • Other appropriate and occupationally related duties as assigned. ## Additional Comments Salary: Salary commensurate with experience.

Please note that positions located within the New York City metropolitan area, as well as Suffolk, Nassau, Rockland, and Westchester Counties, are also eligible to receive an additional $3,026 annual downstate adjustment. ## Notes on Applying To Apply: Interested qualified candidates must submit a resume and letter of interest no later than March 31, 2018, to the email address listed below. Please include (Box BID-00153) in the subject line of your email to ensure receipt of your application. Email submissions are preferred.

Denise Rotunda Box BID-00153 New York State Department of Financial Services Office of Human Resources Management 99 Washington Avenue, Suite 2016 Albany, New York 12257 Email: Fax: (518) 402-5071

Please note that not all applicants may be scheduled for an interview.

AMERICANS WITH DISABILITIES ACT: REASONABLE ACCOMMODATIONS Under the Americans with Disabilities Act (ADA), the Department of Financial Services is required to provide reasonable accommodation for known physical or mental limitations of an otherwise qualified applicant with a disability if an accommodation would enable the applicant to perform the essential functions of the job and the accommodation would not constitute an undue hardship on the operations of the agency.

Date Posted: 03/14/18

Applications Due: 03/31/18

Vacancy ID: 49588

Agency: Financial Services, Department of

Title: Business Intelligence Developer

Occupational Category: I.T. Engineering, Sciences

Salary Grade: NS

Bargaining Unit: M/C - Management / Confidential (Unrepresented)

Salary Range: From $0 to $0 Annually

Employment Type: Full-Time

Appointment Type: Permanent

Jurisdictional Class: Exempt Class

Travel Percentage: 0%

Workweek: Mon-Fri

Hours Per Week: 37.5

From: 9 AM

To: 5 PM

Flextime allowed?: No

Mandatory overtime?: No

Compressed workweek allowed?: No

Telecommuting allowed?: No

County: New York

City: Albany

State: NY

Zip Code: 12257

Name: Denise Rotunda

Telephone: 518-474-6459

Fax: 518-402-5071

Email Address:

Street Address: One State Street

Street: One Commerce Plaza