Job summary
Job post source
This job is from a recruiting firm hiring for a separate company
Job overview
The Data Analyst - Purchasing/BoM role involves analyzing procurement-related data to provide actionable insights and support category management and Bill of Materials processes for a respected company.
Responsibilities and impact
The analyst will collect and compile data from multiple sources, perform complex data analysis and reporting, and present insights and recommendations to stakeholders to aid decision-making.
Compensation and benefits
The position offers $45/hr on a W2 contract basis, remote work within Central Time Zone, with occasional travel to Chicago office quarterly; no additional benefits mentioned.
Experience and skills
Required skills include proficiency in Excel/Google Sheets (pivot tables, modeling), Tableau (dashboard creation, data blending), SQL or similar querying tools, and data integration from Agile, BOM, and Google Sheets.
Career development
The job description suggests opportunities for adding value and career growth aligned with the candidate's experience.
Work environment and culture
The role supports remote work within the Central Time Zone with quarterly visits to a corporate office in Chicago, indicating a flexible but collaborative environment.
Company information
The job is for a highly known and respected company with corporate offices in downtown Chicago, engaged through Prairie Consulting Services.
Job location and travel
Remote work required within Central Time Zone states with quarterly visits to the Chicago office.
Unique job features
The role involves working with diverse datasets like historical spend, demand profiles, and Bill of Materials, delivering actionable insights on tariff impacts, and requires stakeholder presentations.
Company overview
Prairie Consulting Services is a management consulting firm specializing in providing strategic solutions to businesses across various industries. They generate revenue through consulting fees, offering services such as business strategy, operational improvement, and technology integration. Founded in 2005, the company has built a reputation for delivering tailored, data-driven insights that help clients achieve sustainable growth. Key historical milestones include expanding their service offerings and establishing a strong presence in North America.
How to land this job
Tailor your resume to emphasize your proficiency in Excel/Google Sheets with pivot tables and modeling, Tableau dashboard creation and data blending, and SQL querying skills, as these are critical for the Data Analyst role at Prairie Consulting Services.
Highlight your experience with data integration from diverse sources such as Agile, Bill of Materials, and Google Sheets, and your ability to analyze historical spend and demand profiles to deliver actionable insights, especially related to procurement and tariff impacts.
Apply through multiple channels including Prairie Consulting Services' corporate career site, LinkedIn job postings, and reputable job boards to maximize your application visibility for this W2 contract position.
Connect with current employees in the procurement or data analytics divisions at Prairie Consulting Services on LinkedIn; use ice breakers like commenting on recent company projects related to procurement analytics or asking about the impact of tariff data on their reporting workflows.
Optimize your resume for ATS by incorporating keywords from the job description such as 'pivot tables,' 'Tableau dashboard creation,' 'SQL querying,' 'data integration,' 'historical spend,' and 'procurement analytics' to ensure it passes initial automated screenings.
Leverage Jennie Johnson's Power Apply feature to automate tailored resume customization, identify multiple application portals, and find LinkedIn contacts for networking, allowing you to focus more on preparing for interviews and strategic networking.
Jennie Johnson works for you!
Here’s what we do to make sure you’re successful:
Targeted Resume Revamp:
We expertly craft your resume to navigate Applicant Tracking Systems (ATS) and showcase your qualifications, making you stand out as a top-tier candidate.
Job Description Dissection:
Unpack the job posting with expert analysis, ensuring your application hits every key requirement.
Bespoke Cover Letter:
Capture the attention of hiring managers with a personalized cover letter that highlights how your skills align perfectly with the job's needs.
Interview Mastery:
Prepare for interviews like a pro with likely questions, strategic answers, and insightful questions for you to ask, setting you apart as an informed candidate.
Direct Application Insights:
Receive tailored advice on the best places to apply, ensuring your applications are seen by the right employers.
Skills and Gaps Assessment:
Identify and close critical skills gaps to position yourself as the best-fit candidate for your ideal job.
Personalized Email Pitch:
Make a memorable first impression with an email template crafted to engage potential employers and initiate meaningful conversations.
In-depth Research Guide:
Leverage comprehensive research tools to gather effective insights on companies, industry trends, and role-specific challenges.
Detailed Company Analysis:
Gain in-depth understanding of your prospective employer, giving you the edge in applications and interviews.
Strategic Candidate Overview:
Understand your unique value and why companies would want to interview you, highlighting your background and positioning.