Business Intelligence Analyst

EDP Current Openings•Chicago, IL

7d•Onsite

About The Position

The Business Intelligence Analyst transforms complex data into clear insights that help leaders and teams make informed decisions across operations, growth strategy, and customer experience. The role owns BI projects from discovery through delivery, partners directly with stakeholders, and develops solutions that support measurable business results. The analyst designs, builds, and maintains Power BI dashboards and reports; connects Power BI to Databricks; develops scalable data models; and administers Power BI Service. The position also analyzes trends, presents findings to technical and non-technical audiences, and collaborates with teammates to improve BI standards, documentation, and practices. The role is onsite in Chicago, has no direct reports, and offers starting compensation of $90,000 based on experience.

Requirements

At least 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 Haves

Microsoft Certified: Power BI Data Analyst Associate (PL-300).
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.

Responsibilities

Design, build, and maintain Power BI dashboards and reports for business performance monitoring and decision-making.
Partner with business leaders and department stakeholders to understand challenges and reporting needs, then deliver practical, user-friendly solutions.
Manage BI projects from requirements gathering through development, testing, deployment, and ongoing enhancement.
Connect Power BI to the Databricks environment and develop scalable, well-structured data models.
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 technical and non-technical audiences.
Collaborate with teammates to establish and improve BI standards, documentation, and best practices.
Meet with department leaders and stakeholders to understand existing reports, business priorities, and recurring reporting challenges.
Learn the Databricks data environment, reporting architecture, and Power BI governance standards.
Review dashboards and identify opportunities to improve performance, usability, and visualizations.
Own reporting projects, including requirements gathering, development planning, and stakeholder communication.
Build stakeholder relationships, take ownership of active reporting initiatives, deliver an end-to-end Power BI solution, and contribute improvements to dashboards, data models, or BI processes.