Supply Chn Bus Analyst Prin

W3R Consulting; Columbus (OH); Hybrid; USD 110,000 - 190,000; Full time

Job summary

W3R Consulting seeks an experienced data analytics consultant to design and optimize data queries, build robust warehouse structures, and automate processes with Python.

You will create executive dashboards in Power BI, combine data from diverse sources, and collaborate with cross-functional teams to turn business questions into actionable insights.

Qualifications

• Bachelor's degree required in Supply Chain, Finance, Accounting, IT or related field with 10+ years in relevant areas.
• Alternative: Associate degree with 12+ years in Supply Chain, Procurement, Fleet or IT.
• Alternative: High School Diploma with 14+ years in the same domains.

Responsibilities

• Design, write, and optimize complex queries across multiple data marts and sources.
• Design and build warehouse tables for accurate downstream reporting.
• Apply Python to support data transformation and automation.
• Leverage AI tools to enhance data analysis and reporting quality.
• Create executive-ready Power BI dashboards by integrating data from multiple sources.
• Collaborate with stakeholders to translate business questions into data models and visuals.
• Investigate data to identify trends, anomalies, and improvement opportunities.

Skills

SQL Queries

Data Modeling

Python

Power BI

AI Tools

Leadership

Cross-Functional Collaboration

Education

Bachelor's degree in related field

Associate degree in related field

High School Diploma

Tools

MS Office

Job description

Job Description

Work independently. Provide consultation and instruction to internal personnel regarding performance, financial reporting, benchmarking and advanced report development. Develop data models and identify optimal solutions. Develop, facilitate and lead strategic and collaborative cross-functional implementation plans. Demonstrate superior problem-solving skills and serve as the highest-level resource in that area within the organization. Provide strategic direction and subject matter expertise regarding systems, processes and initiatives and follow through from development to full implementation. Prepare and deliver executive reporting and presentations. Mentor and lead assigned work activities of others within the work group, team, or department.

ESSENTIAL JOB FUNCTIONS

• Design, write, and optimize complex queries spanning multiple data marts and tables to extract, join, and reconcile data from disparate source systems.
• Design and build warehouse tables that serve as accurate, well-structured foundations for downstream reporting and analysis.
• Apply Python to support data transformation, process automation, and analytical workflows.
• Leverage artificial intelligence tools and techniques to enhance the speed, quality, and depth of data analysis and reporting.
• Connect and integrate data from multiple sources to build polished, executive-ready Power BI dashboards.
• Partner with stakeholders across the organization to translate business questions into well-structured data models and visualizations.
• Proactively investigate underlying data to identify trends, anomalies, and opportunities for improvement.

MINIMUM REQUIREMENTS

• Bachelor's degree in Supply Chain Management, Business Finance, Accounting, or related field of study such as Operations Management, Materials Management, or Information Technology. In addition, must have a minimum of 10 years of experience in Supply Chain, Procurement and Fleet or related business category such as Operations Management, Materials Management, or Information Technology.
• In lieu of Bachelors degree must possess an Associates Degree in related field of study, and a minimum of 12 years experience in Supply Chain, Procurement and/or Fleet or related business category such as Operations Management, Materials Management, or Information Technology.
• In lieu of Associates degree must possess a High School Diploma or equivalent, and a minimum of 14 years experience in Supply Chain, Procurement and/or Fleet or related business category such as Operations Management, Materials Management, or Information Technology.

OTHER REQUIREMENTS

• Lead cross-functional teams, identify stakeholders, and network with internal and external organizations.
• Seek to broaden knowledge in areas of the company and industry which will complement acquired expertise.
• Project credibility and competence regarding data analysis Demonstrate excellent verbal and written skills, possess highly-developed presentation skills.
• Demonstrate the highest standards of ethical behavior and support the Company's Corporate Code of Conduct.
• Demonstrate expert level of knowledge of MS-Office skills.