You are viewing a preview of this job. Log in or register to view more details about this job.

Data Analytics and Reporting Engineer, Digital Platform Solutions

Proposed Salary Range$ 70,000.00 - $ 90,000.00 (Annual)

**Interested applicants who meet the preferred requirements and hold another permanent civil service title are strongly encouraged to apply**

The Mayor's Office of Contract Services (MOCS) is a New York City oversight and service agency that manages procurement citywide, from planning and release of agency solicitations to payment of vendors. Annually, agencies procure billions in products and services from a diverse pool of vendors that represent various industries. MOCS therefore aims to ensure that the procurement process remains fair, transparent, efficient and cost-effective.

MOCS makes it easier to do business through use of end-to-end technology tools, increases transparency by publication of enriched data and hosting public hearings, and strengthens procurement operations by providing direct assistance and resources to all stakeholders. MOCS also partners with agencies and vendors to identify areas for policy reform, resulting in ongoing process improvement to reduce administrative burdens and increase the positive impact of services on communities. The MOCS Director serves as the City Chief Procurement Officer.

MOCS team members operate in a collaborative, service-oriented environment, where flexibility and ability to achieve results are valued. The Data Analytics and Reporting Engineer will report to the Senior Associate Director of Reporting and Analytics in the Digital Platform Solutions division, Office of the CTO. The successful candidate will focus on ensuring the effective design and implementation of data products and reporting solutions. This position requires a detailed-oriented, hands-on contributor who will work closely with MOCS business and BI teams on the analysis and design of these solutions.

Responsibilities include:
• Generate and validate routine, scheduled, unique and ad hoc reports and data extracts
• Collect requirements, design, build and test reports and dashboards across applications and programs
• Perform ad hoc analysis as required
• Provide support to operations and solve variety of reporting issues
• Develop and maintain databases, tables and processes to automate reports and analysis
• Ensure all reports are filed timely and accurately and are in agreement with other externally reporting information
• Determine ELT/ETL requirements and assist with execution of migrations
• Work closely with BI and PASSPort teams on data pipelines including analysis and design of integration solutions, data and reporting needs of internal and external stakeholders, and enhancements
• Identify and resolve data, technical issues and mediate business impact
• Ongoing professional development to strengthen skills and increase knowledge in relevant areas of procurement, technology, government operations, public policy and people and change management. 
• Understand issues affecting relevant stakeholder groups, including but not limited to covered city agencies, Minority and Women-owned Business Enterprises (M/WBEs), nonprofits, etc.
• Special projects, as assigned.

Minimum Qual Requirements

1. Graduation from an accredited college with a baccalaureate degree; or
2. Graduation from an accredited community college plus two years of experience with administrative, analytic, coordinative, supervisory or liaison responsibilities; or
3. A four-year high school diploma or its educational equivalent plus four years of experience as described in “2” above; or
4. A satisfactory equivalent combination of education and experience.

Preferred Skills

Demonstrate competency and/or history of consistent quality performance in the following areas of responsibility.

• Excellent writing and communication skills.
• Familiar with delivering solutions using Microsoft Power BI/AWS QuickSight/OBIEE.
• Ability to write procedures using SQL (i.e. T-SQL, PL/pgSQL, etc.).
• Understanding of data governance frameworks.
• Excellent analytical, organization, presentation, and facilitation skills; ability to handle multiple tasks under tight deadlines.
• Knowledge of New York City’s data share platforms and procurement systems is a plus including Open Data (DOITT’s DataShare) PASSPort, FMS, PIP, APT.
• Working knowledge of database back-end systems (i.e. AWS Redshift, SQL Server, Oracle, PostgreSQL) and Data Warehousing concepts. (Knowledge of Informatica helpful)
• User requirements analysis.
• Ability to multi-task and handle diverse responsibilities. Experience writing technical documentation.
• Knowledge and interest in computer systems and the latest technologies.

Additional Information

To best serve the City we represent, MOCS seeks individuals from a variety of backgrounds who can bring different perspectives to contribute to the work of the office. MOCS also seeks candidates who want to contribute to a work environment that values teamwork, inclusion and respect.


To Apply

External Applicants, please go to and search for Job ID#: 566879.
Current City Employees, please go to and search for Job ID#: 566879.

Mayor’s Office of Contract Services is an equal opportunity employer. Mayor’s Office of Contract Services recognizes the unique skills and strengths gained through military service. Veterans and service members of the U.S. Armed Forces are strongly encouraged to apply. Special accommodations provided to applicants with disabilities. Please contact MOCS Disability Service Facilitator at or 212-298-0734 only to request an accommodation. No other phone calls or personal inquiries permitted. 

For technical assistance, please use the following supported browsers: Chrome 35 and above, Firefox 24 and above, Internet Explorer 9 and above, and Safari 6 and above. If you encounter any errors, please clear your cache (web browser history). For instructions, please visit When navigating this website, you should use only the links and navigational buttons within the pages. Using your web browser’s BACK, FORWARD or REFRESH buttons may cause loss of data or lead to unintentional log outs.

Public Svc Loan Forgiveness

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

Work Location

255 Greenwich Street 9th Floor New York, NY 10007

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.

See DCAS Directive No. 2020-2 ( regarding residency requirement during the COVID-19 emergency.
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.