To launch and develop the analytics function based on Metabase connected to OLTP databases, with a future expansion towards a DWH, the BI Analyst will not only build dashboards but also identify insights, formulate hypotheses, and help the business make data-driven decisions. Responsibilities * Develop, maintain, and enhance dashboards, reports, and alerts. * Define and standardize business metrics, maintain a metrics dictionary. * Optimize SQL queries and reduce load on data sources. * Create views and materialized views for complex metrics. * Manage data access permissions and configure role-based access in Metabase. * Analyze data to identify insights, anomalies, and trends. * Investigate causes of changes in key metrics and formulate hypotheses. * Prepare visualizations, analytical materials, and presentations for management and teams. * Collect business requirements and translate them into analytical solutions.
Requirements * Excellent SQL skills, including complex queries, optimization, window functions, and indexing. * Experience with BI tools. * Understanding of differences between OLTP and OLAP. * Experience optimizing queries and reducing database load. * Skills in creating views and materialized views. * Ability to gather and formalize business requirements. * Skills in documenting reports and metrics. * Systematic approach and attention to detail. * Experience preparing visual and written reports for senior management. * English Upper-Intermediate.
Nice to have * Python or R skills for additional data analysis. * Skills in creating aggregated tables and automating their updates. * Experience working with DWHs. * Experience building ETL/ELT pipelines.
Benefits * Competitive and attractive compensation. * Remote work schedule. * Proper rest time of 24 annual leave days. * Challenging and unique tasks in the FinTech field. * Funding for gym memberships, fostering a healthy work-life balance.
Interview Stages * Interview with HR Manager (1 hour). * Interview with Hiring Manager (1,5 hours).
About Quantango Quantango is a technology company of like-minded people who are seeking to change the way the world trades. After spending more than 15 years in trading and brokerage, we asked ourselves a question: Why is everything so regular? So we decided to create revolutionary tools that break down barriers in trading worldwide. With passion as our guide, we venture into uncharted territory, exploring new frontiers, challenging norms, and pushing boundaries further than ever before.
Our vision is to have a journey to reinvent trading mechanics and to offer unlimited trading perspectives. We want people to trade cross-asset, cross-market, and even cross-event!
We seek companions who are: * Passionate about working in finance * Ambitious to do great things * Attentive to the very detail of the subject * Bold enough to build different * Enthusiastic along the way * Ready to make a lasting impact
