BUSINESS INTELLIGENCE SPECIALIST

APPLICANTS MUST BE PERMANENT IN THE COMPUTER SPECIALIST (SOFTWARE) CIVIL SERVICE TITLE OR IN A COMPARABLE TITLE ELIGIBLE FOR 6.1.9.

The Office of Accountability Strategies (OAS) is responsible for providing strategic operational, analytical, and systems support services to the DSS-AO (Department of Social Services Accountability Office), across the DSS, and to sister agencies outside of DSS, ensuring data driven efficiencies are effectively implemented.

Within OAS, Data Analytics, Reporting and Triage (OAS-DART) is responsible for supporting the integrity of social service programs.

DART is responsible for developing technological and analytical advancements that represent an intelligence-led, data-driven Agency.

DART maintains the data analysis, reporting and performance measurement systems of DSS-AO, utilizing advanced analytics to identify new investigative initiatives, refer cases with the highest probabilities of fraud, and ensure data quality and reporting.

The OAS-DART is recruiting for one Computer Specialist Software Level I to function as a Business Intelligence Specialist, who will :

Utilize modern commercial database management tool such as SQL Server Management Studio to manipulate Microsoft SQL Server data, write queries, stored procedures and SSIS packages to produce report results.

Use Structure Query Language (SQL) and stored procedures to generate relevant report data. Use SQL Server Integration Service (SSIS) to transform and manipulate report data.

The data would be pulled from Money Management System (MMS), Investigative Reporting Information System (IRIS) and Division of Account Receivable and Billing (DARB).

Utilize modern commercial database management tool such as SQL Developer and TOAD to manipulate Oracle data and write queries to results.

Use Structure Query Language (SQL) to generate relevant data. The Oracle queries would be executed in Enterprise Data Warehouse (EDW), Medicaid Data Warehouse (MDW) and Automated List of Eligibility Requirement Racking System (ALERTS).

Adhere to the existing reporting requirements, migrate existing EXCEL reports into SQL Server Reporting Service (SSRS) and SharePoint.

Develop new reports and dashboards according to requirements and specifications of the IREA Program areas.

• Develop and maintain Microsoft.Net Application to extract and customize display of information from existing IREA systems, including IRIS, MMS, ALERTS, as well as complex Oracle databases that include EDW and MDW.
• Use ad-hoc queries and debugging tools to investigate data issues in various source systems. Document project specific source access mechanisms, detailed data flow and related information to specific targets.
• Use ad-hoc queries and various database tools to create BFI and Revenue statistical reports and presentations. Support various data analytic needs.

Work Schedule : Monday to Friday-9 am to 5 pm

Work Location : Pearl Street

Minimum Qualifications

A baccalaureate degree from an accredited college, including or supplemented by twenty-four semester credits in computer science or a related computer field and two years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or

A four-year high school diploma or its educational equivalent and six years of full-time satisfactory software experience as described in 1" above, including one year in a project leader capacity or as a major contributor on a complex project; or

A satisfactory combination of education and experience that is equivalent to or above. College education may be substituted for up to two years of the required experience in above on the basis that sixty semester credits from an accredited college is equated to one year of experience.

A masters degree in computer science or a related computer field may be substituted for one year of the required experience in or above.

However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.

NOTE : In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor.

Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification

requirements.

Special Note

To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and / or on-line applications programming.

Preferred Skills

• Experience with Business Intelligence applications, such as Oracle OBIEE.-Experience with Structured Query Language (SQL) and extracting, manipulating and analyzing data from large databases.
• Experience with SSRS and SSIS. -Experience with various programming languages, such as .Net. -Advanced knowledge of Microsoft Excel, SharePoint and Access.

55a Program

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

Residency Requirement

New York City Residency is not required for this position