Analytics Engineering is part of the Central Analytics team, they are responsible for providing clean, accurate, well-modeled data ready for analysis. Their role entails transforming, testing, and documenting data. On top of that, you will also be expected to have a strong ability to understand user requirements and to perform data analysis and dashboarding.
Responsabilities
Data modeling. Model raw data into clean, tested, and reusable datasets by using dbt.
Data transformation. Apply various transformations (combining, cleansing, flattening, aggregation, etc.) to build a coherent foundation layer for reporting and analysis.
Quality Code. Ensure that SQL code is; performant, well formatted and maintainable, with appropriate naming and development conventions consistently applied.
Data documentation. Provide identifiable and understandable descriptions of data and stages of transformation, as well as exposing them in a way for all consumers to easily find answers to their queries.
Data Quality management. Define measure and create testing processes to ensure data is accurate enough to fit operational and analytics needs.
Software engineering best practices for analytics. Apply best practices (especially in dbt) in terms of version control, testing and deployment.
Data Visualization. Build dashboards, charts, and reports using BI tools.
Close collaboration with other teams. Work collaboratively with all stakeholders, namely data engineers and business analysts to align our data assets with business requirements.
You will be part of the Data Team but working very closely to the business departments (Marketplace, Sales, Marketing, Finance, Product Ops…). You will be working and learning together with Full-stack Engineers, Data Scientists, and Data Analysts (read our blog posts). Note that the Data Team is mostly based in Barcelona and Madrid with some great profiles working remotely.
Requirements
4 + years of experience in data transformation and modeling, Commercial experience of Kimball/Dimensional or Data Vault methodologies are highly desirable.
Experience in cloud data warehouses such as Snowflake, Redshift, BigQuery or similar.
SQL wizard.
1+ years of experience working with DBT.
Experience in building reporting layers for BI tools / experience in dashboarding.
Excellent verbal and written communication skills; ability to communicate effectively with different levels of management, as well as the business and technical communities.
Fluent in English is a must.
Desirable
Refactoring and/or data warehouse migration projects.