Job Information
City of New York Senior Business Intelligence Data Analyst in New York, New York
Job Description
Organization
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.
NOTE: Due to the existence of a civil service list, candidates must have civil service status in the title of Computer Specialist (Software) to be considered.
NOTE: This position is open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate in your cover letter that you would like to be considered for the position under the 55-a Program. For detailed information regarding the 55-a Program, please visit the link below:
http://www.nyc.gov/html/dcas/downloads/pdf/psb/100_1.pdf
Please read this posting carefully to make certain you meet the minimum qualification requirements before applying to this position.
Qualifications
(1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or
(2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in “1" above, including one year in a project leader capacity or as a major contributor on a complex project; or
(3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above. College education may be substituted for up to two years of the required experience in (2) above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.
NOTE: In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor. Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification
requirements.
Special Note
To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming.
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.