About us
Sharegain began with one question: If the largest institutions solely exercise the right to lend their stocks, bonds, and ETFs, what would it take to unlock this revenue opportunity for every investor?
Our team of experts in the UK, US and Israel built the solution: a platform that empowers online brokers, private banks, and wealth managers to offer securities lending to their clients. We call it SLaaS: Securities Lending as a Service. It’s a fully digital, customizable, end-to-end solution that automates front- and back-office operations. Institutions and investors are now free to earn more from what they own.
Every Sharegainer has their own backstory, but we all share an ambition to do things differently – bigger, better, and greater. Together we’re on a mission to democratize capital markets by building a more liquid world. The more we share, the more we all gain.
About the role
We are looking for a dedicated and detail-oriented Data Analyst to join our innovative R&D data team. This role is integral in managing data analysis frameworks and infrastructure, driving data-centric decision-making, and contributing to data monitoring and management solutions. Responsibilities include designing and executing data analysis, developing interactive Power BI dashboards, optimizing SQL queries, and transforming complex datasets into actionable insights. Strong analytical skills and a deep understanding of data visualization are essential for success in this role.
Key responsibilities:
Power BI Report and Dashboard Development:
- Design, develop, and maintain insightful Power BI dashboards and reports to meet business requirements.
- Collaborate with product and stakeholders to gather reporting needs and translate them into technical solutions.
- Create data models and implement measures, calculated columns, and other DAX functions to ensure data accuracy and consistency.
- Ensure reports are visually compelling and user-friendly, providing key insights at a glance.
SQL Query Writing and Optimization:
- Write, optimize, and maintain complex SQL queries to extract, transform, and load data from various sources.
- Develop and manage stored procedures, functions, and scripts to automate data processing and reporting tasks.
- Perform regular database performance analysis and optimization to ensure efficiency.
Data Analysis and Reporting:
- Provide ad-hoc reporting and data analysis based on the requests of stakeholders.
Data Quality and Governance
- Ensure the accuracy, consistency, and integrity of data by implementing data validation and quality checks.
- Document data processes, report development, and SQL code for future reference and knowledge sharing.
Collaboration
- Work closely with cross-functional teams, including product, business units, and leadership, to understand data needs and deliver actionable insights.
- Train and support users and team members on using Power BI reports and dashboards.
Required skills
- “Can do attitude”
- At least 3 years of expertise in Power BI, including DAX and data modelling.
- Experience building and maintaining efficient sematic models.
- Strong proficiency in SQL, including query optimization and stored procedure development.
- Experience with data warehousing and data mart concepts.
- Knowledge and experience building data pipelines (ETL) (advantageous).
- Hands-on experience working with Azure Synapse Analytics/Fabric (advantageous).
- Understanding and professional experience in financial markets and instruments (shares, ETFs, bonds) (advantageous).
- Strong problem-solving and analytical skills, with the ability to interpret data and present insights effectively.
- Excellent communication skills and the ability to work effectively with stakeholders.
- Thrive as a collaborative team player, seamlessly integrating with diverse R&D teams both domestically and internationally.
- Excel in communication, with a knack for conveying complex ideas effectively.
Sharegain is an equal opportunity employer. Employees and contractors, as well as prospective employees and contractors, will all be treated equally and fairly. We are passionate in our belief that a diverse workforce is central to our success, and we are proud to reflect this within our recruiting processes.