Business Intelligence Analyst

Description

Darwill is a third-generation, family-owned performance-based marketing company based in the western suburbs of Chicago, IL. Since 1951, we’ve helped clients grow through omnichannel marketing powered by data, strong creative, and measurable performance.

To empower national and local businesses through performance-based marketing by executing complex location-based data-driven campaigns, leading to increased sales, sustainability, and an improved return on investment.

We’re hiring a hands-on BI reporting specialist to keep our reporting engine running—accurate, on time, and continuously improving. This is a supporting BI role that partners closely with our Senior BI Strategist to execute and scale the BI vision. You will focus on delivery and operational excellence: maintaining and enhancing Tableau dashboards built on data in Databricks, with strong QA practices to ensure client-facing outputs are correct and consistent.

You will produce client-facing deliverables (dashboards, exports, reporting views) and interface with internal stakeholders, but you will not be responsible for client presentations.

• Campaign performance dashboards (channel pacing, conversion trends, creative/offer performance, and budget impact).
• Matchback and attribution-style reporting that ties marketing activity to outcomes.
• Location-level rollups and drill-downs for multi-location clients (store/market comparisons).
• Customer vs. prospect profiling and audience segmentation views.

• Own assigned reporting deliverables end-to-end: refresh validation, dashboard updates, enhancements, and delivery-ready outputs.
• Build and maintain Tableau dashboards: parameters, filters, calculated fields, layout standards, and usability.
• Support reporting for multi-location clients (location-level detail and roll-ups).

• Perform QA before outputs are used internally or client-facing: reconciliation checks, trend validation, anomaly detection, and definition consistency.
• Escalate issues with clarity: what changed, impact, suspected cause, and recommended next step.

• Implement dashboard enhancements: new views, improved filtering, and data storytelling.
• Add/refine KPI calculations and definitions under BI team direction.
• Improve performance by reducing dashboard load time and optimizing calculations/queries.

• Maintain KPI definitions and reporting documentation (glossary, refresh cadence, dashboard intent, known limitations).
• Create and execute on repeatable checklists and SOPs for production and QA to ensure consistency at scale.

• Familiarize yourself with our data stack, core datasets in Databricks, and the business context behind our most-used dashboards
• Demonstrate strong QA habits and catch issues early

• Own a stable portfolio of recurring client-facing outputs with minimal rework
• Ship measurable dashboard improvements (clarity, usability, or speed)

• Increase reporting throughput via templating, documentation, and workflow improvements
• Become a trusted execution owner who can deliver impactful new reports from intake ? build ? QA ? release, in partnership with the Senior BI Strategist

• 1–3 years experience in BI, analytics, reporting, marketing analytics, or a data-adjacent role.
• Experience building and maintaining dashboards in a modern BI tool (Tableau strongly preferred).
• SQL (basic–intermediate): joins, aggregations, and writing queries to validate/report on datasets (you don’t need to be a data engineer).
• Strong Excel/Google Sheets skills (pivots, lookups, conditional logic).
• High attention to detail and accountability—client-facing reporting requires accuracy.
• Clear communication and comfort working through priorities, tickets, and deadlines.

• Familiarity with Databricks (or similar cloud data platforms).
• Exposure to marketing data sources (CRMs, GA4, paid media platforms, call tracking, etc.).
• Experience working with data pipelines/connectors/APIs or troubleshooting data freshness issues.
• Comfort working in a task/ticket workflow (, Jira, Asana, etc.).

This role requires 2–3 days/week in the Oakbrook Terrace office (specific days determined by team needs). Must be able to reliably commute to western Chicago suburbs.