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:
Proven experience with Looker and deep expertise in LookML syntax and functionality
Hands-on experience building and maintaining LookML data models, explores, dimensions, and measures
Strong SQL skills, including complex joins, aggregations, and performance tuning
Experience working with semantic layers and data modeling for analytics
Solid understanding of data analysis and visualization best practices
Ability to create clear, concise, and impactful dashboards and visualizations
Strong problem-solving skills and attention to detail in debugging Looker models and queries
Familiarity with Looker’s security features and data governance principles
Experience using version control systems, preferably Git
Excellent communication skills and the ability to work cross-functionally
Familiarity with modern data warehousing platforms (e.g., Snowflake, BigQuery, Redshift)
Experience working in cloud environments such as AWS, GCP, or Azure (nice to have)
Experience migrating from legacy BI tools (e.g., Tableau, Power BI, etc.) to Looker
Experience working in agile data teams and managing BI projects
Familiarity with dbt or other data transformation frameworks
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.