Business Intelligence Specialist - Manhattan, United States - NYC Careers

NYC Careers
NYC Careers
Verified Company
Manhattan, United States

2 weeks ago

Mark Lane

Posted by:

Mark Lane

beBee recruiter
Description

BUSINESS INTELLIGENCE SPECIALIST:


  • Apply

BUSINESS INTELLIGENCE SPECIALIST:


  • Agency: HRA/DEPT OF SOCIAL SERVICES


  • Posted on: 05/16/2024

  • Job type: Fulltime
Location


MANHATTAN

  • Title Classification: Exam may be required
Department


DSS ACCOUNTABILITY OFFICE NM

  • Salary range: $89, $108, APPLICANTS MUST BE PERMANENT IN THE COMPUTER SPECIALIST (SOFTWARE) CIVIL SERVICE TITLE OR IN A COMPARABLE TITLE ELIGIBLE FOR 6.1.
  • 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 intelligenceled, datadriven 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 adhoc 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 adhoc 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 StreetMinimum Qualifications(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


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


Preferred Skills 55a ProgramThis 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 RequirementNew York City Residency is not required for this position- Additional InformationThe City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Minimum Qualifications(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 ye
More jobs from NYC Careers
See all jobs of NYC Careers