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. MacLean-Fogg
- 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 Asset Management Team. This opportunity...Suggested
- ...Job Description Senior Technical Business Analyst A premier consulting firm is seeking an experienced Senior Technical Business Analyst to support a federal client in Washington DC. This role involves working directly with a Chief Information Officer to modernize...Suggested
- ...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...SuggestedWork at office2 days per week
- ...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...Suggested
- ...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...Suggested
$60 - $65 per hour
...Job Description Position: Business Analyst – Capital Markets / AWS Migration Location : NYC, NY Pay Rate: $60-$65/hr. Mandatory: Capital Makets / AWS Migration Role Summary: We are looking for an experienced business analyst with strong capital markets...Local area- Job Description A market-leading private equity real estate investment firm is looking to hire an Asset Management Analyst to join its growing team of 15+ professionals. This position is ideal for someone with 1–2 years of experience who is eager to build expertise ...
- ...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 Our client is seeking a Business Analyst with expertise in procurement operations, media workflows, and emerging AI-driven business processes. This individual will partner directly with business stakeholders to discover, define, and document high-...
- ...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
- ...work closely with sales, buying, and operations to move product and meet financial targets. This is a hands-on role in a fast-paced business with shifting priorities, frequent ad hoc analysis, and short turnaround requests. The ideal candidate combines strong retail...Seasonal workShift 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 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...
- ...Job Description Platform Engineer / Junior Business Analyst – Capital Markets IT Position Details Client: Fifth Third Bank (Financial Services / Banking) Location: Cincinnati, OH (38 Fountain Square Plaza) Work Model: Onsite - 5 days per week...Contract workImmediate start
- ...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 Our client, an award-winning global consulting and technology firm specializing in private markets, is seeking a Business Analyst to join its growing U.S. practice. This opportunity is best suited for someone with experience in private markets,...
- ...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...
$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 COOK SYSTEMS has an immediate need for an IT Knowledge Management Analyst IT Knowledge Management Analyst Memphis, TN (hybrid/3 days onsite) The IT Knowledge Management Analyst enables our technology teams to create, organize, and maintain...Contract workImmediate start
$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 Kavaliro is seeking an Intelligence Analyst with a strong background in Taiwan political, economic, social, cultural, physical, geographic, technical or military conditions. The Intelligence Analyst will provide P2, SOJ2 support for SOCPAC to assist...
$95k - $125k
We Make Life More Rewarding and Dignified Location: LibertyvilleDepartment: Information Technology SummaryThe Senior Specialist, Business Systems Analyst is responsible for the analysis, design, testing, and implementation of business processes and the supporting software...Work at officeWorldwideVisa sponsorship$90k - $123.8k
...about a role but don't meet every bullet point, we encourage you to apply and join us to create the extraordinary.Job Summary The Business Systems Analyst will be based in Libertyville, Illinois, supporting the implementation, integration, and ongoing operation of...Full timeLocal areaVisa sponsorshipFlexible hours$100k - $125k
...LibertyvilleDepartment: Information Technology SummarySenior Business Systems Analysts are responsible for analyzing, designing,... ...to cash, planning, and finance.Working knowledge of business intelligence tools including, SAP BI, SAP ABAP Query, SAP Report Writer. Applies...Work at officeVisa sponsorship- ...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 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
$55 per hour
...administration, securities and cash transfers, and the processing of a range of financial products. This role works closely with internal business teams, trading desks, wealth management professionals, and external partners to ensure accurate transaction processing, regulatory...Contract workWork at office- ...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
- ...investment-focused organization is seeking a highly motivated Senior Business Analyst to help drive strategic business and technology... ...platforms and portfolio management tools. Exposure to business intelligence, analytics, and reporting platforms such as Power BI....Work at office
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
- manager business intelligence Mundelein, IL
- business certificate Mundelein, IL
- entry level business to business sales Mundelein, IL
- business process architect Mundelein, IL
- general business Mundelein, IL
- business technology Mundelein, IL
- associates degree business Mundelein, IL
- business valuation Mundelein, IL
- business operations intern Mundelein, IL


