описание
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