Build, maintain, and optimize data transformation layers using dbt and Snowflake.
Design and develop complex, intuitive dashboards (ThoughtSpot/Tableau) that visualize campaign ROI and performance for internal and external stakeholders.
Execute complex SQL queries to support the Head of Data in deep-dive investigations and anomaly detection.
Perform rigorous testing on your own code and data outputs to ensure 100% accuracy before deployment.
Maintain clear documentation of data definitions, metrics, and logic to ensure the BI ecosystem remains organized and scalable.
Requirements
3+ years of hands-on experience in BI Development or Data Engineering.
Advanced SQL: Ability to write complex window functions, joins, and optimize query performance is non-negotiable.
Data Modeling: Strong experience with dbt and Snowflake is required.
Visualization: Proficiency in ThoughtSpot (Huge Advantage), Tableau, or PowerBI.
English Proficiency: Excellent written and verbal English is required for complex technical documentation and remote collaboration.
Execution Oriented: You prefer building and coding over meetings.
Attention to Detail: You spot errors in data before they reach the dashboard.
Deep understanding of the AdTech ecosystem (Google Ads, FB Ads, Appsflyer, etc.).
Experience writing Python scripts for data automation