data engineer for revenue reconciliation

Andersen; United States; Remote; USD 110,000 - 180,000; Full time

Benefits offered by this job

Private health insurance

Mentoring program

Career growth opportunities

Job summary

Andersen ищет Analytics Engineer для разработки и миграции пайплайнов в рамках крупной платформы данных. Ваша задача — улучшать качество данных, автоматизировать reconciliation и строить данные marts в BigQuery с использованием dbt и Airflow.

Требуется опыт работы с DWH, продвинутый SQL и желание работать с внешними источниками данных типа AppsFlyer. Конкурентная компенсация и планы карьерного роста ждут кандидата.

Qualifications

• 3+ года опыта аналитической инженерии/хранилищ данных (DWH)
• Опыт работы с DWH архитектурой: ODS, Data Marts
• Опыт работы с SQL на продвинутом уровне, знание Python приветствуется

Responsibilities

• Сбор и уточнение требований маркетинга и BI, перевод их в логику атрибуций и данные marts
• Проводить миграцию пайплайна атрибуций на core DWH: dbt модели, Airflow DAGs и источники
• Строить и оптимизировать incremental data marts в BigQuery с dbt, SQL и Airflow
• Разрабатывать проверки качества данных и исследовать расхождения
• Анализ внешних входов (AppsFlyer, рекламные сети) для обеспечения надежности данных
• Участвовать в тестировании, валидации данных и процессе релизов
• Вести техническую документацию и делиться знаниями в команде

Skills

SQL

Python

Airflow

dbt

BigQuery

Data Warehousing

Tools

Airflow

dbt

Job description

Описание: The customer is a global investment management firm that provides tailored investment solutions to institutional and private clients. It combines financial expertise with long-term investment strategies, adapts to changing market conditions, and focuses on innovation, responsible investing, and operational excellence. The project automates revenue reconciliation within a large-scale data platform, improving payment reconciliation accuracy, transparency, and operational efficiency.

Задачи:

• Gather and clarify requirements from marketing analysts and BI, translating them into changes to attribution logic, sources, and data marts
• Lead the migration of the attribution pipeline, including dbt models, Airflow DAGs, and sources, to the core DWH platform; run both pipelines in parallel and reconcile results before switching over
• Build and optimize incremental data marts in BigQuery using dbt, SQL, and Airflow, including recalculations and backfills
• Design and implement data quality checks and investigate discrepancies against product and source data
• Analyze external inputs, including AppsFlyer, ad network cost feeds, Google Sheets dictionaries, and upstream marts, to ensure reliable data flow from source to consumption
• Participate in testing, data validation, and release processes, including repointing downstream consumers
• Maintain technical documentation for the domain and share knowledge across the team

Требования:

• At least 3 years of experience as an Analytics Engineer, DWH Engineer, or Data Analyst working with DWH
• Hands-on experience with data warehouses
• Strong understanding of DWH architecture and data layers, including ODS and Data Marts
• Understanding of incremental loads, historical data handling, and deduplication
• Expert SQL skills
• Experience designing and optimizing data marts
• Experience with BigQuery or a similar columnar database
• Experience with dbt on large incremental projects
• Experience migrating pipelines between platforms and validating data parity
• Experience with Airflow or a similar orchestration tool
• Knowledge of Python for data processing and ETL tasks
• Ability to work with stakeholders and translate business needs into data requirements
• English at Intermediate+ level or above
• Будет плюсом: mobile and marketing attribution data experience with AppsFlyer, Adjust, or Branch, including ad network cost data, SKAN, and ATT; familiarity with ad fraud detection and analytics, particularly AppsFlyer Protect360; GCP experience, including Cloud Storage and Dataform; experience with analytics and BI tools such as Lightdash, Looker, and Tableau

Условия:

Up to an additional 1,000 EUR per month, depending on expertise level, included in the annual bonus for participation in company activities

• Professional, financial, and career growth opportunities
• Mentoring and adaptation systems for each new employee
• Access to the corporate training portal and company knowledge base
• Corporate events and amenities, including parties, pizza days, PlayStation, fruit, coffee, snacks, and movies
• Certification compensation, including AWS and PMP Referral program
• Private health insurance and sports compensation, depending on the type of employment