Senior Business Analysis and Control Associate

Deel Deel · Enterprise · EMEA · G&A

This role focuses on building and maintaining business control data pipelines using SQL and Snowflake. The primary responsibility is to transform raw business data into automated, reliable control frameworks, identify anomalies, and develop KPIs and data models. It requires expert SQL proficiency and experience with cloud data warehouses, specifically Snowflake.

What you'd actually do

  1. Data Control Pipeline Development: Take primary ownership of building and maintaining business control data pipelines from scratch. This involves writing complex, highly performant SQL queries in Snowflake to ingest, transform, and validate massive datasets.
  2. Complex SQL Querying: Design, build, and optimize complex queries to analyze extensive datasets, identify anomalies, and extract trends. Your SQL skills will be the primary tool used to build and automate our control frameworks.
  3. Control Framework Implementation: Translate business logic and control requirements into automated, scalable data models and tests within our data environment.
  4. KPI & Data Model Creation: Develop, productionalize, and track key performance indicators (KPIs) by building the underlying data models in Snowflake that feed into our BI tools (Looker, PowerBI) and FP&A models.
  5. Process Monitoring & Adaptation: Proactively monitor product and feature releases, analyzing their impact on data streams, and adapting your SQL-based control pipelines and frameworks accordingly.

Skills

Required

  • SQL
  • Snowflake
  • Data Warehousing
  • Data Modeling
  • ETL/ELT
  • BI Tools (Looker, PowerBI, Tableau)
  • Data Analysis
  • Problem Solving

Nice to have

  • Financial Controlling
  • SaaS Metrics
  • Accounting/Revenue Concepts

What the JD emphasized

  • Expert-level proficiency in SQL is mandatory
  • Hands-on experience with a cloud data warehouse, specifically Snowflake, is strongly required