Business Intelligence Specialist

MacLean-Fogg is hiring a Business Intelligence Specialist to design develop and maintain reporting that supports financial operational and supply chain decision-making. Youll 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: $75000$85000/year

• Employment Type: Full-time / Salary

• Travel: Up to 10%

• 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 companys 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.

• Bachelors 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 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.

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:

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.

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.

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 .

#ind-exempt