Agency Description

The Department of Small Business Services (SBS) helps unlock economic potential and create economic security for all New Yorkers by connecting New Yorkers to good jobs, creating stronger businesses, and building a fairer economy in neighborhoods across the five boroughs.

Job Description:

SBS is seeking a Business Intelligence Analyst in the PMO team within the Technology Unit. This position requires a high level of analysis of existing content usage trends and the ability to make frequent content changes to support agency and city needs.


- Work closely with City Agency Partners to manage data exchanges on MyCity Business site

- Document and clarify user story requirements for MyCity Business product site

- Perform all technical UAT for changes on MyCity Business site and data exchanges

- Work closely with Partner Agency NYC OTI Development and QA teams to ensure business requirements for MyCity Business data exchanges and product site are implemented accurately and are functional

- Run usage reports for MyCity Business site and disseminates the data to relevant stakeholders

- Work closely with City Agency Partners and SBS to manage content displayed on the MyCity Business site

- Make all configuration changes for the rules management engine and perform all end-user UAT for changes on MyCity Business Wizard sections

- Coordinate with SBS Marketing division to ensure alignment of content across MyCity Business site and SBS

- Develop and maintain printed materials such as checklists and guides for distribution on the MyCity Business Portal

- Assist in the development, collection, analysis, and reporting on the health of the content on the MyCity Business Portal and incorporate user feedback into future enhancements

Preferred Skills:

-5 years Microsoft SQL Server administration or equivalent experience

-Must have strong experience with SSIS, SSRS, .NET or other application development and database optimization

-Excellent writing, communication, and critical thinking skills

-Ability to write complex procedures using SQL / T-SQL

-Working knowledge of database back-end systems, including SQL Server 2012/2014/2016, Oracle or other relational databases.

-Ability to interact with all levels of management

-Familiarity with ETL methodology, procedures, development, and testing

-Excellent analytical, research, problem solving, organization, presentation and facilitation skills; ability to handle multiple tasks under tight deadlines

-Experience working with large datasets and building reports for website analytics

-Knowledge of Customer Relationship Management (CRM) and/or database applications

-Knowledge of NoSQL databases including MongoDB, DynamoDB, etc. a plus

-Experience with QA testing, web development, and working with content management systems, such as TeamSite and AEM


Residency Requirement:

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

How to Apply:

THIS POSITION IS OPEN TO CANDIDATES WHO ARE IN THE Certified IT Developer (Applications) title (OR OTHER COMPARABLE TITLES), THOSE WHO ARE REACHABLE ON THE CIVIL SERVICE LIST AND THOSE IN THE 55-A PROGRAM. PLEASE INDICATE IN YOUR COVER LETTER IF YOU ARE PERMANENT IN THE TITLE OR ARE REACHABLE ON THE CIVIL SERVICE LIST.

City Employees: Apply through Employee Self Service (ESS) at www.nyc.gov/ess search for Job ID: #605016

Current SBS Employees: Please email your resume and cover letter including the following subject line:

Business Intelligence Analyst Certified IT Developer (Applications) and send to careers@sbs.nyc.gov

All Other Applicants: Go to https://cityjobs.nyc.gov/ search for Job ID: # 605016


If you are unable to apply via NYC Jobs or ESS, you can email your cover letter and resume to careers@sbs.nyc.gov with the following in the subject line: Business Intelligence Analyst Certified IT Developer.

If you do not have access to email, mail your cover letter & resume to:

NYC Department of Small Business Services
Human Resources Unit
1 Liberty Plaza, 11th Floor
New York, New York 10038

Note: We appreciate the interest and thank all applicants who apply, but only those candidates under consideration will be contacted.

Professional/Vendor Certification, Education and Experience Requirements: You must have current professional/vendor certifications.
In addition, you must have one of the following:
1. A masters degree in computer science or a related field from an accredited college or university, accredited by regional, national, professional, or specialized agencies recognized as accrediting bodies by the U.S. Secretary of Education and by the Council for Higher Education Accreditation (CHEA) AND 12 months of satisfactory full-time (not classroom based) specialized experience in computer applications development planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management as described in the following nine Major Task Groups in the IT Titles Task Inventory*: Applications Development; Web Development, Design, and Maintenance; Business/Systems Analysis; Project Management Support; Application Design; GIS Structures, Spatial Analysis, and Mapping Principles; Testing; Technical Writing; and Version Control; OR
2. A baccalaureate degree from an accredited college or university, accredited by regional, national, professional, or specialized agencies recognized as accrediting bodies by the U.S. Secretary of Education and by the Council for Higher Education Accreditation (CHEA) AND 24 months of satisfactory full-time (not classroom based) specialized experience as described in “1” above; OR
3. A four-year high school diploma or its educational equivalent approved by a State’s Department of Education or a recognized accrediting organization AND 24 months of satisfactory full-time (not classroom based) specialized experience as described in “1” above plus 48 months of information technology experience as described in the IT Task Inventory *; OR
4. A satisfactory combination of education and experience which is equivalent to “3” above. Education may be substituted for the information technology experience on the basis of 30 semester credits from an accredited college or university, accredited by regional, national, professional, or specialized agencies recognized as accrediting bodies by the U.S. Secretary of Education and by the Council for Higher Education Accreditation (CHEA) is equivalent to 12 months of experience, up to a maximum of 48 months. However, if you qualify under options “2,” “3” or “4,” you must have at least a four-year high school diploma or its educational equivalent approved by a State’s Department of Education or a recognized accrediting organization and at least 24 months of satisfactory full-time (not classroom based) specialized information technology experience as described in “1” above.

Preferred Skills: 5 years Microsoft SQL Server administration or equivalent experience Must have strong experience with SSIS, SSRS, .NET or other application development and database optimization Excellent writing, communication, and critical thinking skills Ability to write complex procedures using SQL / T-SQL Working knowledge of database back-end systems, including SQL Server 2012/2014/2016, Oracle or other relational databases. Ability to interact with all levels of management Familiarity with ETL methodology, procedures, development, and testing Excellent analytical, research, problem solving, organization, presentation and facilitation skills ability to handle multiple tasks under tight deadlines Experience working with large datasets and building reports for website analytics Knowledge of Customer Relationship Management (CRM) and/or database applications Knowledge of NoSQL databases including MongoDB, DynamoDB, etc. a plus Experience with QA testing, web development, and working with content management systems, such as TeamSite and AEM

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.

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

New York City Residency is not required for this position

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.