Friends, we have an opening for a Digital Analyst at ForteBank in Astana.

📌 Responsibilities: • Marketing Spend Integration: Setting up data import on expenses, clicks, and impressions from advertising accounts (Meta, Google Ads, etc.) into the existing DWH via SQL/API. • Data Blending: Linking spend data from ad accounts with cohort data on user behavior and revenue from AppsFlyer at the campaign, ad set, and creative levels. • Visualization in Power BI: Development, support, and customization of interactive dashboards for buyers and top management (data modeling, writing DAX measures). • In-depth analysis of advertising campaigns: • Evaluating traffic acquisition efficiency by geo, buyers, sources, and combinations. • Calculating metrics: ROI, ROMI, honest ROAS, CAC, CPA, LTV, and cohort analysis. • Identifying growth points: Close collaboration with the UA team, preparing insights for budget optimization and scaling successful combinations. • Data Quality Control: Monitoring the correctness of data transfer from ad accounts to DWH, identifying and eliminating discrepancies, controlling campaign naming.

📌 Requirements: • Experience in a Marketing / Web / Data Analyst role (experience in mobile marketing and User Acquisition will be a key advantage) • Proficient in SQL (complex JOINs, Window Functions, CTE, aggregate functions) for data transformation and cohort analysis within DWH. • Good knowledge of DAX and Power Query (M), experience in building clear and fast reports for the business. • Understanding of mobile analytics: Experience working with AppsFlyer (understanding attribution logic, raw data structure, and working with it). • Clear understanding of how traffic acquisition works (primarily Meta, Google), working with UTM tags, macros, and attribution models.

Send your CV to my email: ayestay@fortebank.com