Wpromote

Wpromote

Wpromote is The Challenger Agency, specializing in digital marketing and customer acquisition that exceeds expectations.

Media
251-1K
Founded 2001

Description

  • Gather data source, data joining, data model, and data transformation requirements from clients and internal stakeholders.
  • Evaluate data visualization needs and develop reporting and insights solutions for cross-channel media measurement.
  • Manage and monitor multiple data pipelines and ETL tasks across multiple client data streams.
  • Help create a reliable and scalable infrastructure for data model builds, data set QA, and data outputs.
  • Design client data pipelines to efficiently deploy data for new dashboards and apps within Polaris.
  • Validate data from multiple sources with data engineers to provide an integrated view of digital marketing performance.
  • Create reporting dashboards in Google Data Studio and Google Looker using visualization and UX best practices.
  • Gather dashboard feedback, document product improvements, and assist with future platform enhancement requirements.
  • Identify process improvements and create documentation to support scaling reporting efforts.

Requirements

  • 5+ years of experience in reporting, BI, or analytics engineering.
  • Experience with SQL, database design, and data manipulation methodologies.
  • Experience gathering requirements and delivering data visualizations in Looker (preferred) or Data Studio in an advertising agency or similar client environment.
  • Familiarity with dbt.
  • Strong Google Sheets and Excel skills, preferably with Apps Script experience.
  • Experience working with API calls to gather and store large datasets in batch or streaming workflows.
  • Experience with at least one cloud platform such as BigQuery, Snowflake, or Redshift.
  • Experience with at least one programming language such as Python, R, AppScript, or JavaScript, preferably JavaScript or Python.
  • Knowledge of database and data warehousing design and management.
  • Understanding of ETL processes and data modeling using SQL.
  • Attention to detail with the ability to debug and troubleshoot code and queries.
  • A collaborative mindset with the ability to work independently.
  • Business and marketing data acumen, including understanding of common marketing goals, KPIs, and tactics.
  • Experience integrating and automating pipelines from multiple data sources.
  • Strong organizational and communication skills with the ability to manage multiple tasks and projects.
  • Desire to learn new tools, skills, and strategies and take initiative on new tasks.
  • Analytical and design mindset.
  • Experience with digital analytics tools such as Google Analytics or Adobe Analytics (preferred).
  • Experience with project management platforms such as JIRA or Asana (preferred).
  • Knowledge or experience in the digital marketing industry (preferred).
  • Experience with data from ad platforms such as Google, Facebook, or Microsoft (preferred).
  • Experience with data integration platforms such as Funnel or Domo (preferred).
  • Experience with data visualization platforms such as Tableau or PowerBI (preferred).
  • Immigration sponsorship is not available for this role.

Benefits

  • Remote-first culture.
  • Unlimited PTO.
  • Extended winter holiday break.
  • Flexible schedules.
  • Work from anywhere options in most U.S. states.
  • 100% paid parental leave.
  • 401(k) matching.
  • Medical, dental, vision, life, pet, and short-term disability insurance.
  • Annual ClassPass credits.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Business Analysis - GCOO-Bangalore

Capco 5K-10K Internet Software & Services

Capco, a Wipro company, is hiring a Technical Business Analyst for reporting delivery work supporting banking and financial services transformation projects.

Agile Confluence JIRA
11 minutes ago

FBS Data Management Analyst (Insurance Experience) (Remote)

Capgemini 100K+ Internet Software & Services

Farmers’ FBS team is hiring a statistical data and reporting specialist to support property and casualty insurance operations across the enterprise through data preparation, reporting, and tool support.

Power BI
26 minutes ago

Power BI / Microsoft Fabric Developer - Supply Chain & Manufacturing (SAP)

GlobalDev Tech 51-250 Internet Software & Services

Experienced Power BI / Microsoft Fabric Developer role focused on building analytics solutions for supply chain and manufacturing operations using data from SAP ERP and other systems.

Azure Power BI SQL
41 minutes ago

Director, Health Economics & Outcomes Research (HEOR)

Vida Health 251-1K Health Care Providers & Services

Vida Health is seeking a Director of Health Economics & Outcomes Research to independently generate real-world evidence that demonstrates the impact of its virtual obesity care model for commercial growth, payer strategy, value-based contracting, and clinical credibility.

Confluence GCP Git HIPAA JIRA Jupyter Machine Learning Python R SQL Statistics
56 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers