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 the company'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.
Requirements
- 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.
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.
Required 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.
