Analytics Engineer

Job description

Do you know AskBlue ? We were born in 2013, and we provide services in the field of information technology. We are looking for an Analytics Engineer to join our company in one of our projects, in Lisbon . Tasks: Requirements: - Own the end-to-end Silver-to-Gold transformation layer—clarify requirements, define grains and KPIs, implement business logic, and deliver curated datasets to production; - Develop performant SQL and PySpark transformations (CTEs, window functions, MERGE/upserts) with incremental processing, idempotency, and recovery patterns; - Design dimensional models (facts/dimensions, SCD Type 1/2, conformed dimensions) with clearly defined semantics for consistent reporting across domains; - Optimize Gold schemas for Power BI semantic models and ad hoc analytics—reducing downstream DAX/SQL complexity and enabling scalable self-service; - Implement quality and trust controls: validation and reconciliation checks, automated tests, documentation and lineage, and monitoring for data freshness and breaking changes; - Partner with Data Engineers and BI Engineers to align ingestion with consumption; maintain medallion-layer hygiene (partitioning, file sizing, OPTIMIZE/VORDER,...