Technical data analyst

грейд
senior
формат
гибрид Варшава
страна
Польша
язык
Английский C1
опубликована
вчера

описание

2 дня в неделю в офисе в Варшаве

As Senior Technical Data Analyst, you will undertake detailed analysis, modelling and validation of data being brought into Linklaters' centralised Databricks platform. You will convert complex source-system data and business rules into well-defined analytical products that can support governed reporting, Tableau dashboards and natural language data interaction.

задачи

  • Performing detailed technical analysis across data products and analytics initiatives, from source discovery to analytical consumption in Databricks.
  • Building and maintaining Databricks metric views and materialised views using agreed business definitions, dimensions, measures and aggregation logic.
  • Developing SQL wrapper views that expose governed, stable datasets for Tableau connections and other approved analytical consumers.
  • Implementing the workflow from data product to analytical product, metric view, materialised view and SQL wrapper, with clear lineage and documentation between each layer.
  • Working with BI Developers to move reusable calculations and KPI logic out of local Tableau workbooks and into governed Databricks objects.
  • Writing advanced SQL to profile, investigate, compare, transform, reconcile and validate complex source and target datasets.
  • Producing source-to-target mappings and transformation requirements covering joins, filters, calculations, hierarchies, reference data and exceptions.
  • Analysing SAP BW, Workday and Salesforce structures, including master data, transactions, hierarchies and reporting dependencies.
  • Validating Bronze, Silver and Gold datasets and confirming that analytical products remain aligned to downstream reporting requirements.
  • Contributing to dimensional models, shared dimensions, semantic definitions, metric catalogues and data-product documentation.
  • Executing data quality, reconciliation, regression and performance testing across source, Databricks and Tableau-facing layers.
  • Investigating discrepancies between source systems, legacy reports, Databricks outputs and dashboards and documenting root causes and resolutions.
  • Supporting the Lead Technical Data Analyst by reviewing junior analysis, improving standards and sharing technical knowledge.

требования

  • 5+ years of professional experience in technical data analysis, analytics engineering, data warehousing or a comparable data-focused role within a complex enterprise environment.
  • 2+ years of practical experience with Databricks or a comparable modern lakehouse or cloud data platform.
  • Hands-on experience building or maintaining metric views, materialised views and SQL presentation or wrapper views for analytical consumption.
  • Fluent English.
  • Strong SQL capability with substantial experience profiling, transforming, reconciling and validating complex datasets independently.
  • Practical understanding of the workflow from governed data product to analytical product, metric view, materialised view and Tableau connection.
  • Strong experience with data warehousing or lakehouse concepts, ETL/ELT, dimensional modelling and reusable semantic structures.
  • Experience producing source-to-target mappings, data dictionaries, data lineage, transformation specifications and test documentation.
  • Experience centralising KPI and calculation logic in a governed data platform to reduce duplicated or localised Tableau calculations.
  • Experience working independently across Product, Data Engineering, BI and business teams, including reviewing or supporting work completed by junior analysts.
  • Будет плюсом: Experience working with SAP BW, Workday, Salesforce or similarly complex enterprise applications (highly desirable)

условия

  • Contract of employment with 3-month probationary period
  • 9:00-17:15
  • 2 days per week from the office located in Warsaw next to Rondo ONZ
  • Private medical insurance
  • On-site gym and bike facilities
  • Group Life insurance
  • Firm funded worldwide personal travel insurance, for you and your family
  • Subsidised sport card or public transportation card
  • Wide range of training opportunities
  • We provide agile working solutions to meet the changing needs of our people and our business

навыки

компания

похожие вакансии

статьи для аналитиков