Business Systems Analyst

Sarasota County Government

6d • $64,813 - $70,034

About The Position

Start Here. Grow Here. Stay Here. Are you a data-driven professional who thrives on turning complex systems into actionable insights? We’re seeking a lead-level analyst to manage and perform advanced compliance analysis across Stormwater’s data systems. In this role, you’ll design and maintain data models and automated workflows using tools like Power BI, Power Query, and Robotic and Digital Process Automation (RPA/DPA). You’ll also develop innovative Smartsheet solutions, support data governance efforts, and collaborate with stakeholders to transform business needs into impactful reporting and analytics. If you’re passionate about leveraging data to drive smarter decisions and improve operational efficiency, apply today and help shape the future of Stormwater analytics. About This Position Business Systems Administration Develop and maintain business systems, including RPA and DPA workflows using Microsoft Power Automate Build and manage Power BI enterprise reports to support financial and departmental planning Perform statistical analysis for descriptive, diagnostic, predictive, and prescriptive insights Create and maintain technical documentation using tools like Azure DevOps Manage ELT processes and design optimized data models (e.g., star schemas) for reporting Support data governance, data quality, and data catalog initiatives using tools like Azure Purview Develop and maintain data structures using tools such as Python, SQL, DAX, M-Code, and Azure Data Platform Collaborate with stakeholders, provide technical support, and assist with SharePoint and website updates Technical Lead/Project Management Actively participates as project lead in software and hardware upgrades and keeps the manager informed of progress and obstacles Advise management and provides recommendations on technical and project issues

Requirements

• Bachelor's degree in a job-related field AND two (2) years of job-related experience -OR- Six (6) years of professional job-related experience can be substituted at management discretion for the required education -OR- Related professional program/ project management may substitute for the required education at management discretion
• A valid Florida driver's license at the time of hire
• Subject to Passing Substance Screening: This position is subject to passing a pre-employment substance screening. An applicant who fails to pass a required drug screening test shall be disqualified from employment in any class for a period of five (5) years.

Nice To Haves

• Advanced knowledge of spreadsheet applications, Software as a Service (SaaS) products, asset or work management systems, enterprise information platforms, and data visualization software; Microsoft Power BI & Power Query, Cartegraph, Financial Enterprise, GovMax, OnBase, and GIS.

Responsibilities

• Develop and maintain business systems, including RPA and DPA workflows using Microsoft Power Automate
• Build and manage Power BI enterprise reports to support financial and departmental planning
• Perform statistical analysis for descriptive, diagnostic, predictive, and prescriptive insights
• Create and maintain technical documentation using tools like Azure DevOps
• Manage ELT processes and design optimized data models (e.g., star schemas) for reporting
• Support data governance, data quality, and data catalog initiatives using tools like Azure Purview
• Develop and maintain data structures using tools such as Python, SQL, DAX, M-Code, and Azure Data Platform
• Collaborate with stakeholders, provide technical support, and assist with SharePoint and website updates
• Actively participates as project lead in software and hardware upgrades and keeps the manager informed of progress and obstacles
• Advise management and provides recommendations on technical and project issues

Benefits

• Enjoy great benefits including Health, Dental, Vision, and Life Insurance, Short-Term and Long-Term Disability, Flexible Spending Accounts, Employee Assistance Program (EAP), Florida Retirement System (FRS) and many, many more!
• Choose one of three great medical plans, including one with a $0 premium option, with completed preventative visits!
• For more information about employee benefits, please click this link or visit SCGov.net for additional information.
• Utilize our award-winning wellness program including free gyms at multiple Sarasota County Government locations.
• Enjoy 11 paid holidays, 3 personal days and 16 paid vacation days in the first year of full-time employment with increasing accrual rates with years of service. (That adds up to a possible 30 days off in your 1st year!)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees