Senior Data Analytics Engineer: DWH & BigQuery (Flexible)

Instinctools; Kraków; On-site; PLN 180,000 - 280,000; Full time

Benefits offered by this job

Flexible working hours

Learning opportunities

Language course reimbursement

Job summary

instinctools is seeking a Senior Data Analytics Engineer for a client project focused on building a centralized DWH and scalable data pipelines. You will own the design and implementation of financial data flows, reconciling sources and maintaining audit-ready data in BigQuery.

You will work closely with analytics and finance stakeholders to translate requirements into robust data models and incremental load processes, using Airflow and dbt/Dataform within a Google Cloud environment.

Qualifications

• 5+ years of experience as an Analytics Engineer / DWH Engineer / Data Analyst.
• Hands-on experience with data warehouses and DWH architecture (ODS, Data Marts).
• Understanding of incremental loads, historical data handling, and deduplication.
• Strong SQL skills and experience with BigQuery.
• Experience with Airflow or similar orchestration tools.
• Ability to translate business needs into data requirements.

Responsibilities

• Gather and clarify requirements from analytics and finance stakeholders.
• Design and evolve DWH architecture (ODS / Data Marts) with audit requirements in mind.
• Develop and maintain financial data pipelines.
• Design, implement, and support incremental data pipelines.
• Develop and optimize data marts in BigQuery (dbt, Dataform).
• Analyze source systems and build data flows from source to consumption.
• Maintain and develop workflows in Airflow.
• Participate in testing, data validation, and release processes.
• Investigate data quality issues and financial discrepancies.
• Maintain technical documentation required for audit and data governance.

Skills

SQL

BigQuery

Airflow

Python (basic)

Stakeholder communication

Tools

dbt

Dataform

Git

Job description

instinctools is seeking a Senior Data Analytics Engineer for a client project focused on building a centralized DWH and scalable data pipelines. You will own the design and implementation of financial data flows, reconciling sources and maintaining audit-ready data in BigQuery.

You will work closely with analytics and finance stakeholders to translate requirements into robust data models and incremental load processes, using Airflow and dbt/Dataform within a Google Cloud environment.