Andrey Shalitkin, Software Developer in Lisbon, Portugal
Andrey Shalitkin

Software Developer in Lisbon, Portugal

Member since June 9, 2016
Andrey's passion is to help companies become truly data-driven and succeed in business by making correct and informed decisions. He performs consultancy, implements business intelligence solutions, and designs data warehouses using Snowflake, BigQuery, Redshift, DBT, and Looker.
Andrey is now available for hire


  • DataProf
    Business Intelligence (BI), Amazon Web Services (AWS), Node.js, Redshift...
  • Maisonette, Inc.
    Snowflake, Looker, Data Build Tool (dbt), Data Analysis, Databases...
  • Aurea
    Amazon Web Services (AWS), JavaScript, Python, Java



Lisbon, Portugal



Preferred Environment

Git, IntelliJ IDEA, MacOS

The most amazing... intelligence solutions based on Snowflake, DBT, and Looker stack I've implemented from scratch involved management and technical levels.


  • Managing Partner and Business Intelligence Expert

    2016 - PRESENT
    • Co-founded and services.
    • Implemented BI solutions for several clients based on Snowflake + DBT + Looker stack.
    • Managed multiple teams in the area of BI systems implementation.
    Technologies: Business Intelligence (BI), Amazon Web Services (AWS), Node.js, Redshift, Microsoft Power BI, Python, Looker, PostgreSQL, Snowflake, Data Warehouse Design, Data Warehousing, SQL, Data Analytics
  • Data Analytics Engineers

    2021 - 2023
    Maisonette, Inc.
    • Implemented a BI solution for marketing channel performance tracking. It involved setting up pipelines gathering data from different tracking platforms, joining it with the CRM data, and designing and implementing the dashboards in Looker.
    • Designed and implemented data pipelines and a set of dashboards for the website performance, joining this data with the sales information to figure out the correlation.
    • Created performance metrics for the DBT project and then refactored the DBT project to simplify it and optimize the data warehouse cost.
    Technologies: Snowflake, Looker, Data Build Tool (dbt), Data Analysis, Databases, Data Analytics, ETL, Fivetran, SQL, Business Intelligence (BI), Data Warehouse Design, Data Warehousing
  • Java Architect

    2015 - 2016
    • Successfully implemented a project of integration of BPM product with the monitoring system.
    • Made a significant contribution to the project of the product virtualization in the AWS cloud by creating a central logging mechanism.
    • Performed a codebase analysis for a legacy codebase and identified the most critical parts of the system that allowed to create efficient test coverage strategy; used Python for this project.
    Technologies: Amazon Web Services (AWS), JavaScript, Python, Java
  • Technical Leader | Architect

    2013 - 2015
    • Built, along with my colleagues, a new web component based on Spring REST and AngularJS.
    • Implemented a Groovy-based validation framework that allowed us to control almost all UI behavior via rules invoked from the back end.
    • Performed architectural refactoring to transform the existing component from monolithic to SOA.
    • Led (technically) five distributed development teams working on financial regulatory requirements.
    • Ported reporting rules from AbInitio to IBPM rules with a Java intermediary.
    Technologies: Oracle RDBMS, Spring, AngularJS, JavaScript, Groovy, Java
  • Leading Software Developer

    2010 - 2013
    Luxoft Russia
    • Developed an ETL-like tool to get IB clients data from external sources.
    • Participated in "small changes" project fixing a lot of bugs, doing minor functional changes, and a lot of refactoring in the existing Workflow tool for client onboarding.
    • Integrated multiple existing components via REST and WS within a new business process (implemented in IBM BPM) for a client account creation.
    Technologies: BPM, Servlet, JSP, Oracle RDBMS, Spring, Java
  • Software Developer

    2006 - 2010
    Siemens IT Solutions and Services
    • Developed, as part of a team, a communication system for the Siemens Buyside Marketplace. The biggest part was to integrate with third-party solutions.
    • Developed a web application for JMS messages monitoring and troubleshooting.
    • Implemented documentation generation module based on UML for a MDA solution (open architecture ware).
    • Participated in the portlet development for a portal for a big communications company.
    Technologies: JMS, Spring, Java


  • Virtualization of an Existing Product

    The project virtualized an existing product in AWS with minimal changes to the product itself. We had to solve such problems as centralized logging, configuration updates, and to make each node autonomous.

  • Web Tool

    I led a team that created a new web tool. The purpose of the tool was to make the first engagement with the IB clients and monitor activities happening during the whole onboarding process.

  • Porting of Financial Regulatory rules

    I led a team that did reverse engineering of existing rules in Ab Initio and ported them to the IBM rules with a Java intermediary.

  • ETL Tool

    As a development team member, I participated in the project where we need to build a system loading IB (Investment Bank) client information from external sources, applied some validation, transformation and matching rules and saving the data into the MDM (Master Data Management) system

  • Architectural Refactoring

    I performed architectural refactoring to transform an existing monolithic component to SOA architecture

  • Togeton

    It's a service for self-employed people in the beauty area that helps them to easily manage their schedules and provide clients with some kind of self-service.

  • Data Warehouse

    A data warehouse in AWS cloud based on Redshift and DBT

  • BI Implementation

    I developed a BI management system by the means of Looker on top of a Redshift data warehouse.

  • Dating Service

    I developed a type of dating service. You can see more at the link attached.

  • Write Tests That Matter: Tackle The Most Complex Code First (Publication)
    In today's world, code is expected to change as quickly as requirements do, and tests play an important role in making that possible. Many modern projects boast great test coverage, making them more resilient to regression issues. However, that is not true for all projects - especially some legacy projects which have little in the way of testing. In this article, Toptal Freelance Software Engineer Andrey Shalitkin discusses two metrics, coupling and cyclomatic complexity, that are important in identifying which portions of code to include in test coverage.


  • Languages

    SQL, Java, Snowflake, JavaScript, Groovy, Python
  • Frameworks

    Mockito, JUnit, AngularJS, Spring, JSP, JPA, PowerMock
  • Tools

    Looker, Subversion (SVN), Git, IntelliJ IDEA, Servlet, Apache Tomcat, Jira, Hudson, Cucumber, Microsoft Power BI
  • Paradigms

    Business Intelligence (BI), Agile, Functional Programming, Scrum, ETL
  • Other

    Data Warehousing, Data Warehouse Design, BPM, Data Build Tool (dbt), Data Analysis, Data Analytics, Fivetran
  • Libraries/APIs

    JDBC, Spring REST, Node.js, Pandas, JMS
  • Storage

    Redshift, PostgreSQL, Oracle RDBMS, NoSQL, MongoDB, Databases
  • Platforms

    MacOS, Oracle, Amazon Web Services (AWS)


  • PhD Degree in Computer Science
    2007 - 2011
    Voronezh State University - Voronezh, Russia
  • Master's Degree in Computer Science
    2002 - 2007
    Voronezh State University - Voronezh, Russia

To view more profiles

Join Toptal
Share it with others