2 hours ago
Manila, PhilippinesMid Level / Senior
Responsibilities
- Own and progressively extend the dimensional modeling layer, including designing fact and dimension tables and developing new subject-area datamarts.
- Define governed, reusable GTM funnel metrics, including MQL-to-SQL definitions and handoff logic, in partnership with Marketing Ops, Sales Ops, and RevOps.
- Design, build, and maintain performant Tableau dashboards for revenue KPIs and customer journey metrics.
- Apply visualization and dashboard design judgment to translate complex data into intuitive, decision-ready views.
- Present dashboards and metric definitions to analysts and GTM managers, validate analytical logic, and incorporate stakeholder feedback.
- Gather, scope, and document analytical requirements from GTM Strategy & Insights managers and perform light ad hoc analysis.
- Extend existing dbt datamarts independently and deliver documented, cross-team-agreed data products.
Requirements
- 3–5+ years of analytics or BI experience with demonstrated ownership of dbt modeling and BI dashboards in a production environment.
- Advanced Tableau skills, including dashboard performance optimization, data sources, calculated fields, chart selection, and information design.
- Proficiency in SQL, including complex queries, window functions, CTEs, and optimization techniques.
- Hands-on experience with dbt, dbt tests, dimensional modeling, and designing star and snowflake schemas.
- Experience defining reusable metrics and exposing them consistently across BI tools, such as through Snowflake Semantic Views or the dbt Semantic Layer.
- Proficiency with Git, including branching, pull requests, and code review in a collaborative dbt development environment.
- Skill in gathering requirements, scoping ambiguous business requests, and documenting analytical requirements.
- Strong collaborative communication skills with both engineers and non-technical stakeholders.
- Preferred: experience with Salesforce, HubSpot, Google Ads, LinkedIn Ads, call-intelligence platforms such as Gong, and identity or attribution reconciliation across systems.
- Preferred: experience with Snowflake and awareness of its Coco AI capabilities.
- Preferred: experience with Lucidchart or dbdiagram.io for data documentation.
- Preferred: curiosity about Omni and n8n.
About CreatorIQ
CreatorIQ builds an enterprise SaaS platform for creator and influencer marketing, used by brands and agencies to discover partners, manage campaigns, and measure performance across social networks. The privately held company, founded in 2014 and headquartered in Culver City, California, integrates with platforms like Instagram, YouTube, TikTok, and Meta, and counts customers such as Google, Delta Air Lines, and Nestlé.
