1 month ago
Singapore, SingaporeMid Level
Responsibilities
- Design, develop, maintain, and scale production-ready data models using dbt.
- Translate reporting and analysis needs into optimized, maintainable dbt models.
- Implement data testing, validation, cleaning, monitoring, and alerting for mission-critical data flows.
- Investigate and resolve data anomalies and pipeline failures.
- Create and maintain data dictionaries, process flows, and other data documentation.
- Partner with data engineers, product analysts, GTM data teams, and business stakeholders to align data products with business objectives.
- Communicate data architecture, analytical conclusions, and complex data logic to technical and non-technical audiences.
- Guide business users in effectively leveraging data products.
- Research, evaluate, and prototype emerging technologies such as GenAI for data engineering, orchestration, and analysis workflows.
Requirements
- At least 2 years of experience in analytics engineering or data warehousing.
- Expert proficiency in SQL, including window functions and query performance optimization.
- Expertise with dbt for designing, developing, and maintaining complex data models.
- Strong functional knowledge of a modern cloud data warehouse such as Snowflake or BigQuery.
- Experience applying data engineering practices including Git/GitHub, modular coding, and automated testing.
- Strong understanding of data modeling principles including star schemas, snowflake schemas, and Slowly Changing Dimensions.
- Proficiency in Python or another scripting language.
- Experience with data orchestration tools such as Airflow or Dagster.
- Ability to own analytical projects from ambiguous requirements through delivery and business impact.
- Strong verbal, written communication, and stakeholder management skills.
Benefits
- Flexible, trust-oriented work culture with employee ownership.
- Vibrant and dynamic work environment with benefits supporting work and personal life.
- Remote-worker-friendly company culture; Quartz ranked Workato the number-one best company for remote workers.
About Workato
Workato builds a cloud platform for enterprise integration and workflow automation, combining iPaaS, no-code recipes, and AI to orchestrate processes across SaaS and on‑prem systems. It sells subscriptions to IT and operations teams at large and mid-size companies; customers include firms such as Nasdaq, Cisco, and Atlassian. Founded in 2013 and headquartered in Palo Alto, it is a privately held company.