Role Overview
We are looking for a Senior Analytics Engineer to transform our data infrastructure from a reactive service model into a proactive, scalable engine. Currently, our data team manages a high volume of requests from cross functional teams. We need a specialist who can step in to centralize our business logic, design robust data structures in Redshift, and eliminate the manual "firefighting" that currently plagues our dashboards.
You will be the architect of our "Single Source of Truth," ensuring that when a metric changes, it updates everywhere, not just in one isolated dashboard.
Key Responsibilities
- Data Modeling & Architecture: Transition logic out of Metabase SQL queries and into modular, version-controlled models within AWS Redshift.
- Build for History: Design and implement historical tracking (e.g., Slowly Changing Dimensions) so we can accurately report on "Active Cards" or user states at any point in the past.
- Pipeline Optimization: Work alongside our data engineers to optimize AWS Airflow DAGs, ensuring data is clean, tested, and reliable before it hits the BI layer.
- Stakeholder Partnership: Act as the primary point of contact for Finance, CX, and Marketing to translate business requirements into technical specs.
- Process Governance: Implement a public Kanban/Agile workflow to manage intake, prioritize high-impact requests, and provide transparency to leadership.
- Dashboard Consolidation: Audit our existing Metabase environment to move away from "disposable" dashboards toward a curated set of "Gold Standard" executive tools.
Technical Requirements
- Expert SQL: You don't just write queries; you write performant, readable, and dry (Don't Repeat Yourself) code.
- dbt (Data Build Tool): Deep experience using dbt to manage the transformation layer is highly preferred.
- Data Warehousing: Strong understanding of AWS Redshift (dist keys, sort keys, and query optimization).
- The "Modern Data Stack": Experience with version control (Git), orchestration (Airflow), and BI tools (Metabase, Tableau, or Looker).
- Dimensional Modeling: A firm grasp of Kimball or Star Schema methodology to create tables that make simple reporting... simple.
Top Skills
What We Do
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.
