We are looking for a Senior Data Engineer for our team. The Senior 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 Data Services team, taking basic and essentially unusable information and refining it into the stuff of predictive models. At the forefront of our data services 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:Write queries and design data workflows to facilitate campaign development, deployment, and reporting.Establish quality control measures to ensure the accuracy of data and reportsAssist in the design, creation and documentation of database processes and business rulesProvide recommendations for continuous improvement in data accessibility and reporting as driven by the business needsParticipate in internal and client meetings to provide data strategy recommendations, domain knowledge, and expertise regarding the data in your scope of responsibilities.Work to automate & continuously optimize data processes and reportsYou have: Fluent in English (minimum B2+ reading, writing, and conversation)5+ years of experience in a data engineering or advanced analytics roleExperience writing complex SQL statements and mapping relational database structuresSolid experience building custom audiences and automation within an Enterprise campaign management solution such as Salesforce Marketing Cloud, Adobe Campaign, Unica, Eloqua, or Marketo. Leveraging both in-platform audience creation tools as well as custom query languages when available.Strong understanding of Marketing Campaign execution process (strategy, audience definition, creative development, testing, fulfilment/deployment, monitoring, reporting)Experience working with programming languages such as Python, R, Scala to ingest and manipulate data.Demonstrated experience automating the preparation and distribution of critical data (audiences, kpis) to other teams.Understanding of distributing computing (Apache Spark) to manipulate large data sets.Any data-related certifications, such as SQL, SAS, SFMC, etc., are an advantageAbility to stay abreast and inform internal teams of current best practices and trends in email design and developmentWhat We Offer:Competitive benefits packagesVacation, compassionate leave, sick days, and flex daysAccess to online services for families and new parentsEnd-of-year closure days (not deducted form vacation balance)Diversity and Inclusion Board with 12 affinity groupsInternal learning and development programsAnd 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 towork from an office a minimum of 3 days a week.The ask stems from our want to:Strengthen opportunity for continuous learningImprove collaboration and team relationships.Increase employee engagementThis 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.
