Apply on Employer Site

City of New York · 3 months ago

Power Platform/Power BI Solution Developer

New York, NY

Full-time

Hybrid

Mid, Senior Level

2+ years exp

The City of New York is seeking a highly skilled Power Platform/Power BI Solution Developer to join the Department of City Planning. This role involves driving the development, deployment, and optimization of business intelligence and process automation solutions using Microsoft’s Power Platform, while collaborating with cross-functional teams to enhance productivity and streamline workflows.

GovernmentLegalPublic Relations

No H1B

Responsibilities

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

Qualification

Power BIPower AppsPower AutomateSharePointPowerShellJavaScriptPythonDAXSQLSSISAgile methodologyTrainingDocumentationCollaboration

Required

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

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

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

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

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

To be eligible for placement in Assignment Level IV, 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