Senior Data Analyst (#3656)

We are seeking an experienced 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 work

Requirements

• 3+ years of experience in Data Analytics.
• 1+ years of experience with dbt
• Advanced SQL skills with extensive hands-on experience.
• Familiarity with Metabase, PowerBI, or other BI tools.
• Proven track record of translating data insights into business actions.
• 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 Advanced

Nice 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).