- The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Cat Products.
- The BOM analyst will use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure.
- This will require strong SQL skills and occasional use of script languages and regular expressions.
- The analyst will also validate that they BOM data was successfully transformed and stored.
- They will also use their knowledge of Products and mechanical components to validate the completeness of BOM Data.
- The BOM Analyst will work with the As-Built BOM manager to determine the proper methods to achieve results.
- Write SQL queries to cleanse and transform historical Bill of Material data into a structured format.
- Validate Bill of Material data is accurate and properly structured.
- Validate completeness of Bill of material data. Knowledge of products and mechanical components will be necessary.
- Thorough knowledge of Caterpillar Inc.; its products and services
- Team of 2-3, occasionally including someone who works in ACM/coding.
- Hybrid model
- Bachelor's Degree with 2-4 years' experience.
- Associates/ No college degree with a minimum of 6+ years of experience in this capacity.
- SQL experience (2-4 years at a minimum).
- Experience with CAT products.
- Ability to work independently and manage one's time.
- SQL, Snowflake
- Scripting experience in Perl, Python, R or Regular expressions are bonuses.
- Experience with product structure and engineering bill of materials
- Knowledge of Cat products and components to validate the completeness of engineering bill of materials
- Verbal and written communication skills, problem solving skills, customer service and interpersonal skills.
- If the candidate's location is not listed on the resume, the candidate will be DQ.
- If the candidate does not currently reside in the Peoria, IL area but will relocate at their own expense, make sure to list that on the resume or they will be DQ.
- If candidate resume contains choppy tenure ( 1 year of less) without listening if it was project only role, they will not be considered.
-
Data Validation Analyst
2 weeks ago
HarveyNash USA Peoria, United StatesThe main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Client Products. · - The BOM analyst will use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure. · - This will require strong S ...
-
Business Data Analyst
2 weeks ago
Diversified Services Network Peoria, United StatesDiversified Services Network, Inc. (DSN) is seeking a full-time **Technical Business Systems Analyst **to join our team in **Peoria, IL **We offer a **HYBRID** work model, full benefits, PTO, 401k, and more If you're looking to grow your technical career within an extremely reput ...
-
Data Analyst
1 day ago
Diversified Services Network Mossville, United StatesDiversified Services Network, Inc. (DSN) is seeking a full-time **App Programmer **to join our team in **Mossville, IL **We offer a **FULLY REMOTE** work model, full benefits, PTO, 401k, and more If you're looking to grow your technical career within an extremely reputable, stabl ...
-
Data Analyst
1 week ago
Harvey Nash Peoria, United StatesThis data analyst resource will be a point person on the data request process as well as a resource from IASB on the reports in IEES or the Data Warehouse (SSRS reports, Business Intelligence reports, etc.). · This position will be responsible for collecting, processing, and ana ...
-
Data Analyst
5 days ago
US Main Peoria, United StatesPosition Title: Data Analyst · Location: Mossville, IL Onsite) · Contract W2 role · Top 3 Skills: Power BI, Excel Experience, Telematics · Position Description · Position's Contributions to Work Group: · • Support customer facing dashboards, troubleshoot data quality issues, doc ...
-
Data Analyst
2 weeks ago
Latitude36 Inc Peoria, United States contractCandidate Responsibilities This role is primarily responsible to collect and analyze major component removal and rebuild "ground truth" data. This includes adopting the existing process in place for Large Mining Truck (LMT) products and expanding the data collection and analysis ...
-
Data Analyst/ Business Analyst
2 weeks ago
Aditi Consulting Peoria, United StatesSummary: Looking for a Data Scientist, Business Analyst, or data Analyst to analyze their tech stack and data sources. · He would like this data analyst to produce a thesis on how they can display the data to help them tell a story and identify cost reduction opportunities. · Ba ...
-
Junior Data Analyst
2 weeks ago
Meridian Technologies Peoria, United StatesBill of Materials Analyst - 12-Month W2 Contract - HYBRID in Peoria · NO CORP TO CORP · Job Description · The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Products. The BOM analyst will use SQL in a Snowflake database to retrieve ...
-
Reimbursement Data Analyst
2 weeks ago
OSF Healthcare Peoria, United StatesOverview · Expected pay for this position is $ $33.46/hour. Actual pay will be determined by experience, skills and internal equity. · POSITION SUMMARY: The Reimbursement Data Analyst II is primarily responsible for ensuring accurate and timely payor reimbursement coding for assi ...
-
Business Data Analyst
2 weeks ago
Diversified Services Network Peoria, United StatesDiversified Services Network, Inc. (DSN) is seeking a full-time Technical Business Systems Analyst to join our team in Peoria, IL We offer a HYBRID work model, full benefits, PTO, 401k, and more If you're looking to grow your technical career within an extremely reputable, stable ...
-
Business Data Analyst
2 weeks ago
Diversified Services Network, Inc. Peoria, United StatesDiversified Services Network, Inc. (DSN) is seeking a full-time Technical Business Systems Analyst to join our team in Peoria, IL We offer a HYBRID work model, full benefits, PTO, 401k, and more If you're looking to grow your technical career within an extremely reputable, stable ...
-
Data Reporting Analyst
6 days ago
RLI Peoria, United StatesAbout Us · We're not like other insurance companies. From our specialty products to our business model, our culture to our results - we're different. Different is who we are, and how we work, interact, deliver and succeed together. Creating a different and better insurance expe ...
-
Power BI Developer/data Analyst
6 days ago
Harvey Nash Mossville, United States**Dev/Research Engineer ** · **Mossville, IL** · **24 months** · Position's Contributions to Work Group: · - Support customer facing dashboards, troubleshoot data quality issues, document requirements and lead meetings and give feedback to customers. · Why Client? · - Direct cust ...
-
Business Data Analyst, Aftermarket Insights
2 weeks ago
Caterpillar Peoria, United States Full timeCareer Area: · Business Technologies, Digital and Data · Job Description: · Your Work Shapes the World at Caterpillar Inc. · When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, prob ...
-
Data Analyst
5 days ago
Info Hightec Mossville, United StatesRequired Education & Experience: · • Bachelor's Degree · • 10+ years in leading data analytics team, data mining, development of customized reporting, project work (Analytical or Digital) · Required Technical Skills: · • PowerBI Experience · • Moderate Excel Experience · • Analy ...
-
Data Analyst
2 weeks ago
Saxon Global Mossville, United StatesResponsibilities Include:The Product Development Excellence, Quality and Cost team is focused on helping clients globally achieve product development success. By providing applications and training that enable product groups to collaborate with cross-functional teams, our platfor ...
-
Bom Analyst
2 weeks ago
Harvey Nash Peoria, United StatesThe main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Client Products. · - The BOM analyst will use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure. · - This will require strong S ...
-
Business Intelligence Analyst
2 weeks ago
Onward Technologies Inc. Peoria, United States**Business Intelligence Analyst / Data Analyst** · **Location: Peoria, Illinois** · **Hybrid Role** · **Pay Rate: $49.00 to $50.00 per hour** · You will love working as a Business Intelligence Analyst / Data Analyst in Peoria, Illinois. · This is a hybrid role and you will be abl ...
-
Invoice Analyst
2 weeks ago
HarveyNash USA Peoria, United StatesThe main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Client Products. · - The BOM analyst will use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure. · - This will require strong S ...
-
Bill of Material Analyst
2 weeks ago
optime-tech LLC Peoria, United States**Bill of Material (BOM) Analyst 3** · Peoria, IL (**HYBRID**) · 12+ Months Contract · **Primary Skills**: Snowflake, Business Analysis, Python, SQL · **Description**: · The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for the client's P ...
Junior Data Analyst - Peoria, United States - Meridian Technologies
Description
Bill of Materials Analyst - 12-Month W2 Contract - HYBRID in Peoria
NO CORP TO CORP
Job Description
The main function of the BOM Analyst is to cleanse and validate Bill of material (BOM) data for Products. The BOM analyst will use SQL in a Snowflake database to retrieve historical BOM data and transform it into an established structure. This will require strong SQL skills and occasional use of script languages and regular expressions. The analyst will also validate that they BOM data was successfully transformed and stored. They will also use their knowledge of Products and mechanical components to validate the completeness of BOM Data. The BOM Analyst will work with the As-Built BOM manager to determine the proper methods to achieve results.
Position's Contributions to Work Group:
Typical task breakdown:
Interaction with team:
Work environment:
Education & Experience Required:
Technical Skills
(Required)
Soft Skills
(Required)
Disqualifiers/Red Flags:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is required to use hands and fingers, reach, climb stairs, walk, sit for prolonged periods of time, talk, and hear. The employee must occasionally lift and/or move up to twenty-five pounds.