Job 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.
Required Qualifications
- 6 - 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
Skills:- SQL, Python, ETL, Data Transformation Tool (DBT) and Snowflake
