Systems Specialist

Job Summary

Serving as a senior advisor to the IT Manager, the Technology Systems Specialist is responsible for assisting in the development, configuration, deployment, and maintenance of all Commissioner’s Precinct One technology. This role encompasses designing and maintaining business solutions aligned with OCRE strategic goals, involving complex technical tasks related to endpoint management systems, remote support, and hosted resources. Duties include conducting systems analysis, providing high-level technical support, and developing custom programming and scripting solutions.

The ideal candidate should have strong problem-solving skills, able to analyze business needs and implement effective solutions using APIs, Power Apps, or Power BI dashboards. Additional responsibilities include managing SharePoint, API integrations, cloud databases, business intelligence reports, and front-end Helpdesk support.

• Design, write, and debug custom Power Shell or Python scripts to automate repetitive system tasks.
• Develop and maintain Power Automate workflows and Power Apps to modernize departmental business processes.
• Maintain and update custom‑coded applications and provide logical instructions for integrated data processing.

• Serve as the primary technical administrator for the departmental SharePoint Online environment, managing site architecture and custom web parts.
• Develop and execute SQL queries to extract and report data from internal and hosted databases.
• Manage and integrate data within the Microsoft Dataverse for departmental reporting and Power BI dashboards.

• Administer Unified Endpoint Management (UEM/MDM) platforms for automated device enrollment and profile configuration.
• Manage remote support tools to diagnose and resolve complex hardware and software incidents for on‑site and remote personnel.
• Coordinate automated software deployments and security patch management for departmental assets.

• Resolve high‑tier end‑user service tickets including complex desktop, printer, and peripheral hardware issues.
• Document all troubleshooting steps, repair activities, and final solutions within the IT service delivery system.
• Provide instructional guidance and training to non‑technical staff on new software implementations and digital tools.

• Assist the Senior Admin in monitoring the availability and performance of hosted server environments and web applications.
• Maintain an accurate inventory of hardware and software licenses associated with departmental workflows.
• Other duties as assigned.

• Graduation from an accredited four‑year college or university with major coursework in Computer Science, Information Technology, or a related field (Professional experience may be substituted for education on a year‑for‑year basis).

• Two (2) relevant IT certifications are highly desired, such as Microsoft Certified:
  Power Platform Developer Associate (PL‑400), Azure Administrator Associate (AZ‑104), Power BI Data Analyst (PL‑300), CompTIA Security+, or Network+.

• Five (5) to seven (7) years of professional experience in systems administration, technical support, or computer programming.
• Demonstrated proficiency in developing and debugging functional code and automation scripts, specifically utilizing Power Shell.
• Strong, hands‑on experience with Microsoft 365 administration, including SharePoint Online and integrated cloud environments.
• Experience building and maintaining automated business logic and applications using the Microsoft Power Platform (Power Apps and Power Automate).
• Proficiency in writing and executing SQL queries to manage and report data from internal and hosted databases.
• Solid understanding of enterprise endpoint management (MDM) architectures and remote support protocols.
• Experience providing high‑tier technical support within an IT service delivery (ticketing) system.
• Excellent communication skills and the ability to translate complex business requirements into maintainable…