Coffeebeans.io - Data Analyst - ETL Pipeline

Overview

We are seeking a highly skilled Data Analyst with 6+ years of experience in analytics, data modeling, and advanced SQL.

The ideal candidate has strong expertise in building scalable data models using dbt, writing efficient Python scripts, and delivering high-quality insights that support data-driven decision-making.

Key Responsibilities

• Design, develop, and maintain data models using dbt (Core and dbt Cloud).
• Build and optimize complex SQL queries to support reporting, analytics, and data pipelines.
• Write Python scripts for data transformation, automation, and analytics workflows.
• Ensure data quality, integrity, and consistency across multiple data sources.
• Collaborate with cross-functional teams (Engineering, Product, Business) to understand data needs.
• Develop dashboards and reports to visualize insights (using tools such as Tableau, Looker, or Power BI).
• Perform deep-dive exploratory analysis to identify trends, patterns, and business opportunities.
• Document data models, pipelines, and processes.
• Contribute to scaling the analytics stack and improving data architecture.
  
  

• 6 to 9 years of hands-on experience in data analytics or data engineering.
• Expert-level skills in SQL (complex joins, window functions, performance tuning).
• Strong experience building and maintaining dbt data models.
• Proficiency in Python for data manipulation, scripting, and automation.
• Solid understanding of data warehousing concepts (e.g , dimensional modeling, ELT/ETL pipelines).
• Understanding with cloud data platforms (Snowflake, BigQuery, Redshift, etc.
• Strong analytical thinking and problem-solving skills.
• Excellent communication skills with the ability to present insights to stakeholders.
• Trino and lakehouse architecture experience good to have.
  
  

• SQL, Python, ETL, Data Transformation Tool (DBT) and Snowflake.
  
  

(ref:hirist.tech)