Business Intelligence Analyst

Description

About Us

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.

Our Mission: 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. 

Role Summary:

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.

Examples of Dashboards & Reporting You’ll Support:

· 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.

Key Responsibilities:

Reporting Production

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

Data QA and Reliability

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

Enhancements and Upgrades

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

Documentation and Repeatability

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

What Success Looks Like

First 30–60 days

· 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 

By 90 days

· Own a stable portfolio of recurring client-facing outputs with minimal rework

· Ship measurable dashboard improvements (clarity, usability, or speed)

By 6 months

· 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

Qualifications (required)

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

Qualifications (preferred)

· 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 tr