Data Analyst III

Carex Consulting Group

Lenexa (KS)

Hybrid

USD 90,000 - 120,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Carex Consulting Group in the Kansas City area is seeking an experienced Data Analyst III to transform complex business requirements into actionable insights. You will develop SQL queries and Power BI dashboards and support operational decision-making across manufacturing and purchasing.

The role emphasizes data modeling and ERP data sources such as Acumatica, collaborating with operations, engineering, and cross-functional teams to drive data-driven improvements in smart manufacturing

Qualifications

  • 5+ years in data analytics or BI, ideally at Data Analyst III level.
  • Strong SQL: write complex queries and data extraction.
  • Expert in Power BI dashboards and reports.
  • Knowledge of relational data modeling (fact/dimensions).
  • Experience with ERP systems such as Acumatica.

Responsibilities

  • Partner with operations, manufacturing, engineering, and purchasing stakeholders to gather business requirements and translate them into technical and analytical solutions.
  • Write, optimize, and execute SQL queries to extract, organize, and analyze data supporting business operations and reporting needs.
  • Design, develop, and maintain interactive Power BI dashboards and reports to improve operational visibility and support data-driven decision-making.
  • Build dashboards utilizing high-frequency machine data to monitor equipment performance, operational concerns, and maintenance schedules within advanced smart manufacturing facilities.
  • Collaborate with cross-functional stakeholders to identify reporting opportunities, streamline analytical processes, and improve operational efficiency.
  • Translate complex technical findings into clear, actionable insights for manufacturing, construction, and other nontechnical stakeholders.

Skills

SQL
Power BI
Data Modeling
ERP Systems
Requirements Gathering
Manufacturing Analytics

Tools

Acumatica

Job description

Data Analyst III
Summary

Carex is partnering with a leading engineering and constructionindustry partner to identify an experienced Data Analyst III to transform complex business requirements into actionable insights and data-driven reporting solutions. This individual will collaborate with operations, manufacturing, engineering, and purchasing stakeholders to develop SQL queries, build Power BI dashboards, and support operational decision-making across advanced smart manufacturing environments.

The ideal candidate brings strong SQL and Power BI expertise, a solid understanding of data modeling concepts, and experience supporting manufacturing or supply chain operations. This role requires a proactive, collaborative professional who can quickly understand business needs, develop effective analytical solutions, and communicate insights to both technical and nontechnical stakeholders.

What You'll Do
  • Partner with operations, manufacturing, engineering, and purchasing stakeholders to gather business requirements and translate them into technical and analytical solutions.
  • Write, optimize, and execute SQL queries to extract, organize, and analyze data supporting business operations and reporting needs.
  • Design, develop, and maintain interactive Power BI dashboards and reports to improve operational visibility and support data-driven decision-making.
  • Build dashboards utilizing high-frequency machine data to monitor equipment performance, operational concerns, and maintenance schedules within advanced smart manufacturing facilities.
  • Apply data modeling concepts, including fact and dimension tables, to organize and retrieve data efficiently for reporting and analysis.
  • Collaborate with cross-functional stakeholders to identify reporting opportunities, streamline analytical processes, and improve operational efficiency.
  • Translate complex technical findings into clear, actionable insights for manufacturing, construction, and other nontechnical stakeholders.
  • Coordinate with the broader data and analytics team to prioritize business requests, distribute analytical tasks, and deliver reporting solutions.
  • Utilize ERP system data to support business intelligence, operational reporting, and process improvements.
  • Work closely with manufacturing personnel to understand equipment performance, operational workflows, and business challenges.
  • Participate in onsite stakeholder meetings 1-2 days per week for Kansas City-based candidates while collaborating virtually with the broader analytics team.
What You'll Bring
  • Strong professional experience in data analytics, business intelligence, or a related field, ideally at a Data Analyst III or senior-level capacity.
  • Advanced proficiency in SQL, including independently writing complex queries, extracting data, and translating business requirements into analytical solutions.
  • Demonstrated expertise in Power BI, including designing, developing, and maintaining interactive dashboards and reporting solutions.
  • Solid understanding of relational data modeling concepts, particularly fact and dimension tables, and their application in organizing and retrieving data.
  • Experience gathering business requirements and translating them into technical specifications and actionable reporting solutions.
  • Experience working with ERP systems, such as Acumatica or similar platforms, highly preferred.
  • Previous experience supporting manufacturing, supply chain, or advanced smart manufacturing environments strongly preferred.
  • Familiarity with high-frequency machine data, equipment monitoring, or operational performance analytics preferred.
  • Exposure to telematics systems or industrial equipment data, including Trumpf or Lincoln machinery, considered a plus.
  • Strong analytical and problem-solving skills with the ability to independently evaluate business challenges and recommend effective solutions.
  • Excellent verbal and written communication skills, with the ability to explain technical concepts to manufacturing, construction, and other nontechnical stakeholders.
  • Collaborative mindset with the ability to work effectively across multiple business functions and distributed teams.
  • Ability to manage competing priorities, take ownership of deliverables, and contribute immediately in a fast-paced operational environment.

Carex Consulting Group is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity, or Veteran status. #LI-WR1

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analyst - SQL & Power BI for Manufacturing
Senior Data Analyst - SQL & Power BI for Manufacturing

Carex Consulting Group • Lenexa (KS)

Hybrid
USD 90,000 - 120,000
Data Analyst
Data Analyst

The Timberline Group • St. Louis (MO)

On-site
USD 65,000 - 100,000
Senior Manufacturing Operations & Digitalization Analyst
Senior Manufacturing Operations & Digitalization Analyst

Yanfeng Global Automotive Interiors • Novi (MI)

On-site
USD 90,000 - 120,000
Data Analyst - Manufacturing
Data Analyst - Manufacturing

BAKER GROUP • Ankeny (IA)

On-site
USD 70,000 - 100,000
Sr Data Specialist
Sr Data Specialist

ADP, Inc. • Niles (IL)

On-site
USD 44,000 - 52,000
Manufacturing BI Analyst - Real-Time Dashboards
Manufacturing BI Analyst - Real-Time Dashboards

Baker Group • Ankeny (IA)

On-site
USD 70,000 - 100,000
Manufacturing Business Analyst
Manufacturing Business Analyst

The Panther Group • New Haven (CT)

On-site
USD 85,000 - 110,000
Data Warehouse & BI Engineer
Data Warehouse & BI Engineer

Compunnel Inc. • Charlotte (NC)

On-site
USD 95,000 - 140,000
Sr. Data Analyst
Sr. Data Analyst

Tangerine Search Inc. • New York (NY)

On-site
USD 80,000 - 110,000
Comprehensive benefits
Opportunities for professional growth
Data Warehouse & BI Engineer — Flexible Hours
Data Warehouse & BI Engineer — Flexible Hours

Compunnel Inc. • Charlotte (NC)

Hybrid
USD 95,000 - 140,000