Parts & Service Fleet Bid Analyst/Data Analyst

In this position...

The Parts & Service Fleet Bid Analyst will take ownership of the entire government bid process to include researching all government bids, all awarded contracts, tracking all government bid data and ultimately, automating the reporting to summarize the data. They will also work closely with Ford Customer Service Division Team & Ford Pro Team to secure these contracts. Strong growth potential within the Ford Pro or Ford Customer Service Division. Prefer candidates in Detroit Area, but willing to consider all options (near a Ford Regional Office) and recent graduates will be considered.

ResponsibilitiesWhat you'll do...

We are seeking a highly analytical professional with strong programming skills and the ability to drill down into data and provide actionable analysis. (3-5 years of experience)

Assume ownership for all bid contract proposals to ensure all bid specifications, deliverables and milestones are met weekly Ability to take ownership of undefined projects and innovate or automate quickly with minimal supervision under tight deadlinesAbility to review contracts and find gaps in compliance quickly Excellent research skills to stay up-to-date with local, state and federal automotive RFPs Identify and automate bid/RFP summary documents for the Field Team to use and distribute Compile all data and automate weekly bid reports for the Field Team or Management Team in all sales channels Monitor assigned organization's expenditures against set budgets while preparing accurate management reports that estimate future financial needs Analyze and validate data for National Incentive payouts Work on multiple proposals or projects simultaneously and communicate the progress to management Manage inputs from a variety of stakeholders in Ford Customer Service Division and Ford Pro on upcoming Government RFP & Contract opportunities (to include conducting quarterly business reviews)Meet with state and local government procurement officials to build relationships Attend and conduct training workshops focused on how to do business with the government agenciesAttend mandatory government agency Pre-Bid meetings Submit questions on behalf of the team to government agencies Organize meetings with market area teams and dealers to review larger bid opportunities Assist and Train Dealerships or Ford Authorized Distributors with their proposed bid responses and provide input Research all awarded contracts and track all data (Ford Dealers or competitors) Conduct post bid reviews with the FCSD Teams & Ford Pro Teams Attend local trade shows and conferences Promote FCSD Programs, Ford Pro Fleet Service Operations programs, Ford Pro Commercial Vehicle Center Programs QualificationsYou'll have...

Bachelor's degree in Business, Economics, Statistics, Supply Chain Management or Business Data ScienceStrong analytical and programming skills, with the ability to investigate complex data, identify meaningful trends, and deliver clear, actionable analysis (3-5 years of experience)Advanced proficiency in Microsoft Excel, Word, PowerPoint, Access, Power BI, and Power Automate; able to produce accurate, polished deliverables with minimal guidance (3-5 years of experience)Excel programming experience for Data Preparation, KPI Development, and Dashboard Creation (3-5 years of experience)Experience with GovWin/Deltek, Bid Prime, Bid Net and other RFP/bid platforms preferred (2-3 years of experience)Automated data extraction using Python is preferred Proficient with CRM software (Salesforce) to manage customer relationships, track sales, and analyze customer data