Marketing Data & Growth Analytics BI Analyst

Beacon Hill; Indianapolis (IN); On-site; USD 65,000 - 90,000; Full time

Job summary

Beacon Hill is seeking a highly analytical BI Data Analyst to support marketing and sales. The role focuses on building dashboards, forecasting budgets, and reporting audience analytics across multiple channels including Paid Search, Paid Social, Affiliates, Display, OTT, Email, and Direct Mail.

You will collaborate with Marketing, Product, Finance, Risk, Analytics, and IT teams to drive data-driven decisions using Snowflake, SQL, Looker, and Hex, delivering insights to optimize acquisition and

Qualifications

• 2+ years BI Data Analyst experience supporting a business unit outside IT or marketing analytics.
• Advanced SQL with joins, CTEs, data extraction, and optimization.
• Experience with Snowflake or another SQL-based data warehouse.
• Experience building BI dashboards with Looker and/or Hex.
• Experience analyzing performance marketing channels (Paid Search, Paid Social, Affiliates, Partnerships, Display, OTT, Email, Direct Mail).
• Experience developing marketing performance forecasts, budget pacing reports, and acquisition projections.
• Experience analyzing ROI, application metrics, funnel metrics, and customer behavior data.
• Ability to translate business questions into data requirements and actionable recommendations.

Responsibilities

• Build BI dashboards to support marketing and sales users.
• Analyze data to help budget and forecast monthly, annually, and during peak seasons.
• Report on audience analytics using SQL queries for data extractions.
• Partner with Marketing, Product, Finance, Risk, Analytics, and IT teams to drive data-driven decision making.

Skills

BI Data Analytics

SQL

Marketing analytics

Forecasting and budgeting

Data-driven decision making

Attention to detail

Critical thinking

Questioning and curiosity

Requirements gathering

Education

Bachelor's degree (Finance/Accounting/STEM/CS/Data Analytics)

Tools

Snowflake

Looker

Hex

Python

R

Job description

Beacon Hill is seeking a highly analytical BI Data Analyst to support marketing and sales. The role focuses on building dashboards, forecasting budgets, and reporting audience analytics across multiple channels including Paid Search, Paid Social, Affiliates, Display, OTT, Email, and Direct Mail.

You will collaborate with Marketing, Product, Finance, Risk, Analytics, and IT teams to drive data-driven decisions using Snowflake, SQL, Looker, and Hex, delivering insights to optimize acquisition and