• Regional Marketing Data Analyst

    Location US-NC-Raleigh
    Posting date 2 weeks ago(6/5/2018 6:40 AM)
    Job ID
    63376
    Category
    Corporate Marketing
  • 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.

     

    Interested in this job?

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed