Lian Yagoda, Developer in Tel Aviv-Yafo, Israel
Lian is available for hire
Hire Lian

Lian Yagoda

Verified Expert  in Engineering

Bio

Lian has a decade of experience with different BI platforms, working as a BI developer and technical support consultant. She is an expert in data modeling, querying, manipulation, and visualization of data outputs, and she likes to use Sisense, Tableau, Qlik Sense, Power BI, and Looker. Lian enjoys using her skills to contribute to the exciting technological advances daily.

Portfolio

Workiz Inc.
Google BigQuery, SQL, Data Visualization, Dashboard Design, Database...
Paldi Solutions
SQL, Database, Sisense, JSON, APIs, Dashboard Design, Data Modeling...
Sisense
SQL, Sisense, JSON, Big Data Architecture, Amazon Web Services (AWS)...

Experience

Availability

Part-time

Preferred Environment

Sisense, Microsoft Power BI, Looker, Tableau, Qlik Sense, Google BigQuery

The most amazing...

...BI solution I've created is a complete insights environment for Israel's most significant HR company, with dozens of customized reports for all business units.

Work Experience

Senior Data Analyst

2022 - PRESENT
Workiz Inc.
  • Migrated the company data from different sources and databases to one data lake (Google BigQuery) and created new tables and views with aggregated information for easier analysis.
  • Planned and created a fintech analysis board with usage trends and forecasts, the insights from which led to significant action and a shift in the company's focus towards fintech.
  • Improved sales and customer satisfaction by working with sales and CS teams to standardize their work processes and define main performance KPIs, creating dashboards to track the teams progress.
Technologies: Google BigQuery, SQL, Data Visualization, Dashboard Design, Database, Data Analytics

Senior BI Consultant

2018 - PRESENT
Paldi Solutions
  • Designed, implemented, and maintained a complete insights environment using Sisense for the biggest HR company in Israel, including dozens of customized dashboards for all business units of the company, with hundreds of active users.
  • Performed research and design for new features of Paldi Solutions add-on products sold to dozens of clients in Sisense Marketplace.
  • Worked closely with Sisense support team and client's technical teams to troubleshoot and improve existing Sisense setup resulting in the client's license renewal and expansion.
  • Provided complex new dashboards with real-time analysis for an insurance company to monitor agents' performance during hurricane Ada.
Technologies: SQL, Database, Sisense, JSON, APIs, Dashboard Design, Data Modeling, Microsoft SQL Server, SQL Server BI, Business Intelligence (BI), Google Structured Data, Data Analytics, Big Data Architecture, Business Intelligence (BI) Platforms, Data Reporting, ETL, ETL Tools, Data Loading, Excel 365, MySQL Server, Google Ads, Google Analytics, Google Analytics API, Google BigQuery, Oracle, MongoDB, Redshift, Python, Data Visualization

Advanced Technical Solutions Consultant

2015 - 2017
Sisense
  • Assisted hundreds of Sisense clients in solving technical and data modeling-related issues in the software.
  • Provided dedicated close support for top-tier Sisense clients such as Nadaq and Foodpanda.
  • Managed all of Sisense’s hosted client environments using AWS EC2.
Technologies: SQL, Sisense, JSON, Big Data Architecture, Amazon Web Services (AWS), Dashboard Design, Data Modeling, Microsoft SQL Server, SQL Server BI, Business Intelligence (BI), Database, Google Structured Data, Data Analytics, Business Intelligence (BI) Platforms, Data Reporting, ETL, ETL Tools, Data Loading, Excel 365, MySQL Server, Google Ads, Google Analytics, Google Analytics API, Google BigQuery, Oracle, MongoDB, Redshift, JDBC, Python, Microsoft Access

BI Developer

2014 - 2015
Twingo
  • Planned and developed reports, dashboards, and data loads using MicroStrategy for the usage of the leading taxi app in Israel.
  • Traveled to client’s job as Tableau reseller, resulting in dozens of new purchases.
  • Created customized reports using MicroStrategy Visual Insight for major telecommunication companies including Huawei and Vodafone.
Technologies: MicroStrategy Development, MicroStrategy Visual Insight, Tableau Development, Dashboard Design, Data Modeling, Business Intelligence (BI), Database, SQL, Data Analytics, Big Data Architecture, Business Intelligence (BI) Platforms, Data Reporting, ETL, ETL Tools, Data Loading, Excel 365, MySQL Server, Google BigQuery, Oracle, Redshift, Microsoft SQL Server, Microsoft Access, Data Visualization

BI Developer and Unit Commander

2011 - 2014
Israel Defense Forces
  • Commanded a team of five soldiers, assigning projects, mentoring, and overseeing the work.
  • Performed real-time, extremely high-pressure analysis to find patterns in big data, rewarding my team an award from the head of the intelligence division in the IDF.
  • Used IBM Cognos to design and develop reports based on complex SQL statements, onboarding dozens of users on the correct usage of dashboards.
Technologies: IBM Cognos, SQL, Big Data Architecture, MySQL, SQL Server BI, Dashboard Design, Data Modeling, Microsoft SQL Server, Business Intelligence (BI), Database, Data Analytics, PostgreSQL, Business Intelligence (BI) Platforms, Data Reporting, ETL, ETL Tools, Data Loading, Excel 365, MySQL Server, Oracle, Redshift, Microsoft Access

Support Team Performance Analisys

A set of dashboards analyzing the speed and quality of a chat support team in a Saas product company, using data from Intercom, Jira, and HubSpot, extracted by API.

The main performance dashboard contained, among other measures: speed to first reply (broken by chats opened during working hours or outside of working hours), the average time to resolution, average satisfaction score, and percentage of chats escalated to level 2. The dashboards allow filtering by support representatives to see their performance compared to the rest of the team and different time resolutions (week, month, and quarter). All the main KPIs show the growth from the previous period.

Other dashboards in this project are: customer satisfaction score analysis, which provides insights as to how different customer tiers rate the team, and the support given to different types of requests (report a bug\assistance\general questions, etc.).

A live control room operational dashboard for the use of a team manager to see the current status, the number of chats handled by each rep, and load management.

Jira tickets dashboard to measure issues coming from customers and escalated to R&D as bugs or product questions.
DECEMBER 2021 - PRESENT

Mastering LookML: Looker's Modeling Language

Udemy

OCTOBER 2020 - PRESENT

Embedding Sisense Advanced Training

Sisense

OCTOBER 2020 - PRESENT

Sisense Blox

Sisense

MAY 2015 - PRESENT

Sisense Dashboard Designer and Data Modeler

Sisense

Libraries/APIs

Google Analytics API, JDBC

Tools

Sisense, Tableau Development, Microsoft Power BI, SQL Server BI, IBM Cognos, Google Analytics, Microsoft Access, Looker, Qlik Sense

Languages

SQL, JavaScript, Python

Paradigms

Business Intelligence (BI), ETL

Storage

Database, JSON, Microsoft SQL Server, MySQL, PostgreSQL, MySQL Server, Redshift, MongoDB

Platforms

Google Ads, Amazon Web Services (AWS), QlikView, Oracle

Other

Big Data Architecture, Data Modeling, Dashboard Design, Data Analytics, Business Intelligence (BI) Platforms, MicroStrategy Development, MicroStrategy Visual Insight, Google Structured Data, Data Reporting, ETL Tools, Data Loading, Excel 365, Google BigQuery, Data Visualization, Machine Learning, APIs

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring