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).
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
Required Experience:
Senior IC