Red Hat Regional Marketing Data Analyst in Raleigh, North Carolina

Company description

At Red Hat, we connect an innovative community of customers, partners, and contributors to deliver an open source stack of trusted, high-performing solutions. We offer cloud, Linux, middleware, storage, and virtualization technologies, together with award-winning global customer support, consulting, and implementation services. Red Hat is a rapidly growing company supporting more than 90% of Fortune 500 companies.

Job summary

Support the budget and technical reporting and visualization and data infrastructure for North America (NA) Field Marketing team. The Red Hat Strategy, Insights, and Operations team is looking for a Regional Marketing Data Analyst to join us in Raleigh, NC. In this role, you will build an infrastructure to connect, query, and manage relational databases using SQL. You’ll need to have technical reporting and data visualization skills for supporting business analysts on the team. You’ll create and automate reporting for the regional campaign, discretionary, and market development funds (MDF) budgets managed in Allocadia, Red Hat’s marketing budget management platform. As a Regional Marketing Data Analyst, you will collaborate closely with Red Hat’s Procurement, Financial Planning, and Analysis teams and the global Allocadia team to resolve discrepancies between Allocadia and Oracle purchasing systems, or actual spend-to-budget forecast and target variances. You’ll also need to have the ability to clearly communicate budget management practices and expectations, monthly Finance team’s reporting deadlines, and relevant changes to Finance and Procurement teams’ systems and processes.

Primary job responsibilities

  • Build infrastructure to connect and manage relational databases using SQL

  • Support business analysts by sourcing raw data for manipulation, technical reporting, and data visualization

  • Work with cross-functional stakeholders to ensure that fiscal year and quarterly budget targets are allocated correctly in Allocadia

  • Build and automate regular reports to monitor actual spend and expenses to budget forecasts

  • Work with managers and budget owners to ensure achievement within +/-5% of fiscal quarter and year targets

  • Work with Procurement, Financial Planning, and Analysis teams and global Allocadia teams to resolve discrepancies between Allocadia and Oracle purchasing systems or expenses to forecast and target variances

  • Keep managers and budget owners apprised of budget planning milestones, requirements, and deadlines, as well as relevant changes to Finance or Procurement teams’ systems and processes

Required skills

  • Bachelor’s degree in business or a related discipline; MBA is a plus

  • SQL proficiency

  • Experience building and managing an infrastructure to connect relational databases

  • Solid technical reporting skills and insight; ability to recognize discrepancies across data sets

  • Data visualization experience, including the use of Tableau or similar tools

  • Experience building and automating reports

  • Proficient with Microsoft Office Excel and Google Sheets

  • Highly motivated problem-solver who excels in a fast-paced, dynamic environment

  • Ability to work effectively as part of a team across geographically distributed teams and stakeholders

  • Excellent written and verbal communication skills

Red Hat is proud to be an equal opportunity workplace and an affirmative action employer. We review applications for employment without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, ancestry, citizenship, age, uniformed services, genetic information, physical or mental disability, medical condition, marital status, or any other basis prohibited by law.

Red Hat does not seek or accept unsolicited resumes or CVs from recruitment agencies. We are not responsible for, and will not pay, any fees, commissions, or any other payment related to unsolicited resumes or CVs except as required in a written contract between Red Hat and the recruitment agency or party requesting payment of a fee.

Job ID 63376

Category Corporate Marketing