Review Vacancy
AgencyFinancial Services, Department of
TitleBusiness Intelligence Developer
Occupational CategoryI.T. Engineering, Sciences
Bargaining UnitM/C - Management / Confidential (Unrepresented)
Salary RangeFrom $0 to $0 Annually
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.
Some positions may require additional credentials or a background check to verify your identity.
Email Address nce.notifications@dfs.ny.gov
Address
Notes on ApplyingTo 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: 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.