Data and Project Analyst - Business Professional II
Full Time
Sarasota County, FL
Posted
Job description
Department:
Capital Projects
About Our Job
Sarasota County is the premier community where people choose to live, work, and play! As the Data and Project Analyst you will touch on almost every project within the Capital Projects Department. Some of the projects you may be involved with include the County Administration Building, the Regional Fire/EMS Training Academy, and the ES Administration Building. If you want to serve your community by reviewing contracts for bid costs for a database, be responsible for purchase requisition entries and assist with EIT requests which including software requests, hardware requests and movement of technology equipment within the Department apply today to become a member of this amazing team!
Job Description:
Bid Tabulations and Consultant Rate Review
- Collate Bid Tabulations from numerous CIP Projects.
- General Data analysis and forecasting (Pivot tables, Macros, Index/Match
formula, Power BI, etc.)
- Compare Bid Tabulations to verify lowest bidder.
- Manage, update, maintain database containing bid tabulations by item type,
bidder name, bid value.
- Provide Bid Tab reports to Project Managers and Management as requested.
- Manage, update, maintain database containing consultant rates on numerous
CIP Projects.
- Provide consultant rate reports to Project Managers and Management as
requested.
Project Financial Analysis
- Analysis of up to 110 CIP projects.
- Generate Burn rate calculations and forecasting expenditures.
- Purchase Requisition Entry.
- Compliance monitoring and review of contract documents for requirements.
- Creating, auditing, and updating with annual CIP Project budget documents.
Project Management Information System PMIS Functions
- Primary backup for e-Builder PMIS acting as administrator as needed.
- Provide customer service, respond to e-Builder Help Desk tickets as delegated.
by e-Builder administrator.
- Act as training backup if system administrator is unavailable.
Hardware and Software Inventory Functions
- Maintain all Capital Projects department computers, phones, and software inventory.
- Review annual inventory reports from EIT to ensure departments internal service charges are correct.
- Process MAC or Cherwell forms as needed to transfer assets between users or departments.
Work Hours: Monday - Friday, 8:00 a.m. - 5:00 p.m.
About You
Minimum Qualifications:
- Bachelor’s Degree from an accredited college or university in Public Administration, Business, Finance, Planning, Industrial/Engineering Technology, or job-related field and 2 years job-related experience.
- OR- 6 years of professional job-related experience can be substituted at management discretion for the required education.
- OR – Related professional program/project management may be substituted for the required education at management discretion.
Preferred Qualification:
- Working knowledge in spreadsheets, databases, and document management. Specifically, Microsoft Excel, Microsoft Power BI Desktop and Power BI Reports.
About Everything Else
Starting Pay Range: $51,542.40 - $60,008.00
Position Salary Range: $51,542.40 - $87,027.20
Employee Type:
Regular (Budgeted)
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!
- Utilize our award-winning wellness program including free gyms and classes 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!)
A different blend of voices prompt better conversations, choices and results for everyone. Sarasota County – Many Voices, One Team.
Diversity, equity and inclusion (DE&I) are the keys to serving, representing and understanding our community. We celebrate and value the experiences, backgrounds, perspectives, talents and strengths that make us different and are committed to creating a culture of understanding and respect where our employees realize that we are stronger together.
Our vision is to have a diverse, equitable and inclusive workplace that attracts, develops, retains and engages a talented workforce broadly representative of the citizens and communities we serve. To further value creativity, innovation, collaboration and great customer service – internally and externally.
Sarasota County Government promotes diversity and inclusion in its workforce and does not discriminate on the basis of race, color, gender identity or expression, genetic information, religion, national origin, marital status, age or disability. A job applicant with a disability who requires reasonable accommodation to participate in the application/selection process is requested to make known the need for an accommodation to Human Resources or appropriate county staff members. For assistance with the application, please call 941-861-5353.
Government employers are drug-free and tobacco-free environments, EEO/AA/ADA employers, and they prohibit discrimination in all services, programs or activities.
Sarasota County Government is a
Tobacco-Free/Drug-Free
Workplace.
seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.