Sql data analyst Jobs in Sioux Falls, SD

Job Title

We're looking for a self-motivated, relationship driven professional who's ready to help power the work that keeps our city running. In this role, you'll deliver high-level strategic procurement and business support to departments across the organization, leading efforts in project coordination, vendor management, budget and forecasting, analyzing supply costs, and implementing smart use of technology to help us work better and faster.

You'll work closely with our Public Works utility and general government teams making sure they have necessary supplies, services and equipment, when they need them to ensure operational and business needs are met.

If you thrive in a collaborative environment, enjoy solving problems, motivated in utilizing technology, and want to make a meaningful impact on how our city serves the community, this is a place where your drive and talent will shine.

Job Responsibilities

1. Collaborate with departmental personnel and lead strategic centralized procurement services, develop contracts, bid specifications, and author requests for proposals and agreements for the procurement of equipment, supplies, and services.

2. Ensure compliance of requisitions, bids, and proposals with all regulations. Verify availability of funds and corresponding budgets and appropriate approvals have been completed. Maintain detailed and organized records to ensure the City's position is well-documented.

3. Lead major complex procurement projects, in coordination with multiple departments, negotiate contracts and assist drafting agreements.

4. Develop and maintain a network of supplier relationships hold suppliers and contractors accountable for compliance with specifications, plans, delivery timelines, and pricing. Facilitate the resolution of problems and issues arising from the purchase of equipment, supplies, and services. Implement and provide support for the utilization of the City's procurement applications, including end-user training and troubleshooting.

5. Facilitate comprehensive procurement services, adhere to all regulations, conduct pre-bid conferences, address inquiries on bids or proposals, coordinate and communicate responses, and recommend course of action for both internal and external stakeholders. Compile, analyze, communicate, and document bid results and prepare internal reports.

6. Review, tabulate, evaluate, document price quotes, bid and request proposals, bid specifications, and construction documents. Ensure specifications or qualifications are compliant with regulations and make recommendations and facilitate selection meetings.

7. Develop and lead strategic contracts and inventory management best practices, maintain an awareness of supply chain, communicate status with departmental partners, and ensure efficient and cost-effective service delivery. Conduct research, evaluate vendors, conduct cost-benefit analysis to find suitable supply options, and recommend and approve suppliers.

8. Collaborate with departments to establish annual and multi-year purchasing contracts to ensure timely delivery of equipment, supplies, and services. Provide departmental support to ensure utilization of the City's procurement and financial software applications, including end-user training, troubleshooting user technical issues, and assisting with data entry or account setups.

9. Oversee fulfillment of orders including order tracking, service fulfillment, monitoring vendor or supplier performance, following up on warranties and service agreements, completing pricing revisions and order cancellations, and resolving product or invoice discrepancies.

10. Provide coordination support with departments to lead purchasing logistics for disasters and FEMA events. Support the disposal of the City's surplus property and the annual surplus property auction.

11. Perform other such duties and functions as are outlined for this position in the departmental position result description and performance standard.

Minimum Qualifications

Graduation from an accredited college or university with a bachelor's degree in business administration, finance, economics, or other specialized discipline and a minimum of three (3) years' experience in purchasing, contract, and bid activities; or any such combination of education, experience, and training as may be acceptable to the hiring authority.

Supplemental Information

• Knowledge of purchasing processes and methodologies.

• Knowledge of business practices related to contract law and applicable rules and regulations that govern competitive public bidding processes and purchasing.

• Knowledge of purchasing software systems and personal computer business software applications.

• Ability to prepare procurement reports and detailed bid specifications.

• Ability to make accurate mathematical and statistical calculations.

• Ability to establish and maintain effective working relationships with coworkers and vendors.

• Ability to communicate effectively, both orally and in writing.

• Ability to analyze bids and proposals.

• Ability to maintain confidentiality and integrity of the Finance department.

• Ability to demonstrate strong project management skills.