Analytics Engineer Viseu

Analytics Engineer
Viseu
Viseu, Viseu District, Portugal

Job Title:

Analytics Engineer

Location:

Remote

Type:

Full-time

About Us

Oraion is your single source of truth for enterprise data. Oraion uses agentic AI to turn structured and unstructured enterprise data into
- obvious insights, instantly.

Oraion helps you make faster, more informed decisions and even automate complex tasks, all through a
- serve,
- based AI agent embedded in your existing workflow such as Slack, Teams or via our Enterprise Intelligence Platform.

We’re looking for a
- driven,
- focused Analytics Engineer to join our team and help transform raw data into actionable insights that drive smarter decisions for our clients using AI Agents.

About the Role

As an Analytics Engineer, you will be the first point of contact for new clients, helping them understand and optimize their data by designing analytical models in dbt (data build tool). You’ll play a critical role in building our application data stack, creating generalised
- focused reporting models and tuning our AI agents to handle repetitive tasks. At all times you’ll have a product mindset, thinking about how we can automate with AI agents and generalise client requirements into product features.

Responsibilities

• Serve as the first point of contact for new clients, understanding their data needs and challenges
• Translate client data into actionable insights by developing Python and SQL transformations for our datamarts using dlt and dbt
• Be a key contributor to the design and evolution of our data stack and product roadmap
• Build and maintain ERDs (Entity-Relationship Diagrams) and mapping documentation
• Translate source system schemas into
  - focused reporting models
• Analyze and interpret data from various sources, uncovering connections and trends across sources and domains
• Perform Exploratory Data Analysis (EDA) to identify patterns, anomalies, and insights that support strategic
  - making
• Create detailed descriptions for master data files, ensuring clarity and ease of understanding for stakeholders
• Always looking for opportunities to automate and recommend improvements to our platform to reduce manual effort, train a team of AI agents to handle basic tasks

Requirements

• Bachelor’s degree in Data Analytics or similar (Master’s degree is a plus)
• Minimum of 3 years of experience in data analysis, with a solid understanding of data management practices in a professional setting
• Strong experience with dbt (data build tool) is essential;
  
  bonus for experience with DLT (data load tool) and dagster
• Expert knowledge of SQL and Proficiency in Python
• Strong knowledge of data warehouse design and experience developing and querying data warehouses is essential
• Excellent
  - solving skills and the ability to work with complex data sets
• Strong communication skills, with the ability to present data insights clearly and effectively
• Ownership mindset with a proven track record of delivering
  - quality solutions independently

Nice to Have

• Experience with Post
  Gres- Aurora and Apache Iceberg in S3
• Experience with graph databases or implementing
  - based data structures
• Previous work with LLM-based applications or AI agent systems
• Experience with writing efficient prompts and tuning AI Agents
• Experience with knowledge storage and retrieval for AI Agents
• Startup experience is a plus

What We Offer

• Ground-floor opportunity to shape
  - driven AI solutions at a
  - growing startup
• Work alongside experienced founders and a driven team
• Competitive compensation + early equity
• Remote-friendly, flexible work culture