toptal.com
Contact us: +1.888.867.7001
Jurijs Jefimovs, Data Engineer and Developer in Riga, Latvia
Jurijs Jefimovs

Data Engineer and Developer in Riga, Latvia

Member since September 29, 2020
Jurijs is an experienced Business Intelligence (BI) engineer with 14 years of experience building data warehouses (DWH) and BI applications. He can create a self-service BI environment for your organization from scratch, including building DWH, BI applications, and training for business users. He has strong experience with various relational, non-relational databases (NoSQL), and distributed systems.
Jurijs is now available for hire
Hire Jurijs

Portfolio

  • Luminor Bank AS
    Performance Tuning, Performance Analysis, Cloud Architecture...
  • LeoVegas Group
    Performance Analysis, Google Cloud Platform (GCP), APIs...
  • Betsson Group
    SQL Performance, Performance Tuning, Performance Analysis, APIs...

Experience

Location

Riga, Latvia

Availability

Part-time

Preferred Environment

PL/SQL, Talend ETL, ELK (Elastic Stack), MongoDB, PostgreSQL, Google BigQuery, Google Data Studio, Qlik Sense, QlikView, Tableau

The most amazing...

...thing I've rolled out was self-service BI with environment set up, data warehousing, ETL development, dimensional modeling, app development, and user training.

Employment

  • Unit Manager of Data Platform Unit/Service Area Delivery Manager

    2018 - PRESENT
    Luminor Bank AS
    • Released the first version of the transaction search which provides search capabilities for interactive account statement service to end-users of the internet bank.
    • Migrated customer transaction history from the old core system into a new data platform.
    • Introduced pub-sub message delivery semantics for data integration between backend components.
    • Built an internal team that took over the development of a data platform from an external consultancy.
    • Supervised and coordinated the implementation of functional and non-functional requirements.
    • Designed and defended various solution proposals in front of the enterprise architecture committee.
    Technologies: Performance Tuning, Performance Analysis, Cloud Architecture, Amazon Web Services (AWS), AWS, APIs, Business Intelligence (BI), Streaming, Requirements Analysis, Business Analysis, Impact Analysis, Big Data Architecture, Big Data, Data Visualization, Remote Team Leadership, Remote Work, Team Leadership, Leadership, ETL Implementation & Design, Elasticsearch, NoSQL, Database Architecture, Data Architecture, Data Pipelines, Data Lakes, Data Engineering, Data Modeling, Database Modeling, SQL, Kafka Streams, Kibana, Amazon EKS, Apache NiFi, AWS S3, AWS MSK

  • BI Engineer

    2017 - 2020
    LeoVegas Group
    • Developed various BI applications with QlikView and Tableau for business areas such as marketing, customer acquisition, CRM, responsible gaming, payments, and finance.
    • Created and supported various automated reports with Qlik NPrinting.
    • Developed ETL and data marts with QlikView and jobs orchestration with QlikView Publisher.
    • Built the DWH on Google Cloud Platform (dimensional modeling).
    • Developed a BI application that helps to configure payment providers' pricing models and automatically calculate commissions. Developed with Google Sheets (configuration tool), Google Big Query (ETL), and Data Studio (reporting).
    Technologies: Performance Analysis, Google Cloud Platform (GCP), APIs, Business Intelligence Training, Business Intelligence (BI), Requirements Analysis, Business Analysis, Impact Analysis, Analytical Thinking, Analytics, Analytical Dashboards, Visualization Tools, Visualization, Dashboard Design, Dashboards, Dashboard Development, Big Data, Data Visualization, Team Leadership, Remote Work, Database Architecture, Data Architecture, Data Pipelines, Data Lakes, Database Modeling, Data Modeling, SQL, ETL Implementation & Design, ETL, Google Data Studio, Google BigQuery, Tableau, Qlik NPrinting, QlikView

  • BI Data Engineer

    2016 - 2017
    Betsson Group
    • Implemented a self-service BI environment with Qlik Sense—from setting up the environment, data modeling, development of applications, and user training.
    • Developed various BI applications such as CLV for marketing and customer classification with Qlik Sence.
    • Created the POC of real-time analytics with ELK (Elastic stack).
    • Developed the POC of data analytical layer for a big data platform to accelerate data queries speed with Jethro data.
    Technologies: SQL Performance, Performance Tuning, Performance Analysis, APIs, Business Intelligence Training, Business Intelligence (BI), Analytical Dashboards, Analysis, Analytics, Visualization Tools, Visualization, Dashboard Development, Dashboards, Dashboard Design, Big Data, Data Visualization, ETL Implementation & Design, Elasticsearch, NoSQL, Data Architecture, Data Pipelines, Data Lakes, Data Engineering, Data Modeling, SQL, Kibana, Kibi, Tableau, Microsoft SQL Server, ELK (Elastic Stack), Jethro Data, Apache Hive, QlikView, Qlik Sense

  • Lead Software Developer

    2015 - 2016
    Intrum Justitia
    • Developed an analytical layer on top of the Big Data (Cloudera CDH) with the help of Apache Hive (ETL), Apache Impala (query engine), and Tableau (BI application layer).
    • Built a consolidated dimensional model that brought data from different sources into a single data model that fit many business reporting needs.
    • Introduced self-service BI to business users. Participated in many internal conferences in different offices around the EU to promote self-service BI with Tableau.
    Technologies: Performance Tuning, SQL Performance, Performance Analysis, APIs, Business Intelligence Training, Business Intelligence (BI), Analytical Thinking, Analysis, Analytics, Visualization Tools, Dashboards, Analytical Dashboards, Visualization, Dashboard Development, Dashboard Design, Big Data, Data Visualization, ETL Implementation & Design, NoSQL, Database Architecture, Big Data Architecture, Data Architecture, Data Pipelines, Data Lakes, Data Engineering, Data Modeling, Database Modeling, SQL, Apache Kylin, Apache Hive, Apache Impala, Tableau

  • Systems Analyst

    2009 - 2015
    Idea Port Riga
    • Developed and maintained DWH, ETL, and BI application processes for the insurance, telco, and pharmacy retailer companies.
    • Customized CRM system to fix reporting data gaps and improve ETL processes (CDC).
    • Built a data archiving tool to offload historical data from CRM to improve CRM's performance, which helped to decrease customer service response time.
    • Developed POC of fraud detection BI application, which helped find fraudulent cases and analyze the reasons behind insurance claims.
    • Created the POC of a product recommendation engine for pharmacy retailers, which could increase sales by offering similar products based on transactional data.
    Technologies: SQL Performance, Performance Tuning, APIs, Business Intelligence Training, Business Intelligence (BI), Visualization Tools, Visualization, Dashboard Design, Dashboard Development, Dashboards, Data Visualization, ETL Implementation & Design, Database Architecture, Data Architecture, Data Pipelines, Data Modeling, Database Modeling, SQL, Oracle Siebel CRM, Oracle Data Miner, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Oracle Warehouse Builder (OWB), Informatica PowerCenter, IBM Cognos Business Intelligence, Oracle RDBMS, Oracle BI EE 11g

  • Securities and Financial Market Department, Analyst Programmer

    2007 - 2009
    Rietumu Bank
    • Built the customer investment portfolio performance report for customers.
    • Created customer account statements and other regulatory reports automation.
    • Developed the automated generation of customers' account statements and send-outs by email.
    Technologies: SQL Performance, Performance Tuning, Performance Analysis, APIs, Business Intelligence (BI), Data Visualization, ETL Implementation & Design, Database Architecture, Data Architecture, Data Pipelines, Data Modeling, Database Modeling, SQL, Bloomberg API, Reuters API, Excel VBA, Microsoft Excel, Microsoft Access, T-SQL, Microsoft SQL Server, Crystal Reports

  • Senior Developer

    2006 - 2007
    Accenture
    • Developed the integration layer between legacy systems and Oracle Siebel CRM (Java).
    • Customized various Siebel CRM applications for clients.
    • Improved performance of Siebel CRM system for a few clients by reviewing and refactoring custom scripts.
    Technologies: Performance Tuning, Performance Analysis, APIs, Data Modeling, Database Architecture, SQL, Java, Oracle Siebel CRM

Experience

  • Data Streaming Platform

    I led and supervised the implementation of the data streaming platform for daily banking needs (end users/retail). We have successfully released the first version of data streaming platform services and created a good foundation for future services that can recommend and communicate the right information at the right time to customers. This can potentially increase user engagement and the usage of banking products and services.

  • Self-service BI Environment

    I've introduced a self-service BI environment inside a company that helped reduce reports and data analyses delivery time. First, I've set up the Qlik Sense environment and build data marts used by business users for ad hoc report creation and sharing. Then, I've trained business analysts on how to create data marts of their domain areas inside Qlik Sense to help faster react to business analytical needs.

  • Analytical Layer on Top of Big Data

    Designed and implemented an analytical layer on top of the Hadoop raw data, which allowed to build a flexible BI application layer to satisfy the company's reporting and ad hoc query needs. Instead of building custom reporting solutions with map-reduce, I've proposed making a dimensional model (star schema) on top of the Hadoop with Hive's help as the ETL engine and Impala for accelerating queries over Hive metadata. I also introduced self-service BI with Tableau. This was completely my initiative, which I completed in 2015 when people had zero trust in such technologies.

  • Tableau Public Profile
    https://public.tableau.com/profile/jurijs.jefimovs#!/

    Tableau public profile where you can see examples of Tableau applications/dashboards. There you can find examples of interactive dashboards, geospatial charts, Sankey diagrams, applications build using public data sources such as GDELT, Riga Open Data (new-birth statistics), Kaggle competition, and more.

Skills

  • Languages

    SQL, T-SQL, Excel VBA, Java, R, Python, JavaScript

  • Tools

    Tableau, Apache Impala, Informatica PowerCenter, Oracle Warehouse Builder (OWB), Qlik Sense, ELK (Elastic Stack), Talend ETL, Apache NiFi, Amazon EKS, Kafka Streams, Crystal Reports, Microsoft Access, Microsoft Excel, Microsoft Power BI

  • Paradigms

    Database Design, Dimensional Modeling, ETL, ETL Implementation & Design, Requirements Analysis, Business Intelligence (BI), Data Science

  • Storage

    Database Architecture, Database Modeling, PL/SQL, Apache Hive, Data Lakes, Data Pipelines, NoSQL, Elasticsearch, SQL Performance, PostgreSQL, MongoDB, AWS S3, Microsoft SQL Server, Oracle RDBMS, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

  • Other

    Data Warehouse Design, ETL Development, Data Modeling, Data Architecture, Data Visualization, Dashboard Development, Dashboards, Dashboard Design, Visualization, Visualization Tools, Analytical Dashboards, Analytics, Analytical Thinking, Analysis, Impact Analysis, Business Analysis, Business Intelligence Training, Google Data Studio, Google BigQuery, Data Engineering, Performance Analysis, AWS MSK, Jethro Data, Apache Kylin, IBM Cognos Business Intelligence, Oracle Data Miner, Oracle Siebel CRM, Reuters API, Performance Tuning, Big Data Architecture, Leadership, Team Leadership, Remote Work, Remote Team Leadership, NiFi, IT Project Management, Big Data, Streaming, APIs, AWS, Cloud Architecture, Open Data, Data Transformation

  • Platforms

    QlikView, Qlik NPrinting, Oracle BI EE 11g, Apache Kafka, Amazon Web Services (AWS), Google Cloud Platform (GCP)

  • Libraries/APIs

    Bloomberg API, Spark ML

  • Industry Expertise

    Project Management

Education

  • Master's Degree in Computer Science
    2002 - 2009
    Transport and Telecommunication Institute - Riga, Latvia

Certifications

  • MongoDB Performance
    MARCH 2019 - PRESENT
    MongoDB University
  • Google Cloud Platform Big Data and Machine Learning
    SEPTEMBER 2017 - PRESENT
    Coursera
  • Tableau Advanced Trainings
    JANUARY 2016 - PRESENT
    Udemy
  • Big Data XSeries
    AUGUST 2015 - PRESENT
    edX
  • Data Science Specialization
    MAY 2015 - PRESENT
    Coursera

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM