Bigquery jobs

...On Facebook pages we need posts, comments, likes, shares, user profiles, comment timestamps, anonymised user IDs and full engagement counts. Instagram should follow the same logic for public posts. Everything has to run automatically each day inside Apify, with retry logic and clear logging. Data flow & analysis Raw JSON or CSV should land in an Apify dataset, flow into a durable database (BigQuery, Postgres or similar) and trigger analysis. The analysis layer must surface sentiment (positive / negative / neutral), engagement trends, keyword frequency, issue clustering and narrative mapping, influencer and account impact tracking, plus early-signal virality detection. Feel free to draw on open-source NLP libraries—Hugging Face Transformers, spaCy, Vader, or your pref...

...workflows. Support in performance tuning, debugging, and data migration activities. Offer guidance on data architecture, best practices, and real-time project execution. Technical Skills Required (any of the following): Programming: Python, SQL, PySpark ETL Tools: Apache Airflow, Talend, Informatica, or similar Cloud Platforms: AWS (Glue, Redshift, S3), Azure (Data Factory, Synapse), or GCP (BigQuery) Databases: PostgreSQL, Snowflake, MySQL, MongoDB Big Data Technologies: Hadoop, Spark, Databricks (preferred) Version Control / CI-CD: Git, Jenkins Ideal Candidate: Has 10+ years of experience in data engineering and related technologies. Strong in troubleshooting, architecture design, and real-time project handling. Flexible for US shift hours if required. Excellent c...

I have a Python script that currently processes real estate data and I need it streamlined before pushing the results into Google BigQuery. Here’s what I want done: • Remove any unused functions so the file stays lean. • Optimize the functions we actually use—speed and readability both matter. • Refactor variable and function names to a clear, consistent style. Once the code is tidy, finish by loading the processed data into my existing BigQuery and Github dataset. I’ll provide repository access, sample data, and the target table schema. A quick walkthrough of what you changed plus instructions to rerun the pipeline on my side will wrap things up.

We're a healthcare business looking to build automated dashboards in Looker Studio. Our data currently lives in Google Sheets, but the spreadshee...business looking to build automated dashboards in Looker Studio. Our data currently lives in Google Sheets, but the spreadsheets have become slow and hard to manage. We want to: - Pull data automatically from multiple sources via API keys (Rethink, Rippling, Google Ads) - Store and process data in BigQuery - Build dashboards for key metrics like clinician and site performance, billable vs admin time, retention, and ad spend - Allow limited data overrides when needed - Experience with Looker Studio, BigQuery, and healthcare analytics is preferred. - Must be available in CST timezone. - Responsive communication (quick replies...

...AppSheet and Spreadsheets. We also ask that you review the existing programs in Google Cloud and organize them by deleting any unused programs. [Current Environment] ・Google Workspace (Corporate) ・Google Cloud ・CloudRun ・BigQuery ・AppSheet ・Spreadsheet [CSV Synchronization Program] ① Receive the specified trigger and launch CloudRun. →Scheduled launch: Launch every hour between 9:00 AM and 10:00 PM every day. →Manual launch: Send a webhook from AppSheet or GAS. ② Log in to the SubscriptionPay admin panel and retrieve the CSV data. ③ Update the data into individual BigQuery tables. [Creating an Integrated Table] Create an integrated table for reference in AppSheet and Spreadsheets. We will also need to integrate payment data from the Stripe payment system for hist...

Initial requirement I want to turn our raw operational data in...easy-to-read Power BI dashboard that zeroes in on workflow performance. The data is imported from excel file Future Requirement All tables already live in Google BigQuery, so experience with the Power BI ↔ BigQuery connector—or at least solid SQL skills for BigQuery—will speed things up Here’s what I need: • Connect to the existing BigQuery tables (or the extracts I’ll provide) • Publish the finished report to the Power BI Service and configure user access. Deliverables A fully documented .pbix file with all DAX measures. Acceptance criteria (Not immediate requirement) – All numbers reconcile with the underlying BigQuery queries. Se...

...AppSheet and Spreadsheets. We also ask that you review the existing programs in Google Cloud and organize them by deleting any unused programs. [Current Environment] ・Google Workspace (Corporate) ・Google Cloud ・CloudRun ・BigQuery ・AppSheet ・Spreadsheet [CSV Synchronization Program] ① Receive the specified trigger and launch CloudRun. →Scheduled launch: Launch every hour between 9:00 AM and 10:00 PM every day. →Manual launch: Send a webhook from AppSheet or GAS. ② Log in to the SubscriptionPay admin panel and retrieve the CSV data. ③ Update the data into individual BigQuery tables. [Creating an Integrated Table] Create an integrated table for reference in AppSheet and Spreadsheets. We will also need to integrate payment data from the Stripe payment system for his...

Data Scientist (SQL / Business Intelligence) Company Overview: We are an Outsourcing / Contract Specialist Team that supports clients with enterprise-grade analytics and business intelligence systems. We are seeking a Data Scientist focused on SQL, dashboarding, and strategic insights. Job Summary: The cand...metrics. Maintain data accuracy, security, and governance standards. Requirements: 3+ years of experience in data analytics, BI, or data science. Advanced SQL skills and familiarity with ETL workflows. Experience with data visualization tools. Strong business acumen and communication skills. Preferred Skills: Experience with Python for automation or light scripting. Knowledge of Snowflake, BigQuery, or Redshift. Compensation: $40–$75 per hour or $85,000–...

I am hiring a senior iOS developer (preferably a team) skilled in SwiftUI and Firebase/Cloud to build a feature-complete confidential application. The app integrates AI-driven modules, analytics, and secure data wo...reporting • Optimize app performance, latency, and accessibility • Integrate AI modules using secure and efficient cloud endpoints • Prepare CI/CD pipelines and handover documentation ⸻ Required Skills: • Swift 5+, SwiftUI, Combine, AVFoundation, Accelerate, Vision, Metal/MPS • Firebase (Auth, Firestore, Functions, Storage, Remote Config, Analytics) • Google Cloud (Cloud Run, Pub/Sub, Scheduler, BigQuery, Secret Manager) • TypeScript or React for admin panel • Experience with AI or RAG model integration • DevOps (Fastlane, ...

...and proof-of-deletion through logs and metrics. * Implement safeguards—dry runs, approvals, dependency checks—to prevent unintentional data loss. * Collaborate with compliance and security teams on data governance and regulatory requirements (GDPR, CCPA, etc.). What You’ll Bring * Proven experience architecting data platforms on AWS, GCP, or Azure using object stores, warehouses (Snowflake, BigQuery, Redshift), or lakehouse frameworks (Databricks, Delta Lake, Apache Iceberg, Hudi). * Strong background in data lifecycle management, row-level deletes, and partition strategies. * Hands-on experience with workflow orchestration and policy-as-code tools (Apache Kafka, Airflow, OPA, Rego, etc.). * Knowledge of data governance, privacy, and compliance requirements re...

I’m ready to move an existing data set into Google BigQuery and need a specialist who can handle the full migration quickly and reliably. Your task is to: • Assess my current source data (format and volume are straightforward—think CSV and JSON files stored in cloud storage). • Design and execute the import into BigQuery, setting up the optimal dataset structure, table partitions, and clustering where it makes sense. • Validate that all records have transferred accurately and perform spot checks on row counts and schema integrity. • Provide a concise hand-off note describing the steps you took and any ongoing maintenance tips. Timing is critical—I’d like this wrapped up as soon as possible. When you apply, focus on your B...

...proactively. Maintain clear documentation of cloud architecture and processes. Requirements: 8+ years in cloud/infra, with 4+ years hands-on in GCP. Experience of LiveKit, Twilio, Gemini, and a homegrown TTS is preferred. Proven experience as a Cloud Architect (with DevOps/automation background). Strong knowledge of GCP services (Compute Engine, GKE, Cloud Storage, Cloud Functions, Pub/Sub, BigQuery, IAM). Proficiency with DevOps/IaC tools: Terraform, Jenkins, Git, Docker, Kubernetes, Ansible. Solid understanding of cloud networking, security, and governance. Experience with scripting/automation (Python, Bash, etc.). Familiarity with monitoring tools (Prometheus, Grafana, Google Cloud Monitoring). Certification (Google Cloud Professional Architect) preferred. Notes: Background...

...that surfaces my priority KPIs (for ex: Profit Margins, Sales Volume, Ecommerce Analytics, and Geographics—using Bar charts, Line graphs, Pie charts, and simple Tables.) • Enable real-time updates for WooCommerce data so the numbers stay current without manual refreshes. • Create email or Slack alerts that notify me in some scenarios. • Allow for optional data pulls: GA4 traffic housed in BigQuery and Meta Ads spend imported via weekly or monthly CSV. Current Setup WooCommerce (multiple sites): orders, products, returns, tax amounts per country (there is different currencies). A custom Laravel return portal: we should use this source for return requested SKU's to see most returning SKU's. COGS: maintained in the TR Woo store in TRY (SKU-level...

...images, run colour conversion, apply classification rules, and publish updated mapping tables. • Scale seamlessly as new brands, shades, and swatch batches are added. • Maintain reliability with monitoring, logging, and alerting so the pipeline runs hands-off. Preferred stack & suggested components • GCP services such as Cloud Storage (raw images), Cloud Functions / Cloud Run (processing), BigQuery (analytical tables), and Composer or Dataflow for orchestration. • Python remains the execution language; modular, well-documented code is essential. • CI/CD via Cloud Build or GitHub Actions. Deliverables 1. Architecture diagram and setup scripts (Terraform or Deployment Manager). 2. Refactored, containerised Python modules ready for Cl...

...description of the collection methodology (API endpoints, libraries, rate-limit strategies, or archival sources) and a data dictionary should accompany the delivery. JSON, CSV, or Parquet are all acceptable provided the schema is consistent and well documented. I am happy to grant temporary API keys, but if you already have access—Academic Research API, GNIP archives, Meltwater, custom TikTok scrapers, BigQuery social data stores, etc.—please let me know. Provenance is critical, so every record must be traceable back to its original pull. Acceptance criteria • Coverage: at least 24 consecutive months for both X and TikTok • Fields: everything listed above present and non-null for >95 % of records • Format: one zipped archive per platform plus...

I need a production-ready customer analytics dashboard built in Looker Studio that pulls live data from both BigQuery and Google Sheets. The work starts with translating my business goals and KPI definitions into a clean data model, then designing an intuitive layout that highlights customer acquisition, engagement, and retention metrics at a glance. You will connect the two data sources, set up reliable refresh schedules, and apply visualization best practices so the dashboard loads quickly and tells a clear story. Interactive filters, drill-downs, and period-over-period comparisons should be configured out of the box. If a RegEx tweak or a touch of CSS/JavaScript helps prototype a smarter component, feel free to use it—those skills are welcome but not essential. The delive...

I run several web servers on Google Cloud Platform and rely solely ...Specific recommendations—rightsizing, autoscaling, instance scheduling, possible switch to Spot VMs or predefined machine types—each with estimated savings. • A concise action plan I can follow (or have you execute later) to implement the changes safely. You’ll get read-only access to the project, analyze current utilization with tools like Cloud Monitoring, Recommender, and Billing export to BigQuery if needed, then walk me through the findings on a short call. No changes should be applied directly during the audit phase; I first want to understand every suggestion. If you’ve slashed Compute Engine costs for other clients and can point to real percentages saved, I’m eager ...

... • Provide a slim demo (code snippets or a small repo) that ingests sample events and surfaces live metrics developers care about—active sessions, feature clicks, error spikes, and latency. • Outline success criteria: engagement uplift signals to watch, alert thresholds, and a simple way to A/B test improvements. I’m open to the stack you prefer—whether that’s Firebase, AWS Kinesis, Google BigQuery, or a lean Node.js/Python pipeline—so long as setup is straightforward for a small team. A user-friendly interface and responsive design would be nice to have, but the must-have is the real-time insight itself. Deliverables 1. Architectural diagram (PDF or image) 2. Annotated source (Git repo or ZIP) with quick-start instructions 3. One...

...freelancer to build a lightweight but robust real-time data engineering and dashboard system. The system should: Ingest streaming data (simulated or from external sources). Connect to both on-premises storage and cloud platforms (e.g., Azure Data Lake or Blob Storage). Prioritize real-time data processing to handle continuous streams efficiently. Integrate with data warehouses such as Snowflake, BigQuery, or Redshift for scalable data management. Provide dynamic, interactive visualizations using tools like Streamlit or Power BI. Be responsive, reliable, and easy to deploy. Deliverables: Clean and documented code (Python preferred) Database schema and pipeline setup Real-time dashboard with auto-refresh Deployment instructions Budget: $30 – $250 USD (Micro Proje...

...actionable insight. The core objective is straightforward: take the dataset as-is, clean it, explore it, and surface the key patterns that will guide my next decisions. You’ll work with whatever stack you’re fastest in—Python (pandas, NumPy, scikit-learn), R, SQL, or even a BI platform like Power BI or Tableau—so long as the final output is easy for me to digest and reuse. Cloud tools such as BigQuery or Snowflake are available if local processing won’t cut it. Deliverables • A cleaned, well-documented dataset ready for future queries • An analytical report highlighting the most significant sales trends and correlations • Interactive visuals or dashboards that let me slice the data on my own Accuracy, transparency on methods, ...

...answer routine queries, route complex calls to live agents, and keep transcripts neatly logged in our CRM. Think Twilio or Amazon Connect for telephony, Dialogflow or a comparable NLU engine for intent detection, and seamless fallback logic to maintain a human-grade experience. • Data analysis – Once calls, chats, and other customer interactions are flowing in, I want automated pipelines (Python, BigQuery or similar) to aggregate, label, and visualise trends. I should be able to open a dashboard and instantly see sentiment, common pain points, and campaign performance without manual number-crunching. • Marketing campaigns – Using the insights above, the next step is automated audience segmentation and multichannel outreach. If you’re comfortable tyin...

...than real-time speed. Here’s how I picture the workflow: at the start of each month an automated job reaches into Helium 10 (API, browser automation, or another proven method—whatever is most robust) and exports the latest sales snapshot. The script then cleans the raw output and drops a neatly structured CSV or Google Sheet into a shared drive. If you can also push the results straight into BigQuery or Snowflake, even better, but a flat file is the minimum I need. Deliverables • A documented script or small app that logs in, extracts revenue, units sold, and average selling price, and saves them in a tabular format • Step-by-step setup instructions so I can run the job on my own machine or a cloud function • A quick test run showing last month&...

...constant pulse on my active campaigns. The single place of truth should pull live data from Google Ads, Google Analytics, and our network of Google Business Profiles, blend it cleanly, and surface the three numbers my team cares about most—click-through rate, conversion rate, and cost per acquisition. Here’s how I picture it working: • Seamless, scheduled connections to the three sources above (BigQuery or direct connectors—whichever keeps refreshes fast and reliable). • A clear top-level snapshot for yesterday, last 7 days, and month-to-date, broken out by platform. • Drill-downs that let me filter by campaign, ad group, location, or date range without breaking the visuals. • Thoughtful use of scorecards, trend lines, and heat-maps so...

...Requirements: - Proven experience with Google Tag Manager, GA4, and Enhanced E-commerce implementations. - Ability to debug and test DataLayer pushes. - Understanding of consent mode and cookie compliance. - Clear documentation and communication in English or German. Bonus: - Experience with WooCommerce or headless setups (WordPress + Nuxt/Vue frontend). - Familiarity with server-side tagging or GA4 BigQuery exports. Important: This is not just a tag placement job — we need a complete, reliable analytics foundation that can be extended in the future. More events may be added later by the developer as we refine the user journey and marketing attribution....

...Predictive Analytics, Data Mining QA & Testing Manual Testing, Automation (Selenium, Cypress, Playwright) API Testing (Postman, SoapUI), Performance (JMeter, LoadRunner) Mobile App Testing, Security Testing Test Planning, Regression, CI/CD Integration Database Developers SQL (MySQL, PostgreSQL, Oracle, MS SQL Server) NoSQL (MongoDB, Cassandra, CouchDB, DynamoDB) Data Warehousing (Snowflake, BigQuery, Redshift) ETL Pipelines, Data Modelling, DB Optimization Architects / Solution Designers Enterprise Architecture (TOGAF, Zachman) Cloud & Infrastructure Architects (AWS, Azure, GCP) API Architecture, Integration Frameworks, Middleware (Apigee, MuleSoft, Kafka) Microservices, Event-Driven Design, Scalability Engineering Support & Operations Application Support (L1&ndas...

...design. You’ll be responsible for creating the core backend and AI systems that make this vision possible. Database Integration • Work with a large public dataset (tens of millions of text entries). • I’ll provide the source, schema, and API access at project start. • Implement automated pipelines to harvest, deduplicate, normalize, and store data in a scalable system (e.g., PostgreSQL, BigQuery, or OpenSearch). • Maintain low-latency querying and indexing for real-time inference. • Design for data growth and modular scalability. AI Requirements • Use an existing public database of job listings or job categorizations as a base. • Build an AI model in Python (PyTorch) to power accurate job matching and recommendation. ...

Create a single dashbo...**cost per conversion** and **cost per purchase** over time for each product, allowing an easy comparison between platforms. **Requirements:** * Clean, easy-to-read **daily line graphs** (no real-time data needed; daily refresh is enough). * Connect and prepare **Google Ads and Meta Ads data**, grouped by product * Include **platform-specific views** and a **comparison view**. * Optional use of **BigQuery/blended data** (Looker) or equivalent setup (Zoho). **Deliverables:** * Shareable dashboard with filters for product and campaign. * Automated **daily data refresh** with brief documentation. * Short **walkthrough or recording** showing how to adjust filters, dates, and add new campaigns. * Metion my name (Ishi) on your proposal so I see you read this p...

...order-fulfilment performance, and finance-oriented snapshots that tie back to Xero to allow invoicing from CartonCloud due to tailored rate cards per client. What I need from you • Map the CartonCloud data model and expose the right endpoints (API or flat file) so Data Studio can consume stock, order and financial data without manual exports. • Build a reliable, automated refresh pipeline—BigQuery, direct connector or your preferred method is fine so long as it stays future-proof and requires minimal upkeep. • Design the initial dashboards: inventory health, fulfilment KPIs and financial summaries. I’m looking for drill-downs, filters by SKU or customer, and clean visual storytelling rather than eye-candy. • Document the setup so my team c...

...with brokers/marketing to turn AI traffic into **calls, WhatsApps, and bookings**. ## You are * A hybrid **SEO + data + product** profile with 5–8 yrs in technical SEO/content systems; bonus if you’ve shipped **RAG/LLM** projects. * Pro in ****, sitemaps at scale, log analysis, multilingual SEO, and Core Web Vitals. * Comfortable with **Python/JS** for automation, **GSC/GA4/BigQuery**, and one cloud (GCP/AWS/Azure). * Clear communicator who can brief designers, guide devs, and align execs on KPIs. ## Nice to have * Experience with **vector search/RAG**, **OpenAI/Anthropic** APIs, **LangChain/LlamaIndex**. * Built **public data feeds/APIs** consumed by partners or AI crawlers. * Yachting domain knowledge (builders, models, charter terms). ## Success metrics (your ...

Remote - Open to candidates worldwide (US, UK, India, and more) Strong communication skills is a must. we value engineers who can explain ideas clearly. 1. Data Engineer Key Skills: - Python, SQL, Spark, dbt - Airflow, Azure Data Factory, or Prefect - Snowflake, BigQuery, or Redshift - Kafka, Kinesis, or Flink (streaming) - CI/CD (GitHub Actions, Jenkins), Docker, Terraform 2. AI/ML Engineer / Data Scientist Key Skills: - Python (Pandas, Scikit-learn, PyTorch, TensorFlow) - ML lifecycle: MLflow, SageMaker, or Databricks - LLMs, NLP, time-series, recommendation systems, Computer Vision, GenAI - FastAPI/Flask for deployment, Hugging Face, LangChain - Experience with cloud-based ML: AWS/GCP/Azure 3. Full Stack Engineer Key Skills: Backend: Node.js / .NE...

...with brokers/marketing to turn AI traffic into **calls, WhatsApps, and bookings**. ## You are * A hybrid **SEO + data + product** profile with 5–8 yrs in technical SEO/content systems; bonus if you’ve shipped **RAG/LLM** projects. * Pro in ****, sitemaps at scale, log analysis, multilingual SEO, and Core Web Vitals. * Comfortable with **Python/JS** for automation, **GSC/GA4/BigQuery**, and one cloud (GCP/AWS/Azure). * Clear communicator who can brief designers, guide devs, and align execs on KPIs. ## Nice to have * Experience with **vector search/RAG**, **OpenAI/Anthropic** APIs, **LangChain/LlamaIndex**. * Built **public data feeds/APIs** consumed by partners or AI crawlers. * Yachting domain knowledge (builders, models, charter terms). ## Success metrics (your ...

I need to connect Housecall Pro to BigQuery via API for a data transfer. Requirements: - Transfer job details and payment records. - Include as much info as possible for Looker Studio KPIs. - Update data in BigQuery daily. Ideal Skills: - API integration experience. - Familiarity with Housecall Pro and BigQuery. - Looker Studio expertise. - Strong data management and ETL skills.

...need a data-savvy partner to turn our existing user analytics into actionable insights. The focus is purely on user behavior—specifically session duration, user retention, and in-app purchases. All raw data is already flowing through Google Analytics for Firebase; what’s missing is the clear story behind the numbers. Here’s what I’m after: • A clean extraction of the relevant event data (BigQuery is enabled). • Visual dashboards that surface trends and anomalies at a glance—Tableau, Data Studio, or native Firebase charts are all fine so long as they highlight the three metrics above. • A written summary that explains what drives longer sessions, where we’re losing users, and how purchase behavior correlates with engageme...

...configure databases on GCP (Cloud SQL, BigQuery, Firestore, or others as required) • Optimise database performance, indexing, and queries for production workloads • Implement backup, recovery, and monitoring strategies to ensure minimal downtime • Secure databases through proper access control, encryption, and compliance best practices • Collaborate with our development team to ensure seamless integration with applications • Provide technical documentation and knowledge transfer for internal teams • Offer ongoing maintenance and troubleshooting support on an as-needed basis Requirements • Proven track record in managing databases on Google Cloud Platform • Strong expertise in SQL and database design • Hands-on experience with...

...can use for month-over-month decision-making. I also expect a concise read-out deck or dashboard that highlights incremental lift, channel contribution, and scenario planning comparisons so we can quickly adjust spend or tweak pricing and product variables. Access to raw data, tracking parameters, and naming conventions will be supplied on kickoff. I’m looking for someone comfortable with SQL, BigQuery, Python or R for preprocessing if needed, and of course deep familiarity with Meridian’s modeling workflow and visualization layer. If you’ve shipped similar MMM projects—especially inside Google’s ecosystem—please share a brief note on your approach and link to any non-confidential examples. I’d like to get moving right away and aim to r...

We are looking for a highly qualified Google Cloud Specialist to conduct a project analysis of our current and planned infrastructure on Google Cloud. T...Provide recommendations on architecture, scalability, security, and compliance with best practices. Advise on AI/ML workflows, data engineering pipelines, and cloud-native development strategies. Support with documentation and prepare a potential roadmap for implementation. Requirements: Proof of active certifications listed above. Strong, hands-on experience with Google Cloud services (GKE, BigQuery, Dataflow, Vertex AI, IAM, Monitoring). Excellent communication skills to present findings and recommendations clearly. Deliverables: A detailed project analysis report including technical recommendations and an implementatio...

...area-specific. Configure prompts, scenarios, difficulty levels, cooldowns, rubrics, thresholds. Preview/Test mode to validate flows before publishing. Share campaign URLs with target audiences. Full reporting: view results, play recordings, export. Report Analyst Dashboards by campaign/cohort/area/user; risk indicators, score distributions. Playback of audio/video recordings; export to CSV/BigQuery. No access to edit campaigns. End User Azure AD SSO. Capture ID photo (government ID) and a selfie → system performs 1:1 face match and liveness (blink/head-turn). Conversational training with the AI avatar (voice-to-voice), scenarios selected by area (60% area-specific, 40% general), adaptive difficulty, and instant score + feedback. ****Functional Modules Auth &...

I need an experienced backend developer to build and integrate the backend for a new mobile chat & social app. The frontend is already designed in Figma and implemented in Flutter (iOS & Android). B...Translate or DeepL • Push Notifications: Firebase Cloud Messaging (Android) & Apple Push Notification Service (iOS) • In-App Purchases: Google Play Billing & Apple In-App Purchase • Ads: Google AdMob or Meta Audience Network Admin Panel (Web): • Framework: or React • Purpose: Manage users, view reports, handle unblock requests, monitor analytics Analytics & Monitoring: • Analytics: BigQuery export or ClickHouse (for DAU/retention tracking) • Monitoring: AWS CloudWatch, Sentry (error tracking), Grafana (optional dashboard...

I need an experienced backend developer to build and integrate the backend for a new mobile chat & social app. The frontend is already designed in Figma and implemented in Flutter (iOS & Android). B...Translate or DeepL • Push Notifications: Firebase Cloud Messaging (Android) & Apple Push Notification Service (iOS) • In-App Purchases: Google Play Billing & Apple In-App Purchase • Ads: Google AdMob or Meta Audience Network Admin Panel (Web): • Framework: or React • Purpose: Manage users, view reports, handle unblock requests, monitor analytics Analytics & Monitoring: • Analytics: BigQuery export or ClickHouse (for DAU/retention tracking) • Monitoring: AWS CloudWatch, Sentry (error tracking), Grafana (optional dashboard...

...tracking, but their event logic is still off, so attribution remains unreliable. Because we drive almost all installs through Google and Meta ads, I need rock-solid data before we scale spend any further. Top priority is Firebase. All three event groups—User engagement events, In-app purchase events, and Custom events—must fire with the correct parameters and appear consistently in DebugView, BigQuery exports, and the Google Ads conversion import. Within user engagement, the basic App opens event is already behaving strangely, so that has to be the first item you verify and repair. While you are inside the code, I also want the Meta Pixel subscription events brought back to life; right now they record nothing, leaving Facebook Ads Manager blind when it comes to subs...

I need a skilled data analyst to create comprehensive cross-platform marketing analytics reports using SQL, BigQuery, and Tableau. The reports should be insightful and help in decision-making. Key Requirements: - Proficiency in SQL and BigQuery - Advanced skills in Tableau for data visualization - Experience in marketing analytics - Ability to integrate data from multiple platforms - Strong analytical skills to derive actionable insights Ideal Skills and Experience: - Background in data analysis, preferably in a marketing context - Familiarity with platforms like Google Analytics, Facebook Insights, and Adobe Analytics - Excellent communication skills for presenting findings Please provide examples of previous work and relevant experience.

I'm seeking a BigQuery expert for a one-time data export project. You will connect to our BigQuery project using JSON service credentials (which I'll provide) and export all available tables to CSV or Excel formats. The data comes from a company specializing in georeferencing information related to the Retail sector. If full exports aren't technically possible, you'll need to provide the required data directly. Requirements: - Strong background in Google BigQuery - Experience exporting and organizing datasets into CSV/Excel - Ability to work with strict confidentiality (NDA available if needed) Skills Required: - BigQuery - SQL - Data Export - Google Cloud Platform - Excel/CSV

...talkers) Implement parameters, subreports, crosstabs, charts, conditional formatting. Tune SQL for large Vertica tables (window functions, CTEs, projections awareness). Set up easy exports (PDF/Excel/CSV) and light scheduling. Leave concise docs (data mapping + “how to run”). You should apply if you have Real-world JasperReports/Jaspersoft Studio work reading from Vertica (or Snowflake/Redshift/BigQuery with similar patterns). Comfort with time-series/trend reporting and big datasets. Practical performance tricks (dataset reuse, pagination, avoiding N+1, query profiling). Scope & logistics Type: Freelance (paid) - perday charged Start: ASAP How to appl...

...fallback/error, low-scan alerts, optional OOS conflicts Privacy & compliance: First-party, cookie-light, no PII, GDPR/PECR aligned; clear consent links. Deliverables TypeScript repo + infra (Workers/KV) and GTM container with GA4 events. Mobile page (vanilla/Preact/Svelte-light), media pipeline (transcode ladder, posters). Tracking plan (event dictionary), POS merge job, warehouse schema (BigQuery/Snowflake/Postgres). Dashboards (Looker Studio/Metabase/etc.) + weekly PDF/email exports. One-pager runbook: how to add campaigns, change copy, read metrics, troubleshoot. Acceptance criteria Performance: FCP < 1.2s on 4G; analytics adds <30 ms overhead; media click-to-play only. Event fidelity: client vs server counts within 2–5%; ≥99% events carry requir...

I'm looking for an experienced GCP trainer to provide on-site training on advanced GCP services. Location- Bangalore Duration-6 hours Sat-sun- off Key Requirements: - In-depth knowledge of GCP - Hands-on experience with advanced services - Prior training experience, preferably on-site Ideal Skills & Experience: - Expertise in GCP services like BigQuery, Dataflow, Kubernetes, ML, and AI tools - Strong teaching and communication skills - Certification in GCP is a plus Please provide a detailed training plan and outline.

I need a simple data dashboard that combines data from GoogleAnalytics, IronSource, and ByteBrew. You will set up the connections so the data from these platforms flows into BigQuery. The dashboard in Looker should allow me to: - Filter by platform (Android / iOS) - Filter by app (multiple apps in the same account) - Filter by country - Filter by time period Ideal skills and experience: - Experience with GA4, IronSource, and ByteBrew - Proficient in BigQuery and Looker Studio - Ability to set up data connections, API Integrations and build user-friendly dashboard

...pipeline**    - Process Spanish text files up to 17GB with <8GB memory per worker    - Extract unigrams, bigrams, and trigrams with statistical analysis    - Achieve <4 hour processing time for 17GB datasets    - Maintain ≥99.95% accuracy and uptime 2. **Google Cloud Platform Integration**    - Deploy on Google Cloud Dataflow with auto-scaling (5-50 workers)    - Integrate with BigQuery for data warehousing    - Use Cloud Storage for staging and results    - Implement Cloud KMS for encryption    - Configure VPC with private IP addresses 3. **Performance Optimization**    - Implement streaming file processing (1MB chunks)   &...

...reports impossible to trust. The goal is to rebuild the flow so that every page view, button click, and form submission fires once—no more, no less—and lands in GA4 and Meta with identical names and parameters. You’ll audit the existing tags, connectors, and Google Cloud resources, identify where the double-counting begins, and then re-engineer the collection path. Feel free to lean on Tag Manager, BigQuery, Cloud Functions, or any other Google Cloud tool you prefer; I just want a future-proof setup I can understand and maintain. Acceptance criteria • A live walkthrough showing each event (page view, button click, form submission) firing exactly once in both GA4 and Meta Events Manager. • Clear documentation of the tag structure, Cloud components...

I need assistance with Jenkins to streamline my day-to-day activities. Key Skills Required: - Jenkins expertise (pipeline setup, plugin management, CI/CD integration) - Experience with GCP (BigQuery), Tableau, SQL, and multidimensional data (cubes) Please include your relevant experience in your application.

...(Hive, Presto, Impala). --- 5. Data Visualization & Reporting Insights must be shared with humans . Tools: Tableau, Power BI, QlikView Python (Matplotlib, Seaborn, Plotly) Kibana + Elasticsearch for dashboards --- 6. Infrastructure Setup On-Premises (Clusters of Servers) – Needs hardware setup, HDFS, Hadoop/Spark. Cloud-based (easier, scalable): AWS EMR, Redshift, S3 Google BigQuery, Dataproc Azure HDInsight, Synapse --- Example Big Data Pipeline (Simplified) 1. Data Ingestion → (Kafka / Flume) 2. Data Storage → (HDFS / S3 / NoSQL DB) 3. Processing → (Spark / Hadoop) 4. Analysis → (ML, SQL, Python/R) 5. Visualization → (Tableau, Kibana, Power BI) --- In short: To build Big Data, you need to design a pipeline:...