Data Engineer

2 Hours ago • 1-1 Years

Job Summary

Job Description

The Data Engineer will be responsible for facilitating the flow of large amounts of raw data from various locations into well-organized tables. They will transform raw data into analyzable bits, turning chaos into an operational process. The role involves automating processes, defining data solutions, analyzing documentation, writing code, improving automation efficiency, and providing technical guidance to the team. The Data Engineer will work closely with the marketing science and account teams to understand the business context, stay updated on industry trends, and assist in data infrastructure design.
Must have:
  • Experience using SQL, python, or working with APIs
  • Experience designing ETL solutions
  • Ability to learn quickly from a wide range of subjects
  • Knowledge with SQL queries and database components
  • Mastery of office productivity tools
  • Bachelor's degree
Good to have:
  • Knowledge with Adobe Campaign ETL manager
  • Salesforce Knowledge
Perks:
  • Prepaid Medical Assistance
  • Additional vacation days
  • Birthday bonus
  • Day off between Christmas or New Year
  • 3 personal days per year

Job Details

We are looking for a Data Engineer for our team. The Data Engineer facilitates the flow of massive quantities of raw files from various disparate locations into well-harmonized tables. Much is made of the potential to use data to solve the world’s problems – the data engineer knows that this “data” is useless unless it can be organized into analyzable bits...and it's most likely a mess. No problem: data engineers are at the vanguard of the Marketing Science team, taking basic and essentially unusable information and refining it into the stuff of predictive models. At the forefront of our marketing science organization, the data engineer solves problems “on the ground,” often with little documentation and vague direction from business stakeholders; they pave the way for fruitful analysis by turning chaos into an operational process.


You will:

  • Automate manual processes through SQL, python, etc.
  • Define solutions for using, extracting, and manipulating 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 download and upload data
  • Continuously improve the efficiency of existing automation to make it faster, cheaper and smarter
  • Provide the “voice of reason” that keeps the rest of the team grounded in what is possible and by when
  • Understand the nuances of the analysis required
  • Explain the complexities involved with data extraction to analysts
  • Work closely with the rest of the MKS and account teams to understand the business context of the account
  • Stay up to date on the latest industry news and analysis techniques
  • Assist in tagging and data infrastructure design

 

You have: 

  • Fluent in English (minimum B2+ reading, writing, and conversation)
  • 1+ years of experience using SQL, python, or working with APIs
  • 1+ years of experience designing ETL solutions
  • Demonstrated ability to learn quickly from a wide range of different subjects
  • Data savvy individual with good knowledge and hands-on experience in SQL queries. We need a person who understands database components like schemas, tables, stored procedures, triggers, DDM and DDL commands, and data management.
  • Mastery of office productivity tools such as Excel, Word, MS Project, Visio, and PowerPoint.
  • Bachelor's degree
  • Knowledge with Adobe Campaign ETL manager
  • Salesforce Knowledge

What We Offer:

  • Prepaid Medical Assistance for $300,000 COP
  • Vacations: 3 additional days of vacation to the 15 legal days, subject to the applicable policies in the company
  • On your birthday: Half a day for you to celebrate and a birthday bonus
  • You can choose a day off between Christmas or New Year
  • You will have 3 personal days, which you can use for your personal matters, each calendar year
  • 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.

 

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: 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/educacion_consumidor/consejos_practicos.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 Bogota, Colombia

Looks like we're out of matches

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

Similar Category 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 (On-Site)

Chicago, Illinois, United States (On-Site)

Bogota, Colombia (On-Site)

Bogota, Colombia (On-Site)

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

Vancouver, British Columbia, Canada (On-Site)

Cupertino, California, United States (On-Site)

Bogota, Colombia (On-Site)

Bogota, Colombia (On-Site)

San Jose, California, United States (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