We are seeking an experienced Lead Data Analyst to join our dynamic team and help turn complex data into actionable insights that drive business decisions. Leveraging your expertise in dbt, SQL, Metabase, and AWS, you will collaborate with cross-functional teams to design, implement, and interpret analytical solutions across a variety of projects.
This project involves managing financial assets owned by the company. It utilizes machine-learning models that operate on data ingested from third-party APIs. The process includes ELT (extract, load, transform), data modeling in Snowflake using DBT, training ML models using AWS SageMaker, running predictions, and storing predictions back in Snowflake.
Responsibilities:
Consolidate data from various domains and construct interactive dashboards Data modelling using dimensional (Kimall) approach Conduct ad hoc analyses as required with extensively usage of SQL Identify and address data quality issues (in reports) Work with our current data stack: Snowflake, dbt, AWS services Collaborate with teams from the Data Engineering, Analytics, Data Science teams to establish and maintain consistent use of business definitions in a source of truth tables, and recommend continuous improvement strategies. Provide clean data sets to end users, modeling data in a way that empowers end users to answer their questions. Transform, test, deploy, and document data using version control and continuous integration to the analytics code base. Design, develop, test, automate, and launch new dashboards and reporting solutions across the company. Maintain and support existing metrics, KPIs, reports, and dashboards. Work with the Analytics and Engineering teams to understand existing internal tools and data warehouses, identify data quality and reliability improvements, and establish best practices. Be able to explain technical work to non-technical audiences and translate business logic from stakeholders to technical workRequirements
5+ years of experience in Data Analytics. 1+ years of experience with dbt Advanced SQL skills with extensive hands-on experience. Experience leading data modelling activities and building models from scratch. Familiarity with Metabase, PowerBI, or other BI tools. Proven track record of translating data insights into business actions and taking full ownership. Proficiency with Python or R for data analysis and automation Previous experience with version control and continuous integration to a code base. Understanding of ETL/ELT processes and data pipeline orchestration. Experience with scheduling/report automation (e.g., using cron, AWS Lambda, or Step Functions). Knowledge of data security and governance within AWS. Train and provide technical mentorship to other data analysts/engineers Adaptable and able to thrive in a fast-paced, dynamic work setting. Strong organizational skills with keen attention to detail. Excellent communication, analytical and interpersonal skills. English - Upper intermediate or AdvancedNice to Have
Familiarity with Snowflake Familiarity with Jupyter Notebooks or similar. Knowledge of data pipelines and workflow orchestration (e.g., with AWS Glue, Airflow, or Step Functions).We offer*:
Flexible working format - remote, office-based or flexible A competitive salary and good compensation package Personalized career growth Professional development tools (mentorship program, tech talks and trainings, centers of excellence, and more) Active tech communities with regular knowledge sharing Education reimbursement Memorable anniversary presents Corporate events and team buildings Other location-specific benefits*not applicable for freelancers