- Company Name
- Fipto
- Job Title
- Analytics Engineer (F/M)
- Job Description
-
**Job Title:** Analytics Engineer
**Role Summary:**
Design, develop, and maintain data models and warehouse layers that support strategic metrics, KPIs, and regulatory reporting. Collaborate with product, engineering, and business teams to deliver reliable, high‑quality data products and automate manual data processes.
**Expectations:**
- Minimum 2 + years experience in data/analytics engineering.
- Strong SQL proficiency (CTEs, window functions, query optimization).
- Hands‑on experience with dbt (modeling, testing, documentation, macros).
- Good grasp of ETL processes, data modeling (dimensional/normalized), and data quality principles.
- Ability to work autonomously, solve problems methodically, and communicate with technical and business stakeholders.
- Fluent French and professional English proficiency.
**Key Responsibilities:**
- Evolve and maintain dbt models for business and regulatory reporting.
- Build new data products to meet business team needs.
- Implement testing and monitoring to ensure data quality.
- Diagnose and resolve data pipeline issues across AWS services (e.g., Athena, Glue, Step Functions, DMS).
- Provide ad‑hoc and recurring data support to cross‑functional teams.
- Document data models, lineage, and business logic.
- Automate manual data workflows and propose architectural improvements.
**Required Skills:**
- Advanced SQL (complex queries, performance tuning).
- dbt modeling, testing, documentation, macro development.
- ETL design and implementation.
- Data modeling concepts (star schema, snowflake, normalization).
- Version control with Git.
- Familiarity with cloud data warehouses (AWS Athena/Redshift, Snowflake, etc.).
- Experience with BI tools (Metabase, Looker, Tableau, QuickSight, etc.).
- Bonus: Python scripting, AWS services (Glue, DMS, Step Functions), interest in AI/fintech/crypto.
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, or related quantitative field (or equivalent practical experience).
- No specific certifications required; relevant AWS or dbt certifications are a plus.