Key Facts

Remote From:

Pakistan

Full time

Senior (5-10 years)

English

Hard Skills

Other Skills

•
Metric System
•
Collaboration
•
Communication
•
Leadership
•
Problem Solving

Roles & Responsibilities

Deep understanding of dbt (models, macros, seeds, and tests).
Expert in SQL.
Experience in Dimensional Modeling.
Experience with Git/GitHub, Airflow (or similar orchestrators), and BI tools like Metabase or Looker.

Requirements:

Lead dbt implementation and transition logic from siloed Metabase queries to modular, version-controlled, and tested transformations in AWS Redshift.
Architect the Single Source of Truth by defining core data models to ensure KPI changes propagate everywhere, eliminating metric drift.
Design gold-standard tables powering the Self-Service Data Platform and AI Assistants for high-fidelity answers with minimal manual intervention.
Use dbt snapshotting and modeling to implement historical tracking (SCDs) for accurate reporting on user states.

Fasset

About Fasset

Redefine the way money works for you, with Fasset. Fasset lets you seamlessly and securely manage all of your digital and real-world financial assets - from wherever you are, in your currency of choice. We believe in democratizing access to global assets, and that everyone, everywhere should be able to use their hard-earned money to buy high-quality, globally-traded assets to build and preserve their wealth. Through Fasset, you can: ⚫ Invest in both digital as well as real-world assets like stocks, bonds, commodities and precious metals.⚫ Tap into our trading platform and take advantage of a wide range of tokenized assets, including real-time market data.⚫ Connect to a digital wallet that makes shopping and transferring funds user-friendly, with integrated payment solutions for easy conversion.⚫ Transfer or receive funds securely and conveniently from wherever you are worldwide with the Fasset Connect Network. The security of our customers’ funds, data and earnings are our top priority. We are regulated by the Virtual Assets Regulatory Authority (VARA). No aspect of this platform is intended to provide, or should be interpreted as providing, any investment, tax, legal, financial, or other advice of any kind. The materials presented on this platform should not be considered a substitute for professional advice. If you decide to engage in transactions based on any material found on this platform, the decisions, transactions, and any consequences that arise are solely your responsibility. While other users may share investment advice or opinions, please be aware that such advice or opinions are merely conversational exchanges between individuals who may be anonymous or unidentifiable. Fasset explicitly does not provide investment advice directly, indirectly, implicitly, or in any manner whatsoever. It is recommended that you use any information obtained from this platform as a starting point for your own independent research.

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Job Description

Location: Pakistan

Team: Data & Analytics

Reports to: Head of Data

Role Overview

We are looking for a Senior Analytics Engineer to lead the evolution of our data stack as we are in a high-growth phase that requires us to scale our data infrastructure. You will be the primary driver in implementing dbt (Data Build Tool) to centralize our business logic and move us away from a reactive service model into a scalable, "Data-as-a-Product" ecosystem.

Your goal is to build the foundational data layer that powers our Self-Service Data Platform and feeds our internal AI Assistants, ensuring that every metric is governed, tested, and reliable.

Key Responsibilities

Deploy & Lead dbt Implementation: Act as the internal champion for dbt. You will transition our logic out of siloed Metabase queries and into a modular, version-controlled, and tested transformation layer in AWS Redshift.
Architect the Single Source of Truth: Define the core data models that align the entire company. You’ll ensure that when a KPI changes, it updates everywhere simultaneously, eliminating "metric drift."
Fuel AI & Self-Service: Design the Gold Standard tables that will serve as the brain for our Self-Service Platform and AI Assistants, allowing stakeholders to get high-fidelity answers without manual intervention.
Build for History: Use dbt’s snapshotting and modeling capabilities to implement historical tracking (SCDs), enabling us to accurately report on user states
Pipeline Optimization: Collaborate with Data Engineering team to optimize AWS Airflow DAGs, ensuring our dbt runs are performant, cost-effective, and resilient.

Technical Requirements

dbt Experience: You have a deep understanding of dbt (models, macros, seeds, and tests).
Expert in SQL
Experience in Dimensional Modeling
Understanding of modern data stack: Experience with Git/GitHub, Airflow (or similar orchestrators), and BI tools like Metabase or Looker.
Forward-Thinking: A passion for how clean data architecture enables LLMs and AI automation within the enterprise.