Lian is available for hire
Hire LianLian Yagoda
Verified Expert in Engineering
BI Developer
Location
Tel Aviv-Yafo, Israel
Toptal Member Since
November 26, 2021
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, Databases...
Paldi Solutions
SQL, Databases, Sisense, JSON, APIs, Dashboard Design, Data Modeling...
Sisense
SQL, Sisense, JSON, Big Data, Amazon Web Services (AWS), Dashboard Design...
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, Databases, 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, Databases, Sisense, JSON, APIs, Dashboard Design, Data Modeling, Microsoft SQL Server, SQL Server BI, Business Intelligence (BI), Google Structured Data, Data Analytics, Big Data, Business Intelligence (BI) Platforms, Data Reporting, ETL, ETL Tools, Data Loading, Excel 365, MySQL Server, Google AdWords, 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, Amazon Web Services (AWS), Dashboard Design, Data Modeling, Microsoft SQL Server, SQL Server BI, Business Intelligence (BI), Databases, Google Structured Data, Data Analytics, Business Intelligence (BI) Platforms, Data Reporting, ETL, ETL Tools, Data Loading, Excel 365, MySQL Server, Google AdWords, 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, MicroStrategy Visual Insight, Tableau, Dashboard Design, Data Modeling, Business Intelligence (BI), Databases, SQL, Data Analytics, Big Data, 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, MySQL, SQL Server BI, Dashboard Design, Data Modeling, Microsoft SQL Server, Business Intelligence (BI), Databases, Data Analytics, PostgreSQL, Business Intelligence (BI) Platforms, Data Reporting, ETL, ETL Tools, Data Loading, Excel 365, MySQL Server, Oracle, Redshift, Microsoft Access
Experience
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.
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.
Skills
Languages
SQL, JavaScript, Python
Tools
Sisense, Tableau, Microsoft Power BI, SQL Server BI, IBM Cognos, Google Analytics, Microsoft Access, Looker, Qlik Sense
Paradigms
Business Intelligence (BI), ETL
Storage
Databases, JSON, Microsoft SQL Server, MySQL, PostgreSQL, MySQL Server, Redshift, MongoDB
Other
Big Data, Data Modeling, Dashboard Design, Data Analytics, Business Intelligence (BI) Platforms, MicroStrategy, MicroStrategy Visual Insight, Google Structured Data, Data Reporting, ETL Tools, Data Loading, Excel 365, Google BigQuery, Data Visualization, Machine Learning, APIs
Libraries/APIs
Google AdWords, Google Analytics API, JDBC
Platforms
Amazon Web Services (AWS), QlikView, Oracle
Certifications
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
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