The Corporate Marketing Analyst will report to the Vice President of Corporate Marketing. Scorpion is seeking an individual who enjoys working in a team-oriented, fast-paced environment while meeting deadlines and identifying opportunities for growth. The ideal candidate will be able to disseminate data with clear actionable steps to drive the company towards meeting goals within Scorpion’s target vertical markets.

Scorpion is an innovative technology and marketing company growing at an accelerated pace. As a leader in the field of Internet marketing and the winner of the 2016 Google Platform Innovator of the Year Award, we believe in hiring only the most passionate employees who look forward to coming to work every day to solve challenges and deliver exceptional results to our clients.

Responsibilities

• Learn our process for de-duplicating records and be able to train and supervise others in the task
• Build reporting dashboards and maintain existing ones
• Create ad hoc reports and conduct on-the-fly anaysis
• Be responsible for maintaining data integrity in our records and clean up messy data as needed
• Identify areas where we can be more efficient and make suggestions for improvements
• Be a quick response force for urgent data processing problems

Pay: Salary + Bonuses

Experience:

• Bachelor’s degree or higher
• 2-4 years conducting analysis and reporting

Skills:

Required Skills:

• You have a problem solving mindset and capable of finding answers on your on with little guidance. Your Google-Fu is strong and you know the answer you seek is a single search away.
• Your attention to detail is second to none. Periods, commas, and semi-colons look different to you from a mile away. An extra space between text sticks out like a sore thumb.
• You have experience creating reports that help drive business decisions and can communicate those results effectively.
• You are an advanced Excel user and are comfortable with the following:
  • Pivot tables
  • Charts/pivot charts
  • Basic VBA
  • Formulas:
    • Lookups: INDEX/MATCH
    • Logic: IF/AND/OR/COUNTIFS/SUMIFS
    • Text Manipulation: LEFT/RIGHT/MID/LEN/CONCATENATE
• You can apply said Excel skills quickly to solve problems and answer questions.

Additional Skills/Experience That Will Help, But Aren’t Required:

• Advanced VBA skills
• Familiarity with a programming language (other than VBA)
• Experience with Google Sheets and their specific formulas (IMPORTRANGE, QUERY, ARRAYFORMULA, etc)
• An understanding of how relational databases work
• Experience with marketing analysis
• Experience with a market research firm or within B2B company performing analytics