AvaTrade

Business Analyst

AvaTrade Herzliya, Tel-Aviv District, Israel

Financial Services · 201-500 employees

4 d ago
business-analyst Mid (2-5 yrs) Full-time Israel
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Business Analyst will develop dashboards, reports, and scorecards while translating business requirements into actionable data solutions. They will also optimize SQL queries and collaborate with cross-functional teams to maintain high-quality data architecture.

What they look for

SQL Tableau Data Modeling Business Analysis Data Visualization SQL Server Amazon Redshift Snowflake Star Schema Snowflake Schema Reporting Data Architecture Performance Optimization Cross-functional Collaboration Problem-solving Communication

Requirements

Candidates must have at least 4 years of experience in BI and data analytics with a strong command of SQL and data modeling techniques. Proficiency in major BI tools like Tableau or Power BI and excellent communication skills are required.

Full description

We are seeking an experienced and detail-oriented Business Analyst to join our data team, developing high-quality dashboards, reports, and data solutions that support business decisions across multiple functions

Responsibilities

  • Develop dashboards, customized reports, and scorecards based on business requirements
  • Build compelling narratives, product features, and actionable insights using data
  • Manage ad hoc analytic requests in an accurate and efficient manner
  • Review and optimize SQL queries, and investigate database performance issues
  • Work with large-scale data architecture and apply multidimensional data modeling techniques (e.g. star schema, snowflake, slowly changing dimensions)
  • Collaborate cross-functionally with Product, Development, and Operations teams to translate business needs into data solutions
  • Utilize data visualization best practices and ensure consistency in reporting
  • Work with our data tech stack, including SQL Server, Amazon Redshift, Snowflake, and Tableau

Requirements

  • At least 4 years of experience in a similar role, working with BI and data analytics
  • Strong command of SQL databases and data architecture
  • Proven experience in data modeling and designing scalable BI solutions
  • Experience with at least one major BI/reporting application (e.g. Tableau, Power BI, Qlik)
  • Ability to lead communication across teams and foster cross-functional partnerships
  • Fast learner, able to quickly understand new systems, requirements, and technologies
  • Strong problem-solving skills with a structured and detail-oriented mindset
  • Excellent communication skills, a team player, self-motivated, and results-driven
  • Understanding of best practices, development guidelines, and performance standards

Similar roles