Energy Jobline is the largest and fastest growing global Energy Job Board and Energy Hub. We have an audience reach of over 7 million energy professionals, 400,000+ monthly advertised global energy and engineering jobs, and work with the leading energy companies worldwide.
We focus on the Oil & Gas, Renewables, Engineering, Power, and Nuclear markets as well as emerging technologies in EV, Battery, and Fusion. We are committed to ensuring that we offer the most exciting career opportunities from around the world for our jobseekers.
Job DescriptionJob Description
Midwest Salt is growing—and data is central to how we scale smarter.
We’re seeking a Business Systems & Data Analyst who is equal parts analyst and builder. You’ll own the SQL queries, dashboards, and reports that drive leadership decisions - while also designing the data infrastructure that connects SAP Business One with our logistics, tax, pricing, and ecommerce systems into a single source of truth.
What You’ll Do
- Build, optimize, and maintain complex SQL queries against the SAP HANA database
- Develop dashboards and reports using Power BI and SAP Crystal Reports
- Design and build a centralized data lake that consolidates data from SAP and all integrated systems
- Create and maintain automated ETL pipelines using Python and SQL
- Translate ERP business processes (order-to-cash, procure-to-pay, inventory) into analytical models
- Maintain and evolve pricing, cost, and margin models within the ERP environment
- Design and build User Defined Objects, Tables, and Fields in SAP B1
- Troubleshoot and validate data from system integrations, add-ons, APIs, and EDIs
- Design data quality checks, reconciliation controls, and exception reporting
- Define, document, and govern metric definitions and business logic
- Deliver insights, forecasts, and scenario analysis to leadership
- Train end users and promote a data-driven culture across the organization
What You’ll Enjoy
- Owning analytics that directly influence leadership decisions
- Building data infrastructure from the ground up
- Working with real integrations and real complexity
- High visibility, cross-functional impact, and room to innovate
- Being part of a growing company with a long-term investment in data and technology
What You’ll Bring
Required
- Advanced SQL proficiency, including use of CTEs for multi-step logic, window functions for line-level analytics, and complex joins across ERP document lifecycles.
- Python (or similar) for data analysis, automation, and ETL pipelines
- Experience with BI tools (Power BI, Tableau, SAP Analytics Cloud, or similar)
- Experience working with transactional ERP data
- Strong analytical thinking and problem-solving skills
- Ability to translate business questions into clear data and reporting logic
- Strong communication skills across technical and non-technical audiences
- Bachelor’s degree in Analytics, Information Systems, or Computer Science
Strongly
- Hands-on experience with SAP ERP (SAP Business One or S/4HANA)
- Experience with data lakes, data warehouses, or centralized data repositories
- Experience building or maintaining SAP Crystal Reports
- Familiarity with API integrations and troubleshooting data flows between systems
- Experience with logistics or TMS platforms (McLeod, Descartes, or similar)
- Experience with Avalara AvaTax or similar tax compliance platforms
- Pricing, cost modeling, margin, or supply chain analytics
- Familiarity with data governance or master data management
Why Midwest Salt
At Midwest Salt, we’ve built our reputation on three commitments: premium quality products, competitive pricing, and reliable on-time delivery. Our foundation is our people.
We believe in win-win relationships—with customers, vendors, and team members alike. Your ideas matter here. We foster collaboration, innovation, and continuous learning, and we value people who take ownership and think critically about how the business runs.
Position Details
- Salary: $80,000–$88,000 (bonus eligible)
- Location: On-site, West Chicago, IL
- Schedule: Monday–Friday, 8:00am–4:30pm (April–September) / 7:30am–5:30pm (October–March). Flexibility during winter events is required.
- Benefits: 401(k) with company matching, company-paid employee and partial family health and dental insurance, vision insurance, company-paid life insurance, supplemental life insurance, company-paid short- and long-term , vacation days, PTO, and bonus days off.
Apply Today
If you’re a Business Systems or Data Analyst who wants to build real data infrastructure and turn ERP data into impact, we’d love to connect. Apply today and help shape the future of Midwest Salt through analytics and insight.
Keywords: SAP Business One, SAP HANA, SQL, Python, Data Lake, ETL, Power BI, Crystal Reports, ERP Data Analyst, Business Systems Analyst, Data Engineer, McLeod TMS, Avalara, Supply Chain Analytics
If