BUSINESS INTELLIGENCE SPECIALIST Position Available In New York, New York

Job Order Number:

DG0161122

Job Title:

BUSINESS INTELLIGENCE SPECIALIST

Company:

City of New York Location:

New York, NY

Salary:

Education:

Information Not Provided

Experience:

Information Not Provided

Hours:

Duration:

Full Time, Regular

Shift:

Description:

 Job Description

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 (1) 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:

375 Pearl Street

COMPUTER SPECIALIST

(SOFTWARE)

• 13632Qualifications(1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) 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 (2) A four-year high school diploma or its educational equivalent and six (6) 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 (3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above.

College education may be substituted for up to two years of the required e