DWH Architect

About Us

At Campaignswell, we're transforming marketing analytics with our AI-powered predictive platform used by apps, games, and e-commerce brands worldwide. We deliver highly accurate lifetime value (LTV) predictions within hours and unify product, marketing, and monetization analytics in a single platform. Founded in 2023 and headquartered in San Francisco, our team is building the future of data-driven growth. As we scale, data quality and reliability are becoming foundational pillars of our product — and that's where you come in.
We are looking for a DWH Architect to define and evolve the data warehouse architecture. You will be the go-to person for all architectural decisions — from data modeling and schema design to infrastructure scaling and performance optimization.

Responsibilities

• Own the end-to-end DWH architecture: define target data models, layering strategy, and schema evolution approach.
• Make strategic decisions on DWH expansion: new source integration, schema evolution, and performance tuning.
• Design and maintain the transformation layer — ensure code quality, modularity, testing, and documentation standards across the project.
• Architect data ingestion pipelines from various sources and downstream into Campaignswell UI.
• Manage and optimize the MPP Database environment: cost control, query performance, cluster configuration.
• Establish and enforce data governance practices: naming conventions, data quality checks, lineage tracking, and access control.
• Collaborate with CSM, product, and marketing analytics teams to translate business requirements into robust data models.
• Communicate data requirements and dependencies with Integration and Data Science teams — ensure new data source integrations and partner data feeds are aligned with DWH standards and timelines.
• Participate in managing the Data Engineering team: code reviews, technical mentoring, and contributing to hiring decisions.
• Proactively identify bottlenecks, technical debt, and opportunities for improvement across the data platform.

Requirements

• 5+ years of experience in data engineering / data warehousing, with at least 2 years in an architect role.
• Strong hands-on expertise with Data Vault methodology (raw vault, business vault, information marts).
• Production experience with dbt — advanced knowledge of macros, incremental models, tests, and packages.
• Deep knowledge of Redshift, BigQuery, Snowflake, etc.: architecture internals, performance optimization, cost management, and security best practices.
• Solid understanding of S3-based data lake patterns and data ingestion strategies (batch and near-real-time).
• Experience with Airflow or similar orchestration tools.
• Domain expertise in mobile/web Performance Marketing — clear understanding of subscription-based monetization, ad revenue models, and one-time payment flows.
• Experience working with attribution data, SKAN, MMP integrations (AppsFlyer, Adjust, etc.), ad network APIs, and campaign-level granularity.
• Strong SQL skills and ability to reason about complex analytical queries.
• Experience with CI/CD for data pipelines and version-controlled analytics workflows (Git).
• Experience working alongside a data engineering team: code reviews, technical guidance, and knowledge sharing.
• Excellent communication skills — ability to articulate architectural decisions and trade-offs to both technical and non-technical stakeholders.
• English level: B1.

Nice to Have

• Familiarity with BI/analytics layer (Looker, Tableau, Metabase) and how DWH design impacts downstream reporting.
• Knowledge of data privacy frameworks relevant to mobile marketing (GDPR, ATT, CCPA).
• Experience with reverse ETL or operational analytics patterns.
• Background in Python for data pipeline tooling and automation.
• Exposure to real-time/streaming architectures (Kafka, Kinesis).
• Contributions to the dbt or Data Vault community (packages, blog posts, talks).

What We Offer

• Competitive salary + performance bonus.
• Fully remote with flexible working hours.
• Home office stipend and learning & development budget.
• 25 days holiday (+ local public holidays).
• Regular team offsites and a culture that actually lives its values.

Campaignswell is an equal opportunity employer. We celebrate diversity and are committed to building an inclusive team. If you're passionate about helping brands grow through smarter data and love collaborating across disciplines to deliver impact, we’d love to hear from you!