Job description

Position Summary: The Power Platform Applications Developer will be assigned to the Business Workflow Automation team. Projects will deliver fully functional, integrated applications within the Microsoft Power Platform ecosystem. These deliverables will include automated workflows through Power Automate, internal Power App canvas and model-driven applications, and public-facing websites built with Power Pages, all of which are expected to enhance both customer-facing services and internal operations. In addition to Power Platform tools, deliverables may include supporting technologies such as Python and JavaScript. Use of artificial intelligence (AI) will be encouraged throughout the development process. Relationship diagrams, flow charts, and technical specifications will be created for all deliverables. The completion of these projects will improve workflow automation, enable better data-driven decision-making, and create a seamless user experience for all stakeholders. Position Responsibilities: The Power Platform / Business Workflow Automation Developer is responsible for the entire software development life cycle, including designing, developing, deploying, documenting, and maintaining solutions using the Power Platform and complementary tools. The role includes building canvas and model-driven Power Apps, developing flows with Power Automate, and creating public-facing websites using Power Pages. The developer will integrate data from Dataverse, SharePoint, and external sources such as SQL Server, Snowflake, and APIs. The role also emphasizes customer-focused solutions, strong fundamentals in computer science, and a deep understanding of relational databases and APIs. Essential duties include, but are not limited to, the following: • Design and develop canvas and model-driven applications using Microsoft Power Apps to support business operations. • Design and develop automated workflows using Power Automate to streamline manual processes across departments. • Build and manage public-facing websites through Power Pages, ensuring they meet security and user accessibility standards. • Integrate Dataverse, SharePoint, and external data sources such as SQLServer, Snowflake, and APIs into the Power Platform environment. Use Python and JavaScript to complement Power Platform development • Develop reports and dashboards using PowerBI. • Collaborate with teams and stakeholders to determine requirements, translate them into technical solutions, provide technical support and ensure the project meets business objectives. • Provide ongoing support and updates for existing Power Apps solutions, ensuring they meet performance, security, and usability standards. • Document technical solutions, including workflow diagrams, sequence diagrams, and entity relationship diagrams for all deliverables. • Create and consume custom Power App components • Leverage AI tools such as Copilot, ChatGPT, and n8n • Apply software design principles (e.g., modular design, Big O considerations) • Participate in user group meetings, online forums, and other community engagements to stay updated on the latest trends and best practices in Power Platform development, ensuring performance and reliability. Appointment Type Permanent Exempt (PEX), Full Time position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointment officer. The anticipated duration of this project position is thirty-six (36) months and will not result in an eligible list or permanent civil service hiring. Project-based positions cannot be ongoing or exceed 36 months Work Location Incumbent will conduct the majority of work at the Department of Technology, (1 S Van Ness, Ave San Francisco, CA 94103). However, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco as necessary. The Department offers a hybrid work schedule. Nature of Work The incumbent must be willing to work on-site at our San Francisco office in person four days a week and one day remote as determined by the department. Travel within San Francisco may be required. Incumbent may be required to provide 24-hour on-call support to ensure rapid recovery from software or hardware problems for mission-critical systems and networks.

Requirements