Mirlan D.

I build data pipelines, warehouses, and dashboards for product, marketing, and game analytics. I can help you connect fragmented data sources, automate reporting, and create datasets your team can use to understand revenue, acquisition and retention. Top Rated Plus on Upwork | $100K+ earned | 100% Job Success I work across the full data lifecycle: data sources → ingestion → raw storage → warehouse → transformations → metrics → dashboards and agents What I can help you with • Data pipelines and integrations: Extract and combine data from application events, databases, and advertising APIs using SQL and Python. • Warehouses and data modeling: Build or improve BigQuery and ClickHouse warehouses, with transformations in dbt, Dataform, or SQLMesh. • Product and marketing reporting: Create datasets and dashboards for ROAS, attribution, retention, funnels, cohorts, and revenue. • Integration troubleshooting: Investigate authentication failures, API changes, schema issues, and discrepancies between source platforms and reports. Relevant experience My work with SaaS, mobile app, and game teams includes building event-tracking systems, data warehouses, automated pipelines, and product and marketing data marts that support BI dashboards. I also designed and built Rawbbit, a self-hosted, open-source event analytics platform for game development teams. It combines API-based event collection, NATS JetStream, Parquet storage, ClickHouse, dbt, and Metabase. My integration experience includes Meta Ads, Google Ads, AppsFlyer, AppLovin, Appodeal, Singular, Shopify, HubSpot, and other platforms. I also configure AI assistants connected to databases and project documentation through MCP, with defined permissions and validation workflows. Technology stack: - SQL, Python, dbt, Dataform, SQLMesh - BigQuery, ClickHouse, PostgreSQL - Parquet, GCS, S3-compatible object storage - GCP: Cloud Run, Pub/Sub, Scheduler, Secret Manager, Artifact Registry - NATS JetStream, Docker, Linux VMs - Metabase, Tableau, Looker - Codex, Claude Code, OpenCode, OpenClaw How I work I start by clarifying the reporting needs, source data, and operational constraints. I focus on systems that are understandable, maintainable, and practical for your team to operate. I can help with a specific pipeline or reporting issue, or build the data infrastructure connecting your sources to your dashboards. Send me a brief description of your current setup and what you need to improve. We can define the scope and a practical first step.