Jump to main content.

The Official Careers Website of the City of New York

Search

Senior Business Intelligence Data Analyst

  1. NYC HOUSING AUTHORITY
Posted on: 09/25/2024
  1. Full-time

Location

QUEENS

  1. No exam required

Department

Business Intelligence

$37,846.00 – $59,848.00

Job Description

This vacancy has now expired.

THE ACTUAL SALARY FOR THE POSITION IS $109,000.

The New York City Housing Authority (NYCHA) is the nation’s oldest and largest public housing authority with more than 176,000 apartments, and responsibility for administering a citywide Section 8 leased housing program that serves over 200,000 additional tenants. NYCHA’s mission is to provide quality housing for New Yorkers that is sustainable, inclusive, and safe, while fostering opportunities for economic mobility.

NYCHA’s Asset & Capital Management (A&CM) Division integrates and aligns the Authority’s existing development, modernization, and asset management work being carried out by the Real Estate Development, Capital Projects, and Comprehensive Modernization departments. This includes a $4.5 billion capital program – one of the largest in NY State – as well as a historic real estate transaction portfolio. The A&CM Division delivers comprehensive repairs to NYCHA buildings and apartments through innovative financing models, strong partnership with residents and other stakeholders, strategic, data-driven portfolio planning, and cost-effective project delivery and management. The Division also positions NYCHA’s housing portfolio for the future by incorporating innovative building materials, construction methods, and technology, improving residents’ quality of life while enhancing building performance and management systems.

Position Description

The A&CM Division’s Strategic Services Department seeks a Senior Business Intelligence Data Analyst. The BI unit has two primary areas of responsibility: providing analytical support across the division and leading execution of routine and ad hoc A&CM reports. The unit works closely with NYCHA’s CACMO to assess strategic reporting and data transparency needs for non-A&CM stakeholders and ensure fidelity of A&CM reports.

The Senior Business Intelligence Data Analyst should have exceptional proficiency with data. This proficiency should include a strong technical quantitative foundation, with understanding of various data manipulation tools and programming languages (e.g., Excel, R, Python, SQL). In addition, the Analyst should be well equipped to identify data needs across the division, taking a consultative approach to helping A&CM unit leads establish and improve upon appropriate metrics to stay abreast of their units’ work. The Analyst should be able to effectively explain complex data concepts to non-quantitative audiences, helped to foster a culture of data-driven decision making across the division.

The ideal candidate excels at working with data and being able to manipulate it through use of relational databases and programming languages to support effective decision making within NYCHA and accurate reporting to external stakeholders.

Some key day-to-day responsibilities include:

- Write and execute advanced SQL and python commands manipulate data for data analytics, dashboards, and reporting.
- Lead, design and develop self-serve BI and visualization dashboards, providing easy access to data and insights by leveraging various BI tools and programming concepts in python.
- Create and maintain interfaces within Microsoft Power Platform.
- Project Management of special initiatives projects and assignments.
- Work with e-Builder team to align inputs with internal and external reporting needs.
- Liaise with internal stakeholders to identify opportunities to provide analysis to support decision making.
- Align data quality procedures and automations for analysis and reporting with A&CM business needs.

Key Competencies

- Subject Matter Expert: Expertise in applied data science, including some technical acumen and an ability to explain and present complex data to non-quantitative audiences and knowledge of effective development of data tools (e.g., dashboards).
- Strong Leader & Capacity Builder: A proven leader with experience in public sector reporting, data governance, data analysis, and/or project management. Ability to work in high-performance teams through cultivating innovation, ownership, accountability, and collaboration.
- Effective Analyst & Change Agent: A strategic thinker and structured problem-solver, able to drive change and innovation while effectively juggling diverse responsibilities and multiple, competing priorities.
- Exemplary Communicator: Ability to communicate complex data concepts to a variety of stakeholders, including non-quantitative audiences. Communication skills should include strong data visualization acumen, including both technical skills (e.g., Dashboarding, Excel, PowerPoint) and understanding of data visualization best practices. Strong political acumen and practiced in facilitating multi-stakeholder meetings designed to achieve consensus on objectives. Experience collaborating with a diversity of cultures and sensitive to the challenges of low-income populations.

Additional Information

1. Candidates with permanent civil service status in the titles of Associate Staff Analyst, Computer Specialist (Software) L2 or Certified IT Administrator (Database) L1 will also be considered.
2. NYCHA employees applying for transfer, promotional, title or level change opportunities must have served a period of one year at current location and in current title and level (if applicable).
3. NYCHA residents are encouraged to apply.

Please read this posting carefully to make certain you meet the minimum qualification requirements before applying to this position.


Minimum Qualifications

1. A baccalaureate degree from an accredited college and two years of full-time professional experience in intergroup relations, human rights, community relations, labor relations, law, social service, education, housing, research, investigation, personnel administration or public relations, at least one year of which must have been in intergroup relations or human rights involving conflict resolution and mediation of disputes among racial, religious or ethnic groups; or
2. High school graduation or evidence of having passed an examination for the high school equivalency diploma or the U.S. Armed Forces GED certificate with a score of at least 35 on each of the five GED certificate with a score of at least 35 on each of the five tests and an overall score of at least 225 in the examination for the diploma or certificate and six years of full-time professional experience in one or more of the fields described above, four years of which must have been in intergroup relations or human rights as described in (1) above; or
3. A satisfactory equivalent combination of education and experience as described above. However, all candidates must be high school graduates or possess the high school equivalency as described above and possess a combination of college education and intergroup relations and/or human rights experience totaling four years and all candidates must have at least one year of experience in intergroup relations or human rights as described in (1) above.


Preferred Skills

- Experience developing, implementing, and maintaining complex MS Power BI or similar tools dashboards, visualizations, and analytics. - Must possess a highly proficient understanding of relational databases and complex database structures, including hands on experience writing complex SQL queries. - Strong problem solving and troubleshooting skills which must incorporate data acquisition, transformation, and delivering information effectively utilizing modern BI tools. - Hands on experience and proficiency with MS PowerBI, Relational Databases, SQL, python, or similar programming languages. - Experience with Predictive analytics, Machine Learning and AI are highly desirable. - Experience with Microsoft Power Platform (e.g., power automate, power forms, etc.) is highly desirable.
Residency Requirement

NYCHA has no residency requirements.
Additional Information

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.

Job ID

680390

Title code

55014

Civil service title

SENIOR INTERGROUP RELATIONS OF

Title classification

Non-Competitive-5

Business title

Senior Business Intelligence Data Analyst

Posted until

2024-09-27

  1. Experienced (non-manager)

Job level

00

Number of positions

1

Work location

Business Intelligence

  1. Technology, Data & Innovation

Senior Business Intelligence Data Analyst

Search