BUSINESS INTELLIGENCE SPECIALIST

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 Qualifications (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 experience in (2) above on the basis that sixty (60) 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 (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) 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. Additional Information The 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.