Business Intelligence Developer

Summary

Join Vestd, a leading sharetech platform, as a BI Developer in our Data & Analytical Support Team. This remote role (India-based) is crucial for enhancing our business intelligence, developing data warehousing capabilities, and automating processes. You will be responsible for developing and maintaining SQL queries, automating data pipelines using AWS services, optimizing query performance, and collaborating with stakeholders. The ideal candidate possesses extensive experience with SQL, BI tools, AWS services, data warehousing, and implementing AI in a data warehouse. Vestd offers a competitive salary, ESOPs, and a comprehensive benefits package including remote work flexibility, paid time off, professional development budget, private medical insurance, and team retreats.

Requirements

• 5+ years experience using SQL
• 5+ years of experience using BI tools (Microsoft Power BI, Tableau, etc.)
• 5+ years of experience working with AWS services (AWS Redshift, AWS Appflow, S3)
• Experience with query optimization and database design (i.e. indexing, partitioning, etc.)
• Familiarity with Data Warehousing/ETL concepts and execution
• Experience deploying ML models
• Experience implementing AI in a Data Warehouse
• Impeccable attention to detail and a high degree of accuracy
• Excellent written and verbal communication skills
• You must be comfortable with working in a fully remote environment

Responsibilities

• Drive the data team forwards to develop new insights which inform the strategic decisions of the business
• Develop and maintain SQL queries for data extraction, transformation, and loading
• Automate data pipelines and queries using AWS services (Redshift, Appflow, Glue, etc.)
• Optimize query performance and database design for improved efficiency
• Collaborate with business stakeholders to understand data requirements and translate them into actionable insights
• Assist in the development and maintenance of our Data Warehouse
• Explore and implement new data technologies and best practices, with a focus on AI
• Flex as needed to assist the rest of the Data team with reporting and analysis during high demand periods

Preferred Qualifications

• Experience with PostgreSQL or MySQL
• Experience setting up a Data Warehouse from scratch
• Experience working with HubSpot and/or Stripe
• Startup/scaleup experience
• Knowledge of shares and share schemes
• Experience working in a remote team

Benefits

• This job is fully remote, although attendance is required twice yearly at our in-person get-togethers
• A flexible environment to help you achieve the best work/life balance
• An Employee Stock Ownership Plan (ESOP), of course! (After the qualifying period)
• Monthly recognition scheme, where we celebrate our folk
• Support with home working equipment
• A personal training and development budget to keep your career and professional growth on track
• Private medical insurance (after the qualifying period)
• Team retreats are held twice a year. They can include an overnight stay and focus on fun and team cohesion
• Great team ethos, connect through regular team and company socials
• 25 days annual leave plus one extra day per year of service (up to five days)