Senior Data Analytics and Reporting Data Engineer, Digital Platform Solutions

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 Senior Data Analytics and Reporting Data 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:

• Manage reporting needs to include generating and validating 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

• Recommend process, procedural, reporting and system changes that will improve and enhance the Digital Platform Solutions function

• Provide support to operations and oversight staff members on a variety of reporting issues

• Develop and maintain databases, tables and processes to automate reports and analysis

• Tracking and reporting to manage progress of report completion

• Ensure all reports are filed timely and accurately and are in agreement with other externally reporting information

• Determine ELT/ETL requirements and assist with production, setup, and 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.

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.

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

• Excellent writing and communication skills.

• Familiar with and experienced in delivering solutions using Microsoft Power BI/AWS QuickSight/OBIEE.

• Ability to write complex 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.

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.

#TDEDS

External Applicants, please go to www.nyc.gov/jobs and search for Job ID#: 566869

Current City Employees, please go to www.nyc.gov/ess and search for Job ID#: 566869

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 disabilityaffairs@mocs.nyc.gov 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 https://a127-jobs.nyc.gov/psc/nycjobs/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=NYC_EHIRE_HELP_FL&Action=U&. 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.

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 StudentAid.gov/PSLF.

255 Greenwich Street, 9th floor

New York, NY 10007

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 (https://www1.nyc.gov/assets/dcas/downloads/pdf/agencies/directive_2020_2.pdf) regarding residency requirement during the COVID-19 emergency.