Job Description
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 disciplinesrequiring 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 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:
If Canada based:
If U.K. based:
If Costa Rica based: Critical Mass
Job Tags
Work at office, Local area, Immediate start, Flexible hours, 3 days per week,