Verified Job On Employer Career Site

Job Summary:

Critical Mass is a company that values its employees and offers competitive compensation and benefits packages. They are seeking an Associate Analyst on the Marketing Sciences team who will contribute to marketing science deliverables by applying data to digital experiences and collaborating with cross-functional teams. The role involves automating processes, defining data solutions, and continuously improving data management efficiency.

Responsibilities:

• Automate manual processes using SQL, python, etc.

• Define solutions for using, extracting, and transforming 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 move data through pipelines and processes.

• Help to continuously improve the efficiency of existing automations and maintain concise and accurate datasets and processes.

• Understand the nuances of analyses on which cross-functional teams rely

• Explain the complexities involved with data extraction and transformation to team members across cross-functional groups

• Work closely with the rest of the Marketing Science and account teams to understand business context and logic

• Stay up to date on the latest industry news and techniques

• Assist in guiding data architecture and infrastructure design

Qualifications:

Required:

• Proficiency in English (B2+ level reading, writing, conversation)

• A Bachelor’s degree or higher in a quantitative or technical field, including but not limited to: Computer Science, Mathematics, Engineering, Statistics, and/or related disciplines requiring proficiency in data management, analysis, and engineering fundamentals.

• Working knowledge of SQL (including PostgreSQL) and python, understanding of how to work with APIs and database components like schemas, tables, stored procedures, triggers, etc.

• Understanding of data and pipeline management and SDLC best practices, including but not limited to: ETL/ELT; building and understanding DAGs; CI/CD; version-control

• Understanding of basic data visualization methods and how to get the data in the right shape to tell a clear and concise story

• Demonstrated ability to learn new tools and techniques in the data analytics domain quickly

• A knack for documenting your work and processes thoroughly, clearly, and intuitively

• An ability to proactively communicate needs, roadblocks, statuses to the team, stakeholders, and leadership with clarity – you’re not afraid to reach out for help and consultation whenever needed

• A demonstrated ability to adapt in adverse situations, think outside the box in collaboration with the team to come up with creative solutions to tough problems

• Strong critical thinking skills: you’re willing to ask questions and go the extra mile to understand processes and to understand the why behind the work and not just the how.

• A strong desire to learn and grow in your role.

Preferred:

• Familiarity with working in AWS and DevOps.

• Familiarity with third party ETL/pipeline and data orchestration tools (e.g., Rivery/Boomi, FiveTran, etc.) and/or distributed processing platforms like Databricks.

• Some exposure working with Tableau, PowerBI, or similar business intelligence and visualization tools.

• Familiarity with at least one of the following areas is an asset: Advertising platform pixel tracking, Dynamic Creative Optimization, Digital media taxonomy nomenclature.

• Experience with digital media intelligence platforms (e.g., SimilarWeb, Brandwatch, etc.)

Company:

Critical Mass is a digital experience design agency with a relentless focus on the customer. Founded in 1996, the company is headquartered in Calgary, Alberta, CAN, with a team of 1001-5000 employees. The company is currently Late Stage. Critical Mass has a track record of offering H1B sponsorships.