Data engineer in marketing attribution

Andersen; United States; Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Remote work

Hybrid option

Mentoring and adaptation

Bonus program

Training portal access

Health insurance

Team events

Job summary

Andersen ищет Data Engineer для проекта по автоматизации процессов согласования выручки и повышения точности финансовых данных, прозрачности и операционной эффективности.

Вы будете вести миграцию атрибуции в DWH, строить и оптимизировать инкрементальные датамарты в BigQuery с использованием dbt и Airflow, реализовывать проверки качества данных и сотрудничать с аналитиками и бизнес-стейкхолдерами.

Qualifications

• 5+ лет опыта работы с DWH/Analytics.
• Умение строить широкие аналитические marts и бизнес-логикой.
• Опыт миграции аналитических пайплайнов и backfills.

Responsibilities

• Сбор требований от аналитиков маркетинга и BI и перевод в логику атрибуции/источники/датамарт.
• Ведение миграции пайплайна атрибуции в основную DWH-платформу.
• Запуск параллельно старой и новой систем, сверка до переключения.
• Построение и оптимизация инкрементальных датамартов в BigQuery (dbt/SQL) и Airflow.
• Разработка проверок качества данных и анализ расхождений.
• Глубокий анализ внешних входов (AppsFlyer, источники затрат) для надёжной передачи данных.
• Участие в тестировании, валидации данных и релизах, перенастройка потребителей.
• Ведение документации по домену и распространение знаний в команде.

Skills

SQL

Analytical thinking

Stakeholder communication

Python

Git

Tools

dbt

Airflow

BigQuery

Looker

Tableau

Dataform

Lightdash

Git

Job description

Описание

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.