Business Intelligence Specialist

MacLean-Fogg Company; Mundelein (IL); Hybrid; USD 75,000 - 85,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401(k) with company match

Paid time off

Tuition reimbursement

Job summary

MacLean-Fogg is seeking a Business Intelligence Specialist in Mundelein, IL to design, develop, and maintain reporting supporting financial, operational, and supply chain decisions.

You will build Power BI, ReportsNow, SQL, and ERP reporting while collaborating with business users to define requirements and enable a centralized data warehouse. Flexible arrangement; near Mundelein preferred.

Qualifications

• Bachelor’s degree or equivalent in information systems, analytics, CS, finance, or engineering.
• 2–4 years of experience developing production reports and dashboards.
• Hands-on Power BI experience incl. data modeling, DAX, Power Query, and publishing to a shared workspace.
• Proficient SQL writing with multi-table joins, aggregation, and performance tuning.
• Experience building reports against transactional systems; understanding of operational data structure.
• Ability to elicit requirements from non-technical users and translate to technical specs.
• Strong communication of data concepts to business users.
• Detail-oriented with ability to validate work before release.
• Ability to manage multiple requests and set priorities.

Responsibilities

• Design, develop, test, and deploy Power BI reports and dashboards with data modeling and DAX.
• Maintain reports in ReportsNow and JD Edwards reporting toolset, including distributions and drill-downs.
• Write and tune SQL queries against JD Edwards tables and SQL Server databases.
• Collaborate with finance, operations, and supply chain to gather requirements and translate into specs.
• Standardize report design, naming conventions, and data definitions across units.
• Support migration to a centralized data warehouse with portfolio rationalization.
• Develop and maintain semantic models and shared datasets for self-service reporting.
• Maintain and troubleshoot the existing report portfolio with performance tuning.

Skills

Power BI

SQL

Data visualization

Requirements gathering

Communication

Education

Bachelor’s degree in Information Systems, Business Analytics, CS, Finance, Engineering, or related field

Tools

ReportsNow

JD Edwards

SQL Server

Data modeling

Job description

Job Summary

MacLean-Fogg is hiring a Business Intelligence Specialist to design, develop, and maintain reporting that supports financial, operational, and supply chain decision-making. You’ll build and improve Power BI, ReportsNow, SQL, and ERP reporting while partnering with business users to define requirements and support the transition to a centralized data warehouse. This role offers a flexible work arrangement, with preference for candidates near Mundelein, IL or Detroit, MI and remote work considered for the right candidate.

• Location: Preference for candidates near Mundelein, IL or Detroit, MI
• Work Arrangement: Flexible; on-site, hybrid, or remote depending on the candidate
• Schedule: Standard business hours
• Pay: $75,000–$85,000/year
• Employment Type: Full-time / Salary
• Travel: Up to 10%

What You’ll Do as a Business Intelligence Specialist

• Design, develop, test, and deploy Power BI reports and dashboards, including data modeling, DAX measure development, visualization design, and publishing to shared workspaces.
• Develop and maintain reports in the company’s JD Edwards reporting toolset, ReportsNow, including scheduled distributions and drill-down reporting for operational users.
• Write, test, and tune SQL queries against JD Edwards tables and SQL Server databases to source, shape, and validate report data; resolve data discrepancies and improve query and report performance.
• Partner with functional end users, business analysts, and finance, operations, and supply chain teams to gather reporting requirements, translate business needs into documented technical specifications, review draft reports, incorporate feedback, and confirm acceptance.
• Apply consistent standards for report design, naming conventions, and data definitions across business units and manufacturing locations, while identifying duplicate or overlapping requests and recommending consolidation when appropriate.
• Support the migration and rebuild of existing Power BI reports as the organization transitions from a third-party data model to a centralized data warehouse, including report portfolio rationalization and defining reporting requirements for data engineering.
• Develop and maintain semantic models and shared datasets that support self-service reporting, and document report logic, data sources, business definitions, and change history.
• Maintain and troubleshoot the existing report portfolio, including performance tuning and updates as business processes, master data, and source systems change.

What You’ll Bring

Required Qualifications

• Bachelor’s degree in Information Systems, Business Analytics, Computer Science, Finance, Engineering, or a related field, or an equivalent combination of education and directly related experience.
• Two to four years of experience developing production reports and dashboards in a business environment.
• Demonstrated hands-on experience with Power BI, including data modeling, DAX, Power Query, report design, and publishing to a shared workspace.
• Demonstrated proficiency writing SQL, including multi-table joins, aggregation, and query performance troubleshooting.
• Experience developing reports against a transactional business system and a working understanding of how operational data is structured.
• Ability to elicit reporting requirements from non-technical users and translate them into technical specifications.
• Ability to communicate data concepts and report results clearly to business and operational audiences.
• Strong attention to detail and demonstrated experience independently validating work products before release.
• Ability to manage multiple concurrent requests, establish priorities, and communicate realistic delivery timelines.
• Ability to learn new reporting platforms and ERP data structures, including JD Edwards and ReportsNow, through on-the-job training.
• Ability to work independently with limited supervision and collaboratively within a cross-functional team.
• Working knowledge of Microsoft Office applications, including advanced Excel functionality.
• Ability to handle confidential financial and personnel data with discretion.

Work Environment & Physical Requirements

• Work is primarily performed in an office environment and involves remaining in a stationary position for extended periods while operating a computer.
• The role requires the use of standard office equipment and communication by telephone, video conference, and electronic mail.
• Occasional visits to manufacturing facilities may be required, where personal protective equipment and adherence to plant safety procedures are required.

The physical requirements described above represent those needed to perform the essential functions of the position, with or without reasonable accommodation.

Benefits

Eligible employees across MacLean-Fogg and its affiliated companies have access to a comprehensive benefits program designed to support health, financial well-being, time away, and development. This position is eligible for benefits that include:

• Medical, dental, and vision coverage
• 401(k) with company match and potential profit sharing
• Paid time off and paid holidays
• Health Savings Account contributions for eligible plans
• Company-paid life insurance and short-term disability coverage
• Paid parental leave
• Employee Assistance Program and mental health resources
• Virtual healthcare resources
• Tuition reimbursement and development opportunities
• Additional wellness, financial, and employee programs

Benefits are subject to applicable plan terms and eligibility requirements.

Explore our full benefits and interactive resources: https://explore.benefits.macleanfogg.app

Pre-Employment Requirements

After a conditional offer, this position requires a pre-employment drug screen and criminal background check. Screening and employment decisions are administered consistent with applicable law and the requirements of the position.

About MacLean-Fogg

MacLean-Fogg is a fourth-generation, family-owned American manufacturing company headquartered in Mundelein, Illinois. Founded in 1925, we design and manufacture engineered components and solutions for automotive and industrial markets.

Our portfolio includes MacLean-Fogg Component Solutions, OMCO, Mallard Manufacturing, and Threadstrong. Across our companies, we share a commitment to Integrity, People, Customers, and Stewardship while investing in our people, manufacturing capabilities, customers, and communities.

Equal Employment Opportunity & Accommodations

MacLean-Fogg and its affiliated companies are equal opportunity employers. We provide equal employment opportunities to qualified applicants and employees without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, ancestry, age, disability, genetic information, military or veteran status, marital status, or any other characteristic protected by applicable law.

If you need a reasonable accommodation to apply, complete an assessment, or participate in the hiring process, contact [e-mail].