Data Engineer, Marketing Sciences

Data, Analytics & Insight Los Angeles, California


Description

Position at Mindshare

ABOUT THE ROLE:

The Data Engineer is responsible for managing the development and maintenance of databases and business intelligence tools. You must also be comfortable with acting as the subject matter expert in the tools and processes they manage, along with being able to gather knowledge from other SMEs and requirements from key stakeholders. The Data Engineer is expected to demonstrate: hands-on skills in data analysis and management, problem solving, research skills, excellent oral and written communication skills, client focus, and the ability to support and enable teamwork. You must be self-motivated and able to operate independently with limited guidance and direction. You will report to the Associate Director or Director and will provide overviews of project status, progression and roadblocks. This role requires a strong familiarity with all available analytics and technology tools, both syndicated and proprietary.

 

YOUR IMPACT:
Business Analysis/Project Management

  • Analyze data and consult with subject matter experts to design and develop business requirements for various tools and processes; Create, gather and write Business and Technical Requirements Documents
  • Act as the subject matter expert for questions/projects relating to data quality, BI tools, business rules; Ensure that best practices are being followed amongst all projects
  • Must familiarize themselves with the full campaign implementation workflow across all functional teams, including campaign set up, launch, testing, reporting and reconciliation
ETL Processes/Business Intelligence Dashboards
  • Manage/Build Data pipelines and automation.
  • Manage the investigation and resolution of potential data issues existing within business intelligence tools
  • Track the progress and resolution of data issues, elevating any critical issues to upper management
  • Supervise Senior Associates and Associates to perform data quality assurance and data processing tasks
Overall
  • Builds positive relationships with internal teams; effectively communicate roles, responsibilities and expectations
  • Builds positive relationships with vendors and partners

 

YOUR SYSTEMS & TOOLS EXPERIENCE:

  • Strong familiarity with relational database management systems; Experience with SQL, Microsoft Azure a plus
  • Familiarity with business intelligence tools such as Tableau, PowerBI, Datorama, DOMO, Looker
  • Experience with advertising campaign management/buying platforms such as Sizmek, DCM, Moat, DV, IAS, Mediaocean, Media Tools, Nielsen, ComScore, Facebook, Twitter, Pinterest, Snapchat, 4C, Brand Networks, YouTube, Google Ads, Bing, Kenshoo, SA360, DV360, Google Analytics, Adobe Analytics
  • Advanced excel data manipulation skills required; VBA/macros is a plus
  • Familiarity with programming languages/development tools a plus: Python, R, JavaScript, GitHub, etc.

 

YOUR QUALIFICATIONS:

  • Bachelors or advanced degree in Statistics, Economics, Business, Math, Computer Science, or Sciences is preferred
  • Minimum 3 years’ experience in data governance processes in a data warehousing, ETL and business intelligence environment
  • 2 year’s experience in media digital Investment, analytics, or ad operations is preferred
  • 1-2 years’ experience in business analysis
  • Experience and understanding of processes across multiple media channels (digital, search, social, offline, etc.); Experience in handling diverse datasets (paid media, owned, etc.)
  • Demonstrates strong eye/attention to detail
  • Excellent verbal and written skills
  • Exceptional organizational skills, multi-tasking capabilities and detail oriented
  • Ability to foster collaborative relationships with other cross-functional teams
  • Ability to manage and prioritize competing projects and deliverables
  • Comfortable working with budgets and numbers

 

ABOUT MINDSHARE:

At Mindshare, we believe in speed, teamwork and provocation. Mindshare USA empowers people to challenge the status quo, through what we call Provocation with Purpose. We’ll encourage you to break the rules, knock things down, rebuild them better, and push the boundaries of what’s possible. It takes a team of people who invest in other’s success, and together we make Mindshare the place where we do the best work of our career. We’re a team that is radically honest – we call this our Authenticity Quotient. We are curious and competitive – that’s our Passion Quotient. We embrace teamwork and adaptability – that’s our Emotional Quotient. We’re proud to be unmistakably #TeamMindshare.
 

Take A Virtual Office Tour: https://roundme.com/tour/335529.

GroupM and all its affiliates embrace and celebrate diversity, inclusivity, and equal opportunity. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. We are a worldwide media agency network that represents global clients. The more inclusive we are, the greater work we can create together.