Marketing Science Associate Analyst (Data Engineer)

4 Minutes ago • All levels • Data Analysis

Job Summary

Job Description

As an Associate Analyst on the Marketing Sciences team, you will apply data to digital experiences and contribute to various marketing science deliverables, including website analytics, data visualization, data integration, data engineering, and data management. You will define and implement logical approaches to data management and analysis, ensuring data is moved efficiently and accurately. The role involves collaborating with cross-functional teams and continuously learning new techniques to improve data processes and insights.
Must have:
  • Automate manual processes using SQL and Python.
  • Define solutions for data extraction and transformation based on business needs.
  • Write code using APIs for data pipelines.
  • Improve efficiency of existing automations and maintain accurate datasets.
  • Understand and explain complexities of data extraction and transformation.
  • Work closely with Marketing Science and account teams.
  • Stay updated on industry news and techniques.
  • Assist in guiding data architecture and infrastructure design.
  • Proficiency in English (B2+ level).
  • Advanced studies in a quantitative or technical field (e.g., Computer Science, Mathematics, Engineering, Statistics).
  • Working knowledge of SQL (including PostgreSQL) and Python.
  • Understanding of APIs and database components (schemas, tables, stored procedures, triggers).
  • Understanding of data and pipeline management and SDLC best practices (ETL/ELT, DAGs, CI/CD, version-control).
  • Understanding of basic data visualization methods.
  • Demonstrated ability to learn new data analytics tools quickly.
  • Ability to document work thoroughly, clearly, and intuitively.
  • Proactive communication skills with team, stakeholders, and leadership.
  • Ability to adapt and think creatively to solve problems.
  • Strong critical thinking skills.
  • Strong desire to learn and grow in the role.
Good to have:
  • Familiarity with AWS and DevOps.
  • Familiarity with third-party ETL/pipeline and data orchestration tools (e.g., Rivery/Boomi, FiveTran) and/or distributed processing platforms like Databricks.
  • Exposure to Tableau, PowerBI, or similar business intelligence and visualization tools.
  • Familiarity with advertising platform pixel tracking.
  • Familiarity with Dynamic Creative Optimization.
  • Familiarity with Digital media taxonomy nomenclature.
  • Experience with digital media intelligence platforms (e.g., SimilarWeb, Brandwatch).
Perks:
  • Maternity and parental leave extra days
  • Competitive benefits packages
  • Vacation, compassionate leave, sick days, and flex days
  • Access to online services for families and new parents
  • Diversity and Inclusion Board with 12 affinity groups
  • Internal learning and development programs
  • Enterprise-wide employee discounts
  • And more…

Job Details

As an Associate Analyst on the Marketing Sciences team, your curiosity never ends. You wonder about the application of data to digital experience, and you are eager to contribute to marketing science deliverables across a broad range of initiatives (e.g., website analytics, data visualization, data integration, data engineering, and data management). You are able to define and apply a logical approach to data management and analysis, moving data from point A to point B in the right shape at the right time, and enjoy collaborating and learning with others.

---

You will:

  • Automate manual processes using SQL, python, etc.
  • Define solutions for using, extracting, and transforming data as driven by the business need for knowledge and decision-making.
  • Analyze documentation and propose data extraction solutions.
  • Write code that uses APIs to move data through pipelines and processes.
  • Help to continuously improve the efficiency of existing automations and maintain concise and accurate datasets and processes.
  • Understand the nuances of analyses on which cross-functional teams rely
  • Explain the complexities involved with data extraction and transformation to team members across cross-functional groups
  • Work closely with the rest of the Marketing Science and account teams to understand business context and logic
  • Stay up to date on the latest industry news and techniques
  • Assist in guiding data architecture and infrastructure design

You have:

  • Proficiency in English (B2+ level reading, writing, conversation)
  • Advanced studies in a quantitative or technical field, including but not limited to: Computer Science, Mathematics, Engineering, Statistics, and/or related disciplines requiring proficiency in data management, analysis, and engineering fundamentals.
  • Working knowledge of SQL (including PostgreSQL) and python, understanding of how to work with APIs and database components like schemas, tables, stored procedures, triggers, etc.
  • Understanding of data and pipeline management and SDLC best practices, including but not limited to: ETL/ELT; building and understanding DAGs; CI/CD; version-control
  • Understanding of basic data visualization methods and how to get the data in the right shape to tell a clear and concise story
  • Demonstrated ability to learn new tools and techniques in the data analytics domain quickly
  • A knack for documenting your work and processes thoroughly, clearly, and intuitively
  • An ability to proactively communicate needs, roadblocks, statuses to the team, stakeholders, and leadership with clarity – you’re not afraid to reach out for help and consultation whenever needed
  • A demonstrated ability to adapt in adverse situations, think outside the box in collaboration with the team to come up with creative solutions to tough problems
  • Strong critical thinking skills: you’re willing to ask questions and go the extra mile to understand processes and to understand the why behind the work and not just the how.
  • A strong desire to learn and grow in your role.

Nice-to-haves:

  • Familiarity with working in AWS and DevOps.
  • Familiarity with third party ETL/pipeline and data orchestration tools (e.g., Rivery/Boomi, FiveTran, etc.) and/or distributed processing platforms like Databricks.
  • Some exposure working with Tableau, PowerBI, or similar business intelligence and visualization tools.
  • Familiarity with at least one of the following areas is an asset:
  • Advertising platform pixel tracking
  • Dynamic Creative Optimization
  • Digital media taxonomy nomenclature
  • Experience with digital media intelligence platforms (e.g., SimilarWeb, Brandwatch, etc.)

What We Offer:

  • Maternity and parental leave extra days
  • Competitive benefits packages
  • Vacation, compassionate leave, sick days, and flex days
  • Access to online services for families and new parents
  • Diversity and Inclusion Board with 12 affinity groups
  • Internal learning and development programs
  • Enterprise-wide employee discounts
  • And more…

At Critical Mass, we value our employees and offer competitive compensation and benefits packages. If you’re looking for a challenging and rewarding opportunity to make a significant impact on the lives of our employees, we encourage you to apply for this exciting position today!

The Talent Team at Critical Mass is focused on ensuring we provide the best training, onboarding, and employee experience possible! Our new hires & employees are the future of our organization, and we want to set you up for long-term success. In an effort to do so, we expect our team to work from an office a minimum of 3 days a week.

The ask stems from our want to:

  • Strengthen opportunity for continuous learning
  • Improve collaboration and team relationships.
  • Increase employee engagement

This work model balances the need for individual flexibility while maintaining the relentless customer focus we provide at CM. We understand that not everyone may feel comfortable with this expectation, so we ask that you please let us know immediately if there are any concerns so we can help navigate accordingly.

Critical Mass is an equal opportunity employer.

The Critical Mass Talent Acquisition team will only communicate from email addresses that use the URLs criticalmass.com, omc.com and us.greenhouse-mail.io. We will not use apps such as Facebook Messenger, WhatsApp, or Google Hangouts for communicating with you. We will never ask you to send us money, technology, or anything else to work for our company. If you believe you are the victim of a scam, please review your local government consumer protections guidance and reach out to them directly.

If U.S. based: https://www.consumer.ftc.gov/articles/job-scams#avoid

If Canada based: https://www.canada.ca/en/services/finance/consumer-affairs.html

If U.K. based: https://www.gov.uk/consumer-protection-rights

If Costa Rica based: https://www.consumo.go.cr/educacionconsumidor/consejospracticos.aspx

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in San Jose, California, United States

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Data Analysis Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

Critical Mass is a team of 1,800 inspired folks based in 12 offices around the world, providing full-service digital capabilities for the greatest brands on Earth. Our secret sauce is our uncompromising design standards, our relentless focus on customers, and an ability to put powerful new technologies to work for our clients.


We work with the best—Apple, Nike, Mars Wrigley, Nissan, Diageo, Airbnb, BMW, BNY Mellon, Johnson & Johnson, and many more—brands who strive for connected digital ecosystems and unparalleled experiences. We help them get there by gaining deep insight into their consumers and orchestrating data, AI, design, media, and tech stacks around human stories.


We’re a global agency founded in Canada, but digital is our home. If you know us, then you know we’re a special, quirky place that attracts big talent and tiny egos. (We actually give out a “so f-n nice” award—lots of them). But just because we’re friendly doesn’t mean we’re not a force to be reckoned with. We’re driven. Relentless. And we live our values. We’re Critical Mass, but our friends call us CM. Please call us CM!

San Jose, California, United States (Hybrid)

San Jose, California, United States (Hybrid)

San Jose, California, United States (Hybrid)

San Jose, California, United States (On-Site)

Chicago, Illinois, United States (On-Site)

Chicago, Illinois, United States (On-Site)

Vancouver, British Columbia, Canada (On-Site)

San Jose, California, United States (Hybrid)

San Jose, California, United States (Hybrid)

Vancouver, British Columbia, Canada (On-Site)

View All Jobs

Get notified when new jobs are added by Critical mass

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug