Data engineer in marketing attribution

Andersen is hiring a Data Engineer for a project automating revenue reconciliation processes and enhancing financial data accuracy, transparency, and operational efficiency. The customer is a global investment management firm providing tailored investment solutions to institutional and private clients. It combines financial expertise with long-term investment strategies to help clients achieve their objectives while adapting to changing market conditions.

• Gathering and clarifying requirements from marketing analysts and BI, and turning them into changes to attribution logic, sources and data marts.
• Leading the migration of the attribution pipeline (dbt models, Airflow DAGs, sources) to the core DWH platform.
• Running old and new in parallel and reconcile them before switching over.
• Building and optimizing incremental data marts in BigQuery (dbt/SQL) and Airflow, including recalculations and backfills.
• Designing and implementing data quality checks and investigating discrepancies against product and source data.
• Performing deep-dive analysis of external inputs (AppsFlyer, ad network cost feeds, Google Sheets dictionaries, upstream marts) to keep data flowing reliably from source to consumption.
• Participating in testing, data validation and release processes, including repointing downstream consumers.
• Maintaining technical documentation for the domain and spreading knowledge across the team.

• Experience as an Analytics Engineer / DWH Engineer / Data Analyst working with DWH for 5+ years.
• Hands-on experience with dbt on a complex project: layered models, incremental logic, tests, macros.
• Experience building wide analytical marts with a lot of business logic and many metrics, built as a chain of dependent models.
• Experience refactoring or redesigning an existing analytical pipeline, not only building a new one.
• Experience with recalculation, backfills and historical data handling.
• Proficiency in SQL.
• Ability to form and defend an architectural position, and to work with stakeholders and translate business needs into data requirements.
• Experience working with Git.
• Working-level Python and Airflow (or a similar orchestrator).
• Level of English – from Intermediate+ or above.
• Будет плюсом: Experience with data layer and data mart architecture, including ODS, core, and marts; Hands-on experience with Google BigQuery; Experience with data platform migrations and data parity validation; Experience working with large-scale datasets and optimizing data architectures for scalability; Familiarity with mobile marketing attribution platforms (AppsFlyer, Adjust, Branch), ad network cost data, and SKAN/ATT; Experience with data quality, data governance, and tools such as Dataform, Looker, Lightdash, and Tableau; Experience in teamwork with leaders in FinTech, Healthcare, Retail, Telecom, and others

• The opportunity to change the project and/or develop expertise in an interesting business domain.
• Job conditions – you can work both fully remotely and from the office or can choose a hybrid variant.
• Guarantee of professional, financial, and career growth!
• The company has introduced systems of mentoring and adaptation for each new employee.
• The opportunity to earn up to an additional 1,000 EUR per month, depending on the level of expertise, which will be included in the annual bonus, by participating in the company's activities.
• Access to the corporate training portal, where the entire knowledge base of the company is collected and which is constantly updated.
• Bright corporate life (parties / pizza days / PlayStation / fruits / coffee / snacks / movies).
• Certification compensation (AWS, PMP, etc).
• Referral program.
• Private health insurance and sports compensation, depending on the type of employment.