Data Engineer, Unified Analytics

Frequence is the only end-to-end platform for media companies and agencies to grow and automate their advertising sales and operations while integrating owned and operated media. Through its full-stack proposal, workflow, and campaign-management software, Frequence drives revenue with best-in-class tools to sell, optimize, and report omnichannel advertising campaigns.

Frequence is a Madhive Company. Madhive is the leading independent and fully customizable operating system built to help local media organizations build profitable, differentiated, and efficient businesses.

Learn more about how Madhive and Frequence work together here.

We are looking for an experienced Data Engineer to lead the end-to-end migration of our data analytics and reporting environment to Looker. This role will play a key part in designing scalable data models, translating business logic into LookML, and enabling teams across the organization with self-service analytics and actionable insights.

You will work closely with stakeholders across data, engineering, and business teams to ensure a smooth, efficient transition to Looker, while establishing best practices for data modeling, governance, and dashboard development.

What you'll do :

• Lead the migration of existing BI tools, dashboards, and reporting infrastructure to Looker
• Design, develop, and maintain scalable and efficient LookML data models, including dimensions, measures, and explores
• Build and refine Looker dashboards and reports that are intuitive, actionable, and visually compelling
• Collaborate with data engineers and analysts to define semantic layers and ensure consistency across data sources
• Translate business requirements into technical specifications and LookML implementations
• Optimize SQL queries and LookML models for performance and scalability
• Implement and manage Looker's security settings, permissions, and user roles in alignment with data governance standards
• Troubleshoot issues and support end users in their Looker adoption
• Maintain version control of LookML projects using Git
• Advocate for best practices in BI development, testing, and documentation

Who you are :

Why Frequence

Frequence is a dynamic, diverse, innovative, and friendly place to work. We embrace our differences and believe they fuel our creativity. We come from varied backgrounds and think that's important. Whether it's taking ideas from previous lives and applying them in different ways or creating something completely new, we are all trail-blazing team players who think big and want to make an impact.

We are committed to cultivating a culture of inclusion and collaboration. We welcome diversity in education, culture, opinions, race, ethnicity, gender identity, veteran status, religion, disability, sexual orientation, and beliefs.

Please be advised that we will NOT be using third-party recruiting agencies for this search.

Skills Required

BigQuery, Git, Gcp, snowflake , dbt, Azure, Redshift, Sql, Aws