Business Intelligence Analyst

Energy Distribution Partners; Chicago (IL); On-site; USD 81,000 - 99,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

Health Savings Account (HSA)

Flexible Spending Account (FSA)

401(k) with company match

Employee Assistance Program (EAP)

Paid holidays and time off

Long-term disability coverage

Job summary

Energy Distribution Partners is seeking a Business Intelligence Analyst to transform complex data into clear insights and empower teams to make smarter decisions. You will own BI projects from discovery to delivery, partnering with stakeholders and influencing real-world outcomes.

Responsibilities include designing Power BI dashboards, integrating with Databricks, and developing scalable data models. The role requires 2+ years in Power BI, strong DAX/Power Query, and governance experience.

Qualifications

• 2+ years of hands-on experience building reports and dashboards in Power BI.
• Strong expertise in DAX, Power Query (M), and dimensional data modeling.
• Experience using Databricks as a reporting data source, including writing SQL against Databricks tables.
• Experience administering Power BI Service, including workspaces, refresh schedules, security, and deployments.
• Experience leading reporting or analytics projects from stakeholder request through final delivery.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports used across the business to monitor performance and support decision-making.
• Partner with business leaders and department stakeholders to understand challenges, uncover reporting needs, and deliver practical, user-friendly solutions.
• Manage BI projects from initial requirements gathering through development, testing, deployment, and ongoing enhancement.
• Connect Power BI to our Databricks environment and develop scalable, well-structured data models that support reporting needs.
• Create and maintain star schema data models, advanced DAX calculations, and Power Query (M) transformations.
• Administer Power BI Service, including workspace management, report deployment, refresh schedules, row-level security, and governance.
• Analyze trends, identify opportunities, and present findings to both technical and non-technical audiences.
• Collaborate with teammates to establish and improve BI standards, documentation, and best practices.

Skills

Power BI

DAX

Data modeling

SQL

Power Query

Databricks

Tools

Databricks

Power BI Service

Jira

Job description

The decisions our leaders make every day, from operations and growth strategy to customer experience, depend on having the right data at the right time. As our Business Intelligence Analyst, you'll be the person who transforms complex data into clear insights, helping teams across the organization make smarter, faster decisions that drive measurable business results.

This is a role for someone who enjoys owning projects from discovery through delivery, partnering directly with stakeholders, and seeing their work influence real-world outcomes.

What You'll Actually Do

• Design, build, and maintain Power BI dashboards and reports used across the business to monitor performance and support decision-making.
• Partner with business leaders and department stakeholders to understand challenges, uncover reporting needs, and deliver practical, user-friendly solutions.
• Manage BI projects from initial requirements gathering through development, testing, deployment, and ongoing enhancement.
• Connect Power BI to our Databricks environment and develop scalable, well-structured data models that support reporting needs.
• Create and maintain star schema data models, advanced DAX calculations, and Power Query (M) transformations.
• Administer Power BI Service, including workspace management, report deployment, refresh schedules, row-level security, and governance.
• Analyze trends, identify opportunities, and present findings to both technical and non-technical audiences.
• Collaborate with teammates to establish and improve BI standards, documentation, and best practices.

What Success Looks Like

Within your first 90 days, you'll have:

• Built strong working relationships with key business stakeholders across multiple departments.
• Taken ownership of several active reporting initiatives and delivered at least one end-to-end Power BI solution.
• Developed a clear understanding of our Databricks environment, core datasets, and reporting standards.
• Become a trusted resource for translating business questions into actionable reporting and analytics solutions.
• Contributed improvements to existing dashboards, data models, or BI processes that increase usability, performance, or adoption.

What You'll Actually Do in Your First 30 Days

• Meet with department leaders and key stakeholders to understand existing reports, business priorities, and recurring reporting challenges.
• Learn the Databricks data environment, reporting architecture, and Power BI governance standards.
• Review current dashboards and identify opportunities for performance, usability, or visualization improvements.
• Take ownership of your first reporting project, including requirements gathering, development planning, and stakeholder communication.

Must Have

• 2+ years of hands‑on experience building reports and dashboards in Power BI.
• Strong expertise in DAX, Power Query (M), and dimensional data modeling.
• Experience using Databricks as a reporting data source, including writing SQL against Databricks tables.
• Experience administering Power BI Service, including workspaces, refresh schedules, security, and deployments.
• Demonstrated experience leading reporting or analytics projects from stakeholder request through final delivery.

Nice to Have

• Experience with Databricks SQL, Unity Catalog, or Power BI performance optimization on large datasets.
• Experience working with Agile tools such as Jira or Azure DevOps.
• Familiarity with the Oil & Gas industry.
• Experience presenting analytical findings to executive or senior leadership audiences.

Why Join Us

You'll have the opportunity to work directly with decision-makers, see the impact of your work, and help shape how data is used across the organization. This is a role where strong ideas, curiosity, and practical problem-solving are valued as much as technical expertise.

• Location: Chicago (onsite)
• Compensation: Starting at $90,000 (based on experience)
• Direct Reports: None

What We Offer

In addition to competitive pay we offer a comprehensive benefits package designed to support your physical, financial, and personal well-being:

• Medical, dental, and vision insurance options
• Health Savings Account (HSA) and Flexible Spending Account (FSA)
• 401(k) with company match
• Employee Assistance Program (EAP)
• Voluntary life, AD&D, and short-term disability coverage
• Paid holidays and time off
• $50,000 basic life/AD&D and long-term disability at no cost

Our Culture

We're a collaborative team that values thoughtful questions, open communication, and continuous improvement. You'll work alongside people who genuinely enjoy solving problems together and who care more about delivering results than protecting titles or silos.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.