User avatar
Full Time
4 months ago
You will be working in close collaboration with the Investment, Commercial, Operations, Marketing and Finance teams to build the data warehouse models and transformation pipelines that will power all business reporting and analytics. Our stack includes Snowflake, dbt, Data Virtuality, Python, PowerBI. What you will do • Design and implement high-performance, reusable, and scalable data models using the state-of-the-art tool dbt for our data warehouse on snowflake cloud to ensure our end-users get consistent and reliable answers when running their own analyses (Power BI, Excel). • Support our data engineers building the ELT layer (Data Virtuality, Daton, Python, Airflow) from a variety of internal and external systems into the data warehouse. • Work with data analysts and business stakeholders to determine requirements. • Support data scientists to acquire the best data sources and in identifying the best analytical methods. • Collaborating with colleagues to define and improve our internal standards for style, maintainability, and best practices for a high-scale data warehouse. Your background • 2+ years of experience as an Analytics Engineer/Database/ETL/BI developer. • Strong knowledge of data modelling for data warehouses, including data vault 2.0. • Technically proficient in SQL, experience with Python/R is a big plus. • Strong hands-on data modelling and data warehousing (1+ years of experience using dbt). • Familiarity with at least one of these Cloud technologies: Snowflake, AWS, Google Cloud, Microsoft Azure. • Experience in software engineering best practices to analytics (version control, testing, and CI/CD) is a plus. • Familiarity with finance, customer, marketing and/or web analytics data is a big plus. • Clear and direct communication skills, comfortable working with engineers, analysts and stakeholders across the business. • Self-motivated, responsible and problem-solving individual who performs well both independently and as a team member. • Experience working in a fast-paced growing company.