Job Description THE AGENCY The Department of City Planning (DCP) plans for the strategic growth and development of the City through ground-up planning with communities, the development of land use policies and zoning regulations applicable citywide and sharing its perspectives on growth and community needs with sister agencies in collaboration with the Office of Management and Budget (OMB). DCP is a great place to work – cultivating intellectual inspiration, professional development, and creativity. Visit our website at www.nyc.gov/planning to access the full listing of job opportunities and to learn more about the agency’s services. THE DIVISION Information Technology Division’s (ITD) vision is to become a dynamic and vibrant technology delivery organization of the New York City government that leads business transformations and technology innovations to enable citizen-centric smart urban planning, while promoting a culture of collaboration, talent development, and equity. ITD is responsible for developing technology solutions to support agency needs and citywide asks, including City Charter mandates, grant funding requirements, and citywide geospatial services, and maintaining systems infrastructure and endpoint assets, to optimize operational efficiency, promote innovation, and collaborate with other city agencies to enhance service accessibility to citizens. The division provides necessary computing infrastructure and productivity-enhancing technology tools in a hybrid mode (on premise and in the cloud), to support DCP’s interdisciplinary staff across five boroughs, including planners, urban designers, project managers, and executive management. The division is comprised of experienced and talented software engineers, geographic specialists, service engineers, and technology leaders who specialize in managing system infrastructure, cyber security, geospatial data engineering, application services, and portfolio management. Within ITD, the Service Portfolio Management (SPM) unit is responsible for aligning IT services with business goals and ensuring that the organization's portfolio of services meets the needs of its customers and stakeholders, while leading the practice areas for project management, requirement analysis, and business relationship management. The unit plays a strategic role in overseeing the entire lifecycle of IT services and optimizing the portfolio to deliver value to the organization. SPM is involved in demand management, prioritization, capacity planning, capital/expense/grant funding mobilization, risk mitigation, and project governance, and uses portfolio management tools and systems that support budget estimation, planning, tracking, and reporting of services and projects. THE ROLE ITD’s Service Portfolio Management (SPM) unit is seeking a highly skilled and motivated Power Platform/Power BI Solution Developer to drive the development, deployment, and optimization of business intelligence and process automation solutions across the DCP. Leveraging Microsoft’s Power Platform, including Power BI, Power Apps, Power Automate, and SharePoint, this role will work closely with cross-functional teams to automate and streamline workflows, support data-driven decision-making, develop custom-dashboards for tracking key performance indicators, and enhance overall productivity. The ideal candidate combines strong technical skills with a strategic understanding of business needs, ensuring that solutions are both effective and scalable. Under supervision and general direction, with considerable latitude for the exercise of independent judgment, the Power Platform/Power BI Solution Developer’s responsibilities include, but may not be limited to: - Design, build, and maintain solutions using Power BI, Power Apps, Power Automate, and SharePoint. - Develop and integrate solutions using scripting languages such as PowerShell, JavaScript, or Python to extend the functionality of Power Platform tools. - Develop custom applications, dashboards, and automated workflows to address business needs. - Ensure all solutions are built for scalability, security, and ease of use. - Lead the design of data models and implementation of data visualization, dashboards, and reporting tools, using Power BI to deliver actionable insights. - Partner with stakeholders to define key performance indicators and build dashboards that support data-driven decision-making. - Regularly update and improve data models, ensuring accurate and relevant data is available for reporting. - Identify opportunities for automation in business processes, creating solutions using Power Automate to reduce manual tasks and enhance efficiency. - Connect Power BI to various data sources to ensure seamless data integration. - Optimize Power BI performance using DAX, Power Query, and data visualization best practices. - Design and implement ETL processes using SSIS for data extraction, transformation, and loading. - Optimize SQL queries and, stored procedures using T-SQL, and enhance SSRS reports to improve performance and data accessibility. - Develop, customize, and maintain SharePoint sites, workflows, and lists. - Create responsive interfaces and enhance the user experience for Power Apps and SharePoint, leveraging front-end frameworks. - Collaborate with teams to document workflows, design process improvements, and train users on new automated solutions. - Provide training, documentation, and support for Power Platform tools, fostering a collaborative environment that encourages adoption. - Establish and maintain best practices for Power Platform development, security, and governance. - Monitor usage, performance, and compliance, ensuring solutions adhere to organizational standards and policies. - Stay updated on Power Platform updates, trends, and new features, leveraging advancements to continually improve solutions. - Work closely with UI/UX designers, business analysts, project/product managers, and application developers on cohesive project planning and execution. - Collaborate in an agile environment, participating in sprint planning, backlog grooming, and daily stand-up meetings, and making progress updates. - Use version control systems for managing designs and codebases. - Estimate time required to complete tasks accurately, prioritize multiple tasks effectively, and ensure issues are identified, tracked, reported, and resolved in a timely manner. 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.