REMOTE - Marketing Data 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

• Must have at least 2 years experience in a BI Data Analyst role tied to supporting a business unit outside of IT or a role heavily focused on marketing analytics, performance marketing analytics or growth analytics
• Must have advanced SQL query writing skills including joins, CTEs, data extraction, and query optimization
• Experience working within Snowflake or another SQL based datawarehouse for data analysis and audience extraction
• Experience building BI dashboards and reporting solutions using Looker and/or Hex
• Experience analyzing performance marketing channels including Paid Search, Paid Social, Affiliates, Partnerships, Display, OTT, Email, and 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
• Experience partnering with Marketing, Product, Analytics, Finance, Risk, IT, and Data Engineering teams
• Strong attention to detail and commitment to data quality
• Heavy analytical and critical thinking skills required for this role
• Must be curious and able to ask good questions
• Participate in requirements gathering sessions, take client requirements and then be able to quickly work on building a draft solution for the business to then refine
• Bachelor's degree in areas such as finance, accounting, STEM related majors, Computer Science or Data Analytics

Desired Skills:

• Experience supporting sales and marketing teams a huge plus
• Experience within financial services, fintech, lending, banking, or other regulated industries
• Experience supporting highly seasonal businesses with significant fluctuations in marketing spend and acquisition demand
• Experience developing acquisition, spend, and revenue forecasting models
• Experience using Python or R for advanced analytics, experimentation, or statistical modeling
• Experience performing attribution modeling, customer journey analysis, cohort analysis, and retention analysis
• Experience creating audience segmentation and targeting strategies using behavioral and demographic data
• Experience enabling self-service analytics through dashboard development, training, and documentation
• Experience collaborating with Data Engineering teams on source tables, schemas, and data transformations

Description of Role/Responsibilities/Project:

Seeking a highly analytical BI Data Analyst who ideally has experience supporting marketing and sales users to focus on three main responsibilities: building BI dashboards, working to analyze data to help budget and forecast on monthly, annual and peak season times and lastly reporting on audience analytics using SQL queries for data extractions. This role is key to providing data analysis that supports customer acquisition and growth initiatives across multiple marketing channels including Paid Search, Paid Social, Affiliates, Display, OTT, Email, and Direct Mail. This highly visible role will partner with Marketing, Product, Finance, Risk, Analytics, and IT teams to drive data-driven decision making through forecasting, audience analytics, performance reporting, and customer insights. The position offers strong exposure to executive leadership while utilizing Snowflake, SQL, Looker, and Hex to influence acquisition strategy, optimize marketing investments, and support business growth. It is a great role for someone who likes to solve problems and think critically. If you are able to take on work without having all the details and jump in you will be successful. This is a large company but has a start up mentality feel to how they work, being fast, able to pivot, fail fast, and need people who can work with urgency.

California residents:

Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.

Beacon Hill is an equal opportunity employer and individuals with disabilities and/or protected veterans are encouraged to apply.

Company Profile:

Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.
Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.

Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.bhsg.com.

Benefits Information:

Beacon Hill offers a robust benefit package including, but not limited to, medical, dental, vision, and federal and state leave programs as required by applicable agency regulations to those that meet eligibility. Upon successfully being hired, details will be provided related to our benefit offerings.