Business Intelligence Specialist
$75k - $85kMacLean Fogg
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:
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 View email address on click.appcast.io.
#J-18808-Ljbffr- ...specialties, and eager to propel themselves, our clients, and our business forward. We are one of the preeminent commercial real estate... ..., together. ABOUT THE ROLE The Analyst, Business Intelligence supports Savills’ capital project and program management (PPM)...SuggestedWork at officeRemote work
$70k - $80k
...consider candidates who are authorized to work in the United States without sponsorship. Job Summary Aaratech Inc. is seeking a Business Analyst – Banking & Financial Services to support business transformation initiatives within the financial services sector. In...Suggested- ...within Enterprise Operations, this role will translate strategic priorities into structured execution plans, coordinate work across businesses and functions, manage interdependencies and risks, and give leadership clear visibility into progress, decisions, and benefits....Suggested
- ...Work Mode: W2 only Primary Skills: Business Analyst, GxP, FDA, Quality Management Systems Regulations, FDA 21 CFR part 820 etc,. Required Qualifications and Experience: - 8 or more years as a Business Analyst in Life Sciences or Medical Device, or in a quality...Suggested
- ...Job Description Business Analyst MAFÉ Resources is partnering with a client in South Florida to hire a Business Analyst . This opportunity is ideal for someone who enjoys solving business problems, improving processes, and working across departments to turn...Suggested
$100k - $115k
...Job Description SENIOR BUSINESS ANALYST (RISK ANALYTICS) HYBRID - GREATER PHOENIX AREA $100,000 – $115,000 BASE + BONUS + FULL BENEFITS The Opportunity We’re partnering with a large, data-driven residential real estate platform operating at national...- ...Job Description A leading Bank is seeking a hands-on Senior Business Analyst to drive data-driven insights, process optimization, and digital workflow modernization across the bank’s Retail, Commercial, Corporate, Treasury, Payments, and Digital Banking businesses...
- ...operational excellence. They are recognized as one of the most trusted partners in the Private Capital industry. The role As Business Analyst, you will report to a Senior Consultant and join a high-impact consulting team delivering data and technology solutions to...
- ...Management Office. This is a great opportunity for an organized, curious, early-career professional with project management, PMO, or business analysis experience who wants to grow into technology portfolio governance and strategy. Our partner is investing significantly...Work at office2 days per week
- Job Description Our client is a large/well-known Private Equity Firm that invest primarily in Real Estate and Real Estate related investments, currently seeking to add a highly motivated Analyst/Senior Analyst to their growing Acquisition/Asset Management Team. This...
- ...Job Description JDE/E1 (EnterpriseOne) Software is a MANDATORY REQUIREMENT As Well As --- NO H1-B's The JDE/E1 Business Systems Analyst analyzes, enhances, and maintains application systems that support accounting & finance, project/job cost, capital asset management...Contract workWork at office
- ...Montreal, London, Brussels, Luxembourg, Geneva, Lisbon, Porto, Casablanca, Madrid and Singapore. We are looking for a Senior Business Analyst - Fixed Income eTrading for one of our clients, a leading investment bank based in New York. About the Role Join a...
- ...Job Description Senior Analyst, Strategy & Business Development Our Client Our client is an innovative insurance technology company transforming how sports organizations, brands, and businesses manage financial risk associated with promotional campaigns and...
- ...Job Description Job Title: Senior Business Analyst & Prompt Engineer (AI Skills) Location: New York City, NY (Hybrid – 3 Days Onsite per Week) Employment Type: Full-Time Job Summary: We are seeking a Senior Business Analyst & Prompt Engineer with strong...Full time3 days per week
- ...Job Description Job Title: Sr. Business Analyst – Life insurance Skills: Life insurance, Agile, Life products Experience: 8+years Location: Chicago/ Peoria, IL USA (Hybrid) Duration: Fulltime/ Contract We at Coforge are hiring a Sr. Business Analyst...Full timeContract work
- ...Job Description Role: Business Analyst Location: NYC,NY Onsite Duration: Longterm BA : senior profile 5-7y what makes the difference : someone curious, willing to engage with his stakeholder and not afraid. nice to have : banking but no mandatory...Work at office3 days per week
- ...Job Description We are seeking an experienced Business Analyst with strong Property & Casualty (P&C) insurance knowledge and specialized expertise in reinsurance. As the Business Analyst, you will serve as a liaison between business and technology teams, translating complex...
- ...Job Description Senior Business Analyst – Merchandising Technology Location: Nashville, TN (Brentwood area) Position Type: Contract through end of 2027 Location : Hybrid, 3 days on-site Pay Rate: $50-60/hr on W2 Accepting applicants through at least...Contract workLocal area
- ...Job Description A leading international law firm is looking for a Senior Analyst, New Business Conflicts Clearance to join the New York office. This role would suit an experienced conflicts professional with a background working within a law firm environment and...Work at office
- Job Title: Business Analyst - Healthcare Company: Aaratech Inc. Experience: 2+ years Compensation: $65,000 - $75,000 per year Work Authorization At this time, we are only able to consider candidates who are authorized to work in the United States without sponsorship. Job...
- Job Description Senior Director, Partner Engagement | DaVita Kidney Care Denver, CO | Hybrid — 2–3 days/week in office The Sycamore Group is partnering with DaVita Kidney Care to recruit a Senior Director, Strategy/Partner Engagement based in Denver, Colorado...Work at officeLocal areaRelocation2 days per week3 days per week
$72.8k - $100.1k
...Job Description Job Description POSITION SUMMARY: Working under the direct supervision of the Business Intelligence Manager, the Business Intelligence Analyst is responsible for creating and maintaining dashboards and reports in Tableau and Excel, performing advanced...Work at office- ...Job Description Business Overview We believe in the power of media to reshape our industry and orchestrate a brand’s entire... ...work, every day. INSTINCT – you’re tuned in and armed with intelligence; you have a bias for action – shit happens when you’re around....Work at officeLocal area
$50 - $80 per hour
...Job Description Business Operations / Knowledge Work Specialist (Part-Time | Remote | $50–$80/hr) Position: Business Operations / Knowledge Work Specialist Type: Part-Time (W-2 Employment) Compensation: $50–$80 per hour Location: Remote (United...Remote jobHourly payPart timeWeekday work$120k - $140k
...you at every stage. Your ambition has a home here. Senior TBM Planning Analyst We are hiring a Senior TBM (Technology Business Management) Planning Analyst to join our Enterprise Strategy and Technology Planning function. This role serves as the primary finance...Contract workLocal area- ...of customers. We work with 40% of the Fortune 100 companies. For a brief 1 minute video about us, you can check Designation: Lead Business Analyst Location: New York, NY (Onsite) Job Type: Fulltime Description: Stakeholder Management & Communication – ability to engage...Full time
- ...Job Description Workday Business Analyst (Data Mapping Specialist) Duration : 6 months Location: Chicago, requires 3 days onsite Responsibilities Legacy-to-Cloud Data Mapping: Analyze raw data from disparate legacy setups, translating them into standard...Local area
$105k - $125k
...Job Description Business Applications Analyst (ERP + Business Applications) Greater San Diego / North County | Onsite | $105,000-... ...troubleshooting through final resolution Support from ERP specialists, software vendors, MSPs, and other technical partners when deeper...Full timeLocal areaRemote work- ...Job Description Business Systems Analyst Job Overview: Business Systems Analyst assists in requirements gathering and... ...business and viastore under one brand to deliver scalable systems, intelligent software and life-cycle services. In addition to exciting...Night shift
- ...Job Description Business Information Management Analyst Position Type: Contract – 6 Months Openings: 5 Work Arrangement:... ...Disclosure As part of the recruitment process, artificial intelligence (AI) tools may be used to assist with application screening and...Contract workImmediate startRemote workMonday to Friday
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Business Intelligence Specialist. Be the first to apply!
- business intelligence Mundelein, IL
- business funding Mundelein, IL
- business technician Mundelein, IL
- citizens business bank Mundelein, IL
- business account collections Mundelein, IL
- business strategist Mundelein, IL
- business certificate Mundelein, IL
- associates degree business Mundelein, IL
- international business Mundelein, IL
- area business manager Mundelein, IL


