BI Analytics Engineer: Power BI, SQL & Data Warehouse - Remote

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

Benefits offered by this job

Medical, dental, and vision coverage

401(k) with company match

Paid time off and holidays

HSA contributions

Life insurance

Parental leave

Mental health resources

Tuition reimbursement

Employee programs

Job summary

MacLean‑Fogg is seeking 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

Qualifications

• Bachelor’s degree in Information Systems, Business Analytics, Computer Science, Finance, Engineering, or a related field or equivalent experience.
• 2–4 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, and publishing to a shared workspace.
• Demonstrated proficiency writing SQL, including multi‑table joins, aggregation, and query performance troubleshooting.

Responsibilities

• 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 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 end users to gather reporting requirements, translate them into technical specs, review drafts, and confirm acceptance.
• Apply consistent standards for report design, naming conventions, and data definitions across business units and locations; recommend consolidation of duplicate requests.
• Support migration and rebuild of existing Power BI reports as the organization centralizes the data model; define reporting requirements for data engineering.
• Develop and maintain semantic models and shared datasets to support self-service reporting and document report logic, data sources, and change history.
• Maintain and troubleshoot the existing report portfolio, including performance tuning and updates as business processes and data sources evolve.

Skills

Power BI

ReportsNow

SQL

Data modeling

DAX

Requirements gathering

Education

Bachelor’s degree

Tools

JD Edwards

ReportsNow

SQL Server

Power BI

Job description

MacLean‑Fogg is seeking 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