Marketing Analystics Consultant - YAML

100% Remote

Need someone from NY, NJ (EST could be considered)

Job Summary:

• In this role, you will partner with Marketing, Strategy, and IT stakeholders to improve how we use data.
• You will own the creation, management and improvement of our various data assets, including pipelines, tables, dashboards, and other data products.
• You will also help to raise our standards for governance across data platforms and ensure alignment with institutional best practices.
• Your work will equip our teams with the data needed to make better decisions contributing to MSK’s mission to End Cancer for Life.

Job Responsibilities:

• Assist with the creation and ongoing management of data tables for use in various data applications.
• Collaborate with IT partners to complete data table creation and management work.
• Work with Analytics, IT, and Marketing stakeholders to build, optimize, scale, and manage the Business Intelligence ecosystem.
• Collaborate with internal stakeholders and agency or vendor partners to ensure alignment with Marketing Analytics perspectives.
• Champion a hybrid Service and Self-Service analytics model within Marketing and Communication.
• Educate peers while building analytics solutions to support self-service capabilities.
• Manage workspaces, data refresh processes, and dataflow creation.
• Improve data processing efficiency including automation where possible.
• Improve taxonomy, processes, and technical infrastructure that support organizational data work.
• Ensure alignment with institutional standards and governance best practices.

UPDATED JD DETAILS

• Experience working with Databricks (as a data warehouse/lakehouse solution) and using dbt within it (to build pipelines and tables)is required.
• Inherently, this also means proficiency working with SQL, Github, and .yaml files is crucial.
• Experience working with Marketing data is preferred. It’ll save us a lot of time if we can spend less effort explaining the context of certain systems to our new hire.
• Ability to clearly and concisely communicate – through messaging, documentation, and live speaking – is critical.
• Experience with PowerBI and its related ecosystem (Power Platform) is highly preferred.
• Additional coding experience which could be a value-add to a marketing organization is a plus.

Skills:

Required Skills & Experience:

• Three (3) or more years of experience working in Analytics, Data Engineering, or a similar field.
• Deep familiarity with SQL and various downstream data applications including business intelligence tools.
• Ability to understand the context of data and apply it to inform business analysis.
• Strong verbal and written communication skills with the ability to synthesize sophisticated information and convey complex ideas in an accessible manner.
• Intrapreneurial mindset with a focus on continuous improvement in deliverables and processes.

Preferred Skills & Experience:

• Experience working with Microsoft PowerBI, Databricks, dbt.
• Marketing experience.
• Working knowledge of common marketing data types including web or mobile analytics such as Google Analytics and Heap.
• Working knowledge of advertising analytics platforms including Google Marketing Platform, Meta, and The Trade Desk.
• Working knowledge of phone tracking platforms such as Invoca.