Responsibilities & achievements

• Designing, creating, and maintaining a reporting system using BigQuery as a data warehouse, DBT to build DAGs for transformations and Metrics Layer, and Looker Studio as a visualization tool • Providing ad-hoc data analysis, using data to identify and forecast trends, and conducting deep-dive quantitative analyses to draw insights from KPIs • Creating tests in DBT to ensure data quality, catch outliers, and identify data issues • Building customized dashboards in Looker Studio

Responsibilities & achievements

• Designing, creating, and maintaining DWs, ETL using SQL and tools (seldomly Python), extracting data from various sources, exploring APIs and extracting data, building customized dashboards in Data Studio as well as templates, data analysis, query optimization, data issue resolution, and requirements gathering; • Working closely with and extracting data from marketing platforms like Facebook Business Manager, Google Ads, Snapchat Ads Manager, etc. along with Mobile Measurement Partners/Trackers such as Google Analytics, Pixel, Adjust, Kochava, AppsFlyer; • New team members mentoring and training. - Managing a team of three developers, overseeing daily operations, dividing the team's workflow, identifying, and addressing problems and opportunities, and communication with management, other departments, and clients.

Responsibilities & achievements

• ETL modeling, mapping; • Working with DB, data processing and analysis: finding trends, dependencies, identifying ways of adapting and optimizing; • Data visualization in Tableau; • Working closely with clients, and requirement gathering.