Please note: State agencies that contact job applicants do not usually request personal or financial information via text message or over the phone in connection with your response to a job posting. If you are contacted for such information by these methods, or any other method, please verify the identity of the individual before transmitting such information to that person.
Note: For questions about the job posting, please contact the agency that posted this position by using the contact information provided on the "Contact" tab for the position.

Review Vacancy

Date Posted 08/14/18

Applications Due09/15/18

Vacancy ID58023

AgencyFinancial Services, Department of

TitleBusiness Intelligence Developer

Occupational CategoryI.T. Engineering, Sciences

Salary GradeNS

Bargaining UnitM/C - Management / Confidential (Unrepresented)

Salary RangeFrom $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

Workday

From 9 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No

County New York

Street Address One State Street

City New York

StateNY

Zip Code10004

Minimum Qualifications 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 Developer 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 participate in component and data architecture design, technology planning, and will be responsible for designing, developing, and maintaining dashboards and reports. The incumbent will also serve as a liaison in representing DFS to agency staff, governmental officials and industry representatives.
Under supervision, the Business Intelligence Developer duties will include, but not be limited to, the following:
• Design and develop comprehensive dashboards supporting business requirements;
• Leverage expertise in Microsoft BI Stack (SSMS, SSIS, SSAS, SSRS) and work on design, development, and implementation of data warehousing, reporting and analytics solutions;
• Suggest new ideas for data visualization (SSRS/Power BI) and work with BI team to deliver on new ideas;
• Analyze large data set for correlations and patterns using statistical concept;
• 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;
• Mapping Strategic Objectives to metrics;
• Develop policies and deliver strategy for transitioning current solutions into well integrated SSAS cubes;
• Become knowledgeable about industries’ main systems and business processes, as well as our complete BI data structure; and
• Other appropriate and occupationally related duties as assigned.

Duties Description Skills Requirements
• Experience in Oracle 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;
• 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);
• 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); and
• Experience designing dashboards with reporting tools such as Power BI.
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.

Additional Comments Position may also be filled in Albany, New York.
Please note that a change in negotiating unit may affect your salary, insurance and other benefits.
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.
Appointment Status: This is an appointment to a position in the exempt jurisdictional class.
Appointment to this position is pending Division of Budget approval to fill.

Some positions may require additional credentials or a background check to verify your identity.

Name Denise Rotunda

Telephone 518-474-6459

Fax 518-402-5071

Email Address nce.notifications@dfs.ny.gov

Address

Street 99 Washington Avenue, Suite 301

City Albany

State NY

Zip Code 12257

 

Notes on ApplyingTo Apply: Interested qualified candidates must submit a resume and letter of interest no later than September 15, 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 301 Albany, New York 12257 Email: nce.notifications@dfs.ny.gov 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.

Printable Version