NYC Department of Social Services ยท 2 days ago
Business Intelligence Specialist
Wonder how qualified you are to the job?
ConsultingGovernment
Insider Connection @NYC Department of Social Services
Responsibilities
Utilize modern commercial database management tools such as SQL Server Management Studio and SQL Developer to manipulate data and write queries.
Adhere to reporting requirements, migrate existing EXCEL reports into SQL Server Reporting Service (SSRS) and SharePoint, and develop new reports and dashboards.
Develop and maintain Microsoft.Net Application to extract and customize display of information from existing systems.
Investigate data issues in various source systems using ad-hoc queries and debugging tools.
Create BFI and Revenue statistical reports and presentations to support various data analytic needs.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
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
A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described 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 the above. College education may be substituted for up to two years of the required experience on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A master's degree in computer science or a related computer field may be substituted for one year of the required experience. 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.
Preferred
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.
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.
Benefits
55-a Program eligibility
Company
NYC Department of Social Services
The Department of Social Services (DSS) is comprised of the administrative units of the NYC Human Resources Administration (HRA) and the Department of Homeless Services (DHS).