BI Analyst
Who we are:
Pillar is an Israeli and Ukrainian company with more than 6 years of history in the Ukrainian market, that provides outsourcing and outstaff services to world-class companies all over the world (e.g. Shift, Archidata, etc).
Every day we partner across functional areas: logistics, medicine, education, tourism, game industry, utilities, data storage, etc.
We work in a flexible environment where there is an opportunity to achieve results, receive feedback for learning, improve ways of working by developing both soft and hard skills, and contribute to a corporate culture focused on people.
Our team is highly experienced, and all the projects we work on are solid and long-term as our clients appreciate our expertise and stay with us for a long.
We are also keen on learning from each other, that is why we cheerfully meet people who bring a new set of experiences and backgrounds to our team.
About the project:
Shift is a cloud-based management service for educational and business institutions. It develops applications for passenger transportation – the system builds tracks on the basis of passenger requirements and needs. Managing track changes, real-time monitoring of the trip, alerts on the way, and navigation based on route information are the best of the services we are providing to our customers.
It can also build optimal routes, creating a variety of reports that help to receive information about a route and determine how many people were or were not on the route or which bus was needed, etc. We transport the military, prisoners, medical workers, schoolchildren, and many others, saving our customers up to 40% of the transportation budget.
About the role:
As a Business Intelligence (BI) Analyst, you will create and manage BI and analytics solutions that turn data into knowledge. In this role, you should have a background in data and business analysis. You should be analytical and an excellent communicator. If you also have business acumen and problem-solving aptitude, we would be really glad to meet you.
What you’ll do:
- Be responsible for the visual design according to the provided design.
- Create and modify reports/dashboards according to the tasks.
- Perform optimization to speed up and improve the quality of dashboards and reports.
- Search and implement new BI solutions.
- Fix errors in reports and dashboards.
- Work on reports and dashboards includes not only working with PowerBI tools but also working with data at the Azure SQL level, transporting data through the mechanisms implemented in Shift.
What you’ll need:
Must:
- Good English level: B1+
- Knowledge of SQL queries.
- Proven abilities to take initiative and be innovative.
- Analytical mind with a problem-solving aptitude.
- Good experience with Power BI (Strong advantage).
- Love thinking broadly and creatively about problems and how to solve them efficiently.
Nice to have:
- Any experience with cloud-based analytics services
(Azure Analysis Services or Fabric). - Any experience with building flow in Power Automate.
- Any experience with Mixpanel/Amplitude.
What’s in it for you:
- Company & Team Events.
- Book Club.
- Online Education.
- Football Team, Running Team, Gym Compensation.
- English Lessons.
- Life and Health Insurance.
- Paid Vacations.
- Play Area.
- Professional Conferences; Retains incentive programs.
You can work either remotely or from our office in Vinnytsia.
We care a lot about communication, autonomy, curiosity, and initiative, that is why
we keep in touch with you despite the work format you choose and value your
work/life balance. We care about family and your own personal development, that’s
why we don’t expect you to always be engaged with work.
We appreciate your time and efforts, that’s why our recruitment team always endeavors to choose the most convenient time for you.
You will have a four-step interview, which includes a preliminary test, a 30-minute HR and GM (General Manager) interview, a technical interview, and a short call with the Shift’s CEO.
- A preliminary test.
Before interviews, you’ll be given a short technical test.
Each question is timed. The estimated test duration is 40 minutes. - HR and GM Interview.
Here we want to get to know you, hear about what you’re interested in, and learn about what you hope to do in the future. We’ll also tell you about us and the project, answer your questions, and talk about company benefits. - Technical interview.
During this interview, we aim to gain a deeper understanding of your technical expertise and employment history.
The interview will be conducted by Shift’s CIO, who will ask a series of technical questions to assess your knowledge and problem-solving skills.
The primary objective is to evaluate your technical capabilities as well as your alignment with the role on both a professional and personal level. - Personal meeting with Shift CEO.
If you were successful after each previous step we’d arrange a call with the CEO of Shift, who would like to e-meet you to get to know you better, talk about how you approach problem-solving, how you think about the process, etc.
You won’t need to prepare anything in advance.