Power Platform/SharePoint Developer

City of Longmont; Longmont (CO); On-site; USD 95,585 - 106,209; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Flex Spending

Pension Plan

Life Insurance

Long Term Disability

Vacation and Holidays

Tuition Assistance

Employee Assistance Program

Job summary

The City of Longmont is seeking a Power Platform/SharePoint Developer to design, build, and maintain solutions on Power Apps, Power Automate, Power BI, and SharePoint Online. The role bridges business needs with technical implementation and focuses on scalable, secure, user-friendly solutions.

The ideal candidate has 3+ years in Power BI development (DAX, Power Query, data modeling, custom visuals), extensive Power Apps and Power Automate experience, and advanced SharePoint Online customization

Qualifications

• Bachelor’s degree with 3+ years in Power BI development (DAX, Power Query, data modeling, visuals).
• Extensive Power Apps and Power Automate experience, including complex flows and multi-data-source integrations.
• Advanced SharePoint Online customization and Dataverse expertise.

Responsibilities

• Design, develop, and maintain Power Platform applications to solve business challenges.
• Automate workflows and business processes with Power Automate, including complex flows.
• Create and maintain Power BI dashboards and reports for data visualization and decision-making.
• Manage SharePoint Online infrastructure, governance, security, and solution implementations.
• Integrate SharePoint with Power Platform tools and provide training and support.

Skills

Power BI development

Power Apps

Power Automate

SharePoint Online customization

Dataverse expertise

Education

Bachelor’s Degree in related field

Job description

20260147 Power Platform/SharePoint Developer

Department: Shared Services

Division: Enterprise Technology Services

Hiring Range: $8,565 - $9,517/month

Monday – Friday, 8:00AM - 5:00PM, some weekends and nights.

Regular Full-time with Benefits

Benefits include: Medical, Dental, Vision, Flex Spending, Defined Benefit Pension Plan, 401(a) Money Purchase Plan, Life & Survivor, Term Life & AD&D, Long Term Disability, Bereavement, Jury & Witness Duty, FMLA, Military Leave, Parental and Caregiver Leave, Sick, Vacation at start of employment, Holiday pay, EAP, Tuition Assistance.

Other benefits: Optional, employee elected, voluntary benefits are available.

Definition:

The Power Platform/SharePoint Developer designs, builds, and maintains solutions using Microsoft’s Power Platform (Power Apps, Power Automate, Power BI) and SharePoint Online to automate workflows, enhance collaboration, and deliver actionable insights. The role bridges business needs with technical implementation, ensuring scalable, secure, and user-friendly solutions.

The Power Platform/SharePoint Developer will be responsible for the management of the City’s SharePoint Online infrastructure and the development of system governance, security, architecture, designs and solution implementations for the City’s SharePoint and Power Platform environments in support of the City’s business initiatives. They promote the adoption and effective use of Microsoft 365 tools, including SharePoint, Teams, and Power Platform.

• Power Platform Development:
• Design, develop, and maintain applications using Power Apps (Canvas and Model-Driven) to solve business challenges.
• Automate workflows and business processes with Power Automate, including complex flows and integrations.
• Create and maintain Power BI dashboards and reports for data visualization and decision-making.
• SharePoint & Dataverse:
• Build, customize, and optimize SharePoint Online sites, lists, libraries, forms, views, and permissions.
• Design and manage Dataverse data models, relationships, and data types.
• Integrate SharePoint with Power Platform tools and approved third-party systems.
• Manage SharePoint Online sites and storage using SharePoint Advanced Management, lifecycle policies, and quotas
• Integration & APIs:
• Connect Power Platform solutions with Microsoft 365, Azure, and external systems via APIs and REST.
• Data & Analytics:
• Perform data cleansing, transformation, and integration from multiple sources.
• Use SQL, DAX, and Power Query for data modeling and analysis.
• Support & Training:
• Provide technical support, troubleshooting, and user training for Power Platform and SharePoint solutions.
• Maintain documentation for solutions and processes.
• Governance & Security:
• Ensure solutions comply with enterprise standards, security policies, and data classification requirements (e.g., PII, PCI, CJIS, HIPAA)
• Lead SharePoint Governance team consisting of critical business units and members and mitigate conflicting requirements to guarantee a productive solution for all.

Work is performed in a standard office environment. Work requires problem-solving skills and the ability to communicate effectively orally and in writing. Work involves frequent reading, reasoning, customer contact, multiple concurrent tasks, constant interruptions, heavy lifting and carrying (50 pounds. or more), pulling, pushing, reaching, walking, standing, bending/stooping.Work involves occasional sitting, climbing, twisting, kneeling, and squatting. Requires periodic travel to other departments. Responsibilities may include evening and weekend work in response to needs of the systems being supported.

Qualifications:

Any combination of experience or education equivalent to a Bachelor’s Degree from an accredited college with major course work in business information systems, computer science or a closely related field and a minimum 3+ years in Power BI development (DAX, Power Query, data modeling, custom visuals). Extensive Power Apps and Power Automate experience, including complex flows and multi-data-source integrations. Advanced SharePoint Online customization and Dataverse expertise.

We’re committed to building a team that reflects the diversity of the communities we serve. The City may consider an equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications, and encourages all candidates to apply and help us achieve our goal of creating an inclusive and equitable workplace.

Selection

The selection process will include complete job description review, personal interview, background investigation, criminal background check, and substance screening. Unescorted Security Clearance Required.

The City of Longmont is an equal opportunity employer. The City affirms its commitment to diversity and to complying with all applicable federal, state, and local laws regarding nondiscrimination in employment. The City will not discriminate against any person in recruiting, examining, appointing, hiring, training, placement, termination, layoffs, recall, transfer, leave of absence, promoting, compensating, retaining, disciplining, or any other personnel action on the basis of age, race, color, creed, religion, sex, sexual orientation, gender identity or expression, national origin, ancestry, genetic information, marital status, veteran status, status with regard to public assistance, physical or mental disability, or any other characteristic protected by federal, state, and local law, except when any of these categories constitutes a bona fide occupational qualification (i.e., an actual qualification for performing a job).If you need special assistance in the selection process, please contact the Human Resources Department in advance to make arrangements.

AN EQUAL OPPORTUNITY EMPLOYER

ALL CITY OF LONGMONT FACILITIES ARE SMOKE FREE