Position: Business Intelligence Engineer
Category: Data Engineer
English level: fluent
Years of experience: 9

— Looker Dashboards for the global software platform focused on digital media measurement, data, analytics, brand safety, and performance
— QlikView Dashboard for the global industrial water treatment company). Analysis of the regular security audit results in the company's facilities in the UK, European Union, and Australia.
— QlikView Dashboards for the top US retail corporation. Mainly used to analyze the data about the primary and secondary skills each Employee has. The company has the requirements regarding each skill headcount. The Dashboard helps them regulate the number of people with each skill dynamically across different Departments.
— QlikView Dashboard for the US distributor and merchandizer of supermarket non-foods. Company performance analysis, broken down by districts, stores, categories of goods
— QlikView Dashboards for the software development company. Analyzing time logged by company employees in JIRA and cost-effectiveness of company’s projects.
— QlikView Dashboards for one of the top insurance companies in the United States. Analyzing various aspects related to the clients’ credit risk. Includes scoring, geographical analysis, plan / actual analysis).
— QlikView Dashboards for the operator of senior homes network in the United Kingdom and the United States. Used to analyze effectiveness of senior homes operation as well as level of seniors’ comfort living there.
— Dashboards for one of the world’s top franchises specialized in coffee-making. Used to analyze the performance of coffee shops, quality of coffee, and quality of services (including Mystery Shopping methodology).
Looker Dashboards:
— Scoping of the new reporting platform with a customer.
— Analyzing data structures in Snowflake DWH, connecting Looker to the DWH using SQL and LookML queries.
— Arranging dimensions and measures with a customer and implementing them in Looker.
— Creating LookML views, explores, models, and dashboards as per client's requirements.
— Setting up user access logic using access grants and user attributes.
— Tracking development progress and cooperation with colleagues in the GitLab versioning system.

QlikView Dashboards:
— Composing / modifying / optimizing QlikView data reload scripts.
— Implement automatic data load errors handling system for all projects.
— QlikView data models development.
— Designing reports layout (creating and modifying objects using complex formulas, set analysis, variables, triggers, bookmarks, alternate states, etc.).
— Data visualization in QlikView reports using filters, pivot tables, charts.
— Managing QlikView reports automatic reload and distribution on the QlikView server.
— Managing user access via Section Access / on the server level.
— Understanding client’s business logic and the best ways of its reflection in BI solutions.
— Support and guidance work with Project Managers and stakeholders on the proposed solution structure and necessary components for successful delivery.
— Working with clients on preliminary scoping and dashboard architecture
— Writing technical specifications for the developed dashboards (instructions for the end-users, manuals for QA).
— Optimizing dashboards for better performance.
— Reviewing dashboards with legacy back-end or front-end.
— Implementing ETL logic in the data reload process.
— Tracking development process in the GitLab versioning system.