Power Platform/Power BI Solution Developer

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

Authorization to work in the United States is required for this position.

The NYC Department of City Planning does not offer sponsorship, of any kind, for any type of employment opportunity.

Applicants are responsible for ensuring that they meet all minimum qualifying requirements for this position at the time of application.



Only applicants under consideration will be contacted.

Appointments are subject to Office of Management and Budget (OMB) approval.

This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program agreed to between the City and DC37.

If you would like to request a reasonable accommodation during your visit or have questions regarding the accessibility of our facilities, please reach out to or call -- at least three business days prior to your arrival.

COMPUTER SPECIALIST (SOFTWARE) -

Minimum Qualifications

A baccalaureate degree from an accredited college, including or supplemented by twenty-four semester credits in computer science or a related computer field and two 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
A four-year high school diploma or its educational equivalent and six 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
A satisfactory combination of education and experience that is equivalent to or above.

College education may be substituted for up to two years of the required experience in above on the basis that sixty 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 or above.

However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one 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.

Preferred Skills
- Bachelor's degree in Computer Science, or a related field.

Master's degree is a plus.- 5+ years of experience in Power BI, Power Apps, SharePoint development, and SQL Server integration.
- Proven experience as a Power Platform Developer or in a similar role, with proficiency in Power BI, data modeling, DAX, and creating interactive reports and dashboards.
- Experience with Power Apps for custom application development and Power Automate for workflow automation.

- Experience with SharePoint, Microsoft ecosystem, and their integration capabilities.

- Strong analytical skills with the ability to interpret complex data sets.
- Strong expertise in SQL Server (T-SQL, SSIS, SSRS).
- Experience with data services, data connectors, and APIs. - Knowledge of Microsoft Azure services (Azure Data Factory, Azure SQL, etc.).
- Microsoft certifications on Power Platform, Power BI, SharePoint, or SQL Server.
- Proficiency in languages such as Python, JavaScript, or C# for developing custom workflows and integrations.
- Hands-on experience using HTML5, CSS, and JavaScript.
- Exceptional problem-solving skills and a proactive approach to identifying and resolving challenges.
- Understanding of software development lifecycles, methodologies, and project management practices.
- Experience with Agile methodologies, including Scrum or Kanban, and tools such as Azure DevOps and JIRA.
- Strong organizational skills with the ability to manage multiple projects and priorities concurrently.
- Proven track record of successful collaboration with development teams to deliver high-quality software products.
55a Program
This position is also open to qualified persons with a disability who are eligible for the 55-a Program.

Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.
Public Service Loan Forgiveness
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs.

For more information, please visit the U.S. Department of Education’s website at class=jobad-residencyRequirement>Residency RequirementNew York City Residency is not required for this position

Required Skill Profession

Computer Occupations