Business Analyst (Marketing)

Openkrill; United States; Remote; USD 85,000 - 120,000; Full time

Job summary

Openkrill is hiring a Marketing Business Analyst to translate day-to-day questions into structured analyses and actionable reporting. You will own recurring reporting, maintain dashboards, and query datasets using SQL, supporting stakeholders with ad hoc requests.

The role emphasizes independent investigation, data-driven storytelling, and reliable analytics support across marketing metrics and campaigns.

Qualifications

• 3+ years in data/BI/analytics or reporting
• Experience structuring analyses from broad business questions
• Preference for Sigma; Tableau or similar platform experience
• Salesforce reporting experience is a plus
• Experience collaborating with a central data/analytics team
• Exposure to marketing metrics and funnel analysis (MQLs, campaigns) is a plus

Responsibilities

• Turn open-ended business questions into structured analyses.
• Scope questions and determine data needed for analysis.
• Investigate changes in business metrics and deliver findings.
• Own and maintain recurring reports and dashboards.
• Query datasets with SQL against established schemas.
• Provide ad hoc analysis support to stakeholders.
• Keep dashboards clean, organized, and up-to-date.

Skills

SQL

Data storytelling

Dashboard maintenance

Stakeholder communication

Detail-oriented reporting

Claude AI tools

Tools

Sigma

Tableau

Salesforce reporting

Job description

This role is open to candidates based in LATAM, Africa, and Eastern Europe. Please note that as this role supports U.S.-based clients, candidates must be available to work during U.S. business hours aligned with the client’s time zone.

Our client has an established reporting foundation supported by a central data team, including schemas, core datasets, and dashboards. They are seeking an analyst to work on top of this existing infrastructure and turn day-to-day business questions into clear, structured analysis and actionable reporting.

ROLE OVERVIEW

The Business Analyst (Marketing) will serve as a go-to resource for day-to-day business analysis, investigating changes in key metrics and translating findings into reporting that stakeholders can act on.

This is a hands-on role combining analytical thinking with practical execution. The Marketing Analyst will conduct business analyses, own recurring reporting, maintain dashboards, query existing datasets using SQL, and support stakeholders with ad hoc analysis requests.

The role requires someone who can independently structure an investigation while also managing the ongoing maintenance and detail-oriented work required to keep reporting accurate, current, and easy to use.

LOCATION

Fully Remote | 9:00 AM - 5:00 PM EST

KEY RESPONSIBILITIES

BUSINESS ANALYSIS

• Turn open-ended business questions into structured, well-reasoned analyses.
• Scope business questions and determine the appropriate data needed for analysis.
• Investigate changes in business metrics.
• Deliver clear findings and recommendations based on analysis.

RECURRING REPORTING

• Own and maintain recurring reports and dashboards.
• Ensure stakeholders have timely, accurate, and consistent views of performance.

DASHBOARD MAINTENANCE

• Manage ongoing dashboard hygiene and upkeep.
• Update workbooks and adjust dashboard layouts.
• Keep visualizations clean, organized, and easy to read.

DATA EXPLORATION

• Write SQL to query existing datasets from established schemas.
• Create previews of data models based on business questions.
• Work with the existing data infrastructure without needing to build or maintain the underlying infrastructure.

STAKEHOLDER SUPPORT

• Serve as a reliable analysis resource for the team.
• Respond to ad hoc analysis requests.
• Help stakeholders understand what the numbers mean.

QUALIFICATIONS

EXPERIENCE

• 3+ years of experience in a data analysis, business analysis, or reporting role.
• Experience independently structuring and working through analyses from broad business questions.
• Hands-on experience with a modern BI or analytics tool such as Sigma, which is strongly preferred.
• Experience with Tableau or a similar platform is transferable.
• Experience with Salesforce reporting, including building and pulling reports and dashboards, is a plus.
• Familiarity working alongside a central data or analytics engineering team is a plus.
• Exposure to marketing metrics and funnel analysis, including MQLs and campaign performance, is a plus.

SKILLS

• Solid working knowledge of SQL for querying and exploring data.
• Ability to break down broad business questions, investigate them, and communicate the answer.
• Ability to maintain dashboards, including formatting, layouts, and ongoing upkeep.
• Ability to clearly present analytical findings to non-technical stakeholders.
• Comfort with manual and detail-oriented reporting work.
• Experience using AI tools such as Claude for data analysis and Claude Code for workflow acceleration is a plus.

WHAT SUCCESS LOOKS LIKE

• Open-ended business questions are translated into structured analyses with clear findings and recommendations.
• Recurring reports and dashboards provide timely, accurate, and consistent views of performance.
• Dashboards remain current, organized, and easy to read.
• Existing datasets are effectively queried and explored using SQL.
• Stakeholders receive reliable analytical support and can clearly understand what the numbers mean.

OPPORTUNITY

This role offers the opportunity to become a go-to resource for day-to-day business analysis while working on top of an established reporting and data foundation. The Business Analyst (Marketing) will work across business analysis, recurring reporting, dashboard maintenance, data exploration, and stakeholder support.