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