Data Engineer

Job Description

Critical Mass is seeking a Data Engineer to join their Marketing Science team. The Data Engineer will be responsible for facilitating the flow of raw files into harmonized tables, automating manual processes, and defining solutions for data extraction and manipulation. The ideal candidate will be able to work with little documentation and vague direction from business stakeholders, turning chaos into an operational process.Role involves:

• Automating manual processes through SQL, Python, etc.
• Defining solutions for using, extracting, and manipulating data.
• Analyzing documentation and proposing data extraction solutions.
• Writing code that uses APIs to download and upload data.
• Continuously improving the efficiency of existing automation.
• Providing the “voice of reason” regarding data possibilities.
• Understanding the nuances of the analysis required.
• Explaining the complexities involved with data extraction to analysts.
• Working closely with the rest of the MKS and account teams.
• Staying up to date on the latest industry news and analysis techniques.
• Assisting in tagging and data infrastructure design.

Requirements:

• 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.
• Data savvy individual with good knowledge and hands-on experience in SQL queries.
• Understanding of 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 Critical Mass offers:

• 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.

Critical Mass values its employees and requires team to work from an office a minimum of 3 days a week.