Marketing Analystics Engineer - YAML

Amtex Systems Inc is seeking a Marketing Analytics Engineer to partner with Marketing, Strategy, and IT stakeholders to enhance data utilization. The role involves managing data assets, improving data governance, and equipping teams with necessary data for informed decision-making.

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
• Proficiency working with SQL, Github, and .yaml files is crucial
• Ability to clearly and concisely communicate – through messaging, documentation, and live speaking – is critical
• 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
• Experience working with Marketing data is preferred
• Experience with PowerBI and its related ecosystem (Power Platform) is highly preferred
• 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