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:
- Competitive benefits packages
- Vacation, compassionate leave, sick days, and flex days
- Access to online services for families and new parents
- End of year closure days (not deducted form vacation balance)
- Diversity and Inclusion Board with 12 affinity groups
- Internal learning and development programs
- 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 that is committed to diversity and inclusion in the workplace. We do not tolerate discrimination on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. If you are an individual with disabilities who would like to request an accommodation, please reach out to [email protected].
We are committed to fostering diversity, equity, and inclusion within our pool of candidates, with a target of achieving at least 50% representation from underrepresented communities.
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
Top Skills
What We Do
Critical Mass is a digital experience design agency with a relentless focus on the customer. Founded in Calgary in 1996, we have steadily expanded into a group of over 950 people working in 11 offices across North America, Europe, Asia, Latin America, and South America.
