Marketing Analytics - Data Engineering
Goal
To have a clear, concise, and efficient process to use when engaging Marketing Analytics Data Engineering (Robert Kohnke).
Engagement Process/How to Request Help
This information is in addition to the Marketing Analytics - How We Work section of the core page. Where there is conflicting information, the information on this page supersedes the core page.
- Open an issue in the Marketing Analytics Project with the
MktgAnalytics-Data-Ops
label on it. - Fill out the template,
data_engineer_request
to expedite your issue, the task at hand, and eliminate redundant back-and-forth between requester and assignee.- Main audience: Marketing Analytics team
Areas of Responsibility
Owned
- Model creation, completion, correction, and improvement/standardization
- Ex. Creation of Lead 2 Revenue model; adjusting ABM Influence code base; creating standard SQL snippet/repos; building new EDM models from RAW/Source tables for Marketing
- Main point of contact for interfacing with Central Data Team (Data Eng cadence) - ensuring MS&A team issues are being prioritized and actioned, advocating for projects our team is working on
- Ex. Making and updating, as well as processing/completing MRs with CDT.
- Ex. Working with CDT to build out BATP Snapshots and Cohort analysis
- Authoring, updating, reviewing code for use in DBT, Tableau, Snowflake
- Ex. General code reviews: ABM, DG influenced, Marketing Pipe; Eventually, creation of Tableau-specific models and subsets of models
Supporting
- Support maintaining existing code and bug fixes when needed
- Ex. Troubleshooting of team’s code when needed
- General coding - help, support, work, and creation
- Ex. Coding reviews/discussions to build out something new/improve something that already exists
c104140c
)