Flutterwave is looking for an analytics engineer who will own the transformation layer that turns raw, streaming, and batch data into clean, tested, and well-documented datasets.
Build ingestion pipelines with Estuary, model data in dbt, and write performant SQL and Python on Amazon Redshift to make analytics accurate, fast, and self-serve.
Responsibilities include, but are not limited to
dbt modeling: Build and maintain modular, tested, documented dbt models (staging → intermediate → marts); manage tests, macros, and materializations.
Estuary pipelines: Build and monitor real-time and batch ingestion, including CDC from operational sources; handle schema evolution, backfills, and connector issues.
Redshift & SQL: Write performant SQL and design dimensional models; tune queries and warehouse performance (dist/sort keys, WLM, cost optimization).
Python: Automate transformations, orchestration hooks, custom dbt macros, and API integrations.
Data quality & testing: Establish tests, freshness checks, monitoring, and alerting; own CI/CD for analytics code via Git.
Documentation & semantics: Maintain model and metric documentation and a consistent semantic layer so definitions stay single-sourced.
Collaboration: Partner with analysts, data scientists, and business teams to translate requirements into scalable, trustworthy datasets.
Governance: Apply access controls, PII handling, and data privacy practices (e.g., GDPR, SOC 2).
Required competency and skillset to be a waver:
Minimum 3 years in analytics engineering, data engineering, or a similar role.
Strong production SQL (window functions, CTEs, performance tuning)
Hands-on dbt experience in production
Proficiency in Python for data workflows and automation
Experience with Amazon Redshift (dist/sort keys, WLM, tuning)
Experience with ELT/CDC ingestion tooling — Estuary or comparable (Fivetran, Airbyte, Debezium, Kafka)
Solid data modeling fundamentals (Kimball dimensional modeling, star schemas)
Comfortable with Git-based version control and CI/CD
Authorization to work in the country without sponsorship
Preferred qualifications include:
Real-time / streaming and CDC architecture experience
