Analytics Engineer

The Custom Group of Companies is focused on improving data usage across various departments. In this role, the Analytics Engineer will manage and enhance data assets, collaborate with stakeholders, and ensure adherence to governance best practices to support the company's mission to End Cancer for Life.

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
• Additional coding experience which could be a value-add to a marketing organization is a plus
• 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