Power PlatformPower BI Solution Developer

THE AGENCY

The Department of City Planning (DCP) plans for the strategic growth and development of the City through groundup 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 to access the full listing of job opportunities and to learn more about the agencys services.

THE DIVISION

Information Technology Divisions (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 citizencentric 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 productivityenhancing technology tools in a hybrid mode (on premise and in the cloud) to support DCPs 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 organizations 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

ITDs 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 Microsofts Power Platform including Power BI Power Apps Power Automate and SharePoint this role will work closely with crossfunctional teams to automate and streamline workflows support datadriven decisionmaking develop customdashboards 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 Developers 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 datadriven decisionmaking.

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 TSQL 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 frontend 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 standup 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 twentyfour (24) semester credits in computer science or a related computer field and two (2) years of satisfactory fulltime 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 fouryear high school diploma or its educational equivalent and six (6) years of fulltime 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 fulltime 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 online 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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work : Employment Type :

Fulltime

Key Skills

Apparel Merchandising,Freelancing,Courier Delivery,Marine Services,Air Conditioning

Vacancy : 1