Data Engineer

Critical Mass is an OPMG Group of Companies, a division of Omnicom Group Inc.

The Data Engineer facilitates the flow of often times 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 that its most likely a mess. No problem: data engineers are at the vanguard of the Marketing Science team, taking raw and largely unusable information and refining it into the stuff of predictive models. At the vanguard of our marketing science organization, the data engineer solves problems “on the ground,” many times with little documentation and vague direction from business stakeholders; they pave the way for fruitful analysis by turning chaos into a functional process.

You will: 

• Automate manual processes through SQL, python, etc
• 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 feasibility assessments 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 latest industry news and analysis techniques.
• Assist in tagging and data infrastructure design.

You have:

Academic background: Most coursework towards a bachelor's degree.

Required experience:

• Advanced English Proficiency (B2+/C1, reading, writing, and conversation).
• Most courses leading to a Bachelor's degree.
• 2 – 4 year’s experience using SQL, Python, or working with APIs
• 2 – 4 year’s experience designing ETL solutions. 
• Machine Learning architecture experience. 
• Knowledge in any of cloud computing technologies: Azure (Fabric), Salesforce, Databricks, Snowflake and or AWS.
• Demonstrated ability to learn quickly from a wide range of different subjects.
• Pharma experience is a plus. 
• Preferably, expertise in multiple areas, including:
• API integration
• Data engineering
• AI/ML
• Database management
• MLOps
• Azure
• Software development. 

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 accommodations@criticalmass.com.

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.