44 applicants

This job has closed.

Company

New York City Police Department · 2 days ago

Reporting Analyst

Manhattan, NY

Full-time

Onsite

Mid Level

Maximize your interview chances

Law Enforcement

Insider Connection @New York City Police Department

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

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 HR 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.

Manage implementation and expansion of Power BI portfolio, collaborating with data engineering to define data integration with the Power BI platform.

Provide Power BI mentorship to other analysts.

Tracking and reporting to management progress of report completion.

Ensure all reports are filed timely and accurately and in agreement with external 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.

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.

Power BISQLData GovernanceMicrosoft ExcelAWS QuickSightOBIEEData WarehousingDatabase SystemsUser Requirements AnalysisTechnical Documentation

Required

Do you have a baccalaureate degree from an accredited college or university?

Do you have an associate degree from an accredited college or university along with two (2) years of experience with administrative, analytic, coordinative, supervisory or liaison responsibilities?

Do you have a four-year high school diploma, or its educational equivalent approved by a state's Department of Education or a recognized accrediting organization along with four (4) years of experience as described in question '2' above?

Do you have a satisfactory combination of education and/or experience equivalent to that described in questions '1,' '2,' and/or '3' above?

Preferred

Excellent writing and communication skills.

Knowledge and interest in computer systems and the latest technologies.

Familiar with and experienced in delivering solutions using Microsoft Excel/AWS QuickSight/OBIEE.

Demonstrated mastery of Power BI.

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.