Full stack Engineer

It’s fun to work in a company where people truly believe in what they are doing. We’re committed to bringing passion and customer focus to the business.

• Pipeline Development:
  Build, monitor, and maintain robust ETL/ELT pipelines to ingest Play compliance and moderation data into Big Query.
• Datamart Construction:
  Implement the physical schema (tables, views, and materialized views) for the DSA Datamart based on architectural blueprints.
• Data Transformation:
  Write complex, optimized SQL and utilize tools such as dbt or Dataflow to transform raw event telemetry into clean, joinable business dimensions.
• Data Quality Automation:
  Develop automated "sanity check" scripts to detect data drift, null values, or logic breaks before they reach the reporting layer.
• Performance Tuning:
  Optimize query performance and storage costs by implementing partitioning, clustering, and efficient indexing strategies within Big Query.
• Liaison with Engineering:
  Work closely with Play backend engineers to understand upstream data changes and ensure pipeline resilience.

• GCP Data Stack:
  Professional experience with Google Cloud Platform, specifically Big Query, Cloud Composer (Airflow), and Dataflow.
• SQL Mastery:
  Expert-level SQL skills, including window functions, complex joins, and query optimization for petabyte-scale datasets.
• Python Proficiency:
  Strong ability to write Python for data orchestration, automation, and custom API integrations.
• Data Modeling Knowledge:
  Practical experience implementing dimensional models (Star/Snowflake) and managing slowly changing dimensions (SCDs).
• Technical Rigor:
  Demonstrated test-first mindset with experience in version control (Git) and CI/CD workflows for data.

• Must have experience in data pipeline development on GCP.
• Extensive knowledge of SQL and Python.
• Strong background in data modeling and data quality assurance.
• Experience with CI/CD in data environments.

India