Krzysztof Lechowski, Relational Database Design Developer in Dublin, Ireland
Krzysztof Lechowski

Relational Database Design Developer in Dublin, Ireland

Member since May 29, 2019
Krzysztof is a successful data engineer, analyst, and entrepreneur who has built many data-centric solutions over the past decade for companies like Santander TFI and Franklin Templeton Investments. He's familiar with a variety of data technologies and combines that knowledge with a thorough understanding of clients' needs to ensure goals are met for each project.
Krzysztof is now available for hire




Dublin, Ireland



Preferred Environment

DataGrip, MS SQL Server Studio, Mercurial, Git

The most amazing...

...built investment professionals' DB for world's leading asset manager. Performed business analysis, DB modeling, back-end and front-end development.


  • Consultant, Developer, Manager, Owner

    2017 - PRESENT
    Archmedian Ltd
    • Provided expertise in business analysis, business modeling, database modeling, ETL development, full-stack development, and business administration.
    Technologies: MS SQL, SSIS, MySQL, AWS S3, Python, PHP, JavaScript
  • SQL Developer (Contract)

    2019 - 2020
    Toptal Client
    • Provided consulting services in personalization analytics, code logic migration (SAS->PySpark), writing PySpark codebase, implementing sophisticated logic in SAS and PySpark, monitoring execution, and communicating and troubleshooting issues.
    Technologies: SQL, Python, PySpark, SAS, AWS EMR, AWS S3, Airflow
  • IT Consultant

    2017 - 2017
    Franklin Templeton Investments
    • Elicited, understood, and organized business requirements.
    • Guided team members through project phases. Mentored and brought talents to light.
    • Designed the database for the system, and built logic most suitable to be placed in the database layer.
    • Built a significant portion of server-side application logic in PHP with Laravel framework.
    • Built a large portion of the frontend - display layout (Blade, Bootstrap 3, HTML5+CSS3). Added minor JS usability improvements (jQuery UI).
    • Provided timely and clear project status updates.
    Technologies: MySQL, PHP, Python, Laravel, JavaScript, jQuery, MS Access, Excel
  • Senior Research Manager

    2012 - 2017
    Franklin Templeton Investments
    • Coordinated three site teams and directly managed one of them. We were responsible for product data governance, data structures development and the automation of data processes. We managed over 1600 products and over 2,000 data elements.
    • Built several automated ETL processes regarding product data. They filter, merge, reclassify, and restructure the data reducing days of high-skill manual work every month.
    • Designed and built a self-service financial product data extraction system serving over 600 reports per month.
    • Built a travel coordination system for key client-facing personnel, reducing manual work (3x) and producing reporting capabilities.
    • Helped team members to manage business logic residing in MS Access.
    • Recruited, onboarded, trained, and mentored nine team members.
    • Assisted in system demonstrations and trainings.
    Technologies: Tibco Data Virtualization, MySQL, MS Access, MySQL, Python, PHP
  • Business Analyst

    2008 - 2012
    Santander TFI
    • Redesigned mathematical model for trader's bonus system.
    • Learned business processes hands-on.
    • Elicited and managed requirements for a software integration platform.
    • Designed a large proportion of the integration platform database.
    • Developed functions, procedures, and other database objects to meet data process requirements.
    • Developed significant parts of the C# application layer of the integration platform.
    Technologies: MS SQL Server, MS SSIS, C#


  • (Development)

    A unique ride-sharing platform. Allows for short and long-distance, single and repetitive ride-sharing in Poland. Full-stack development.


  • Languages

    SQL, T-SQL, Python, Python 3, SAS
  • Paradigms

    Database Design, Database Development, ETL, Agile Software Development, Scrum
  • Storage

    MariaDB, MySQL, PostgreSQL, Database Modeling, Relational Databases, SQL Server Integration Services (SSIS), Microsoft SQL Server, Redshift
  • Other

    Software Developer, Software Development, Relational Database Design, Finance, Optimization, Data Reporting, Data Analysis, Data Analytics, Complex Data Analysis, SQL Design & Reporting, Big Data, Analytics
  • Platforms

    Linux, Windows, Mac OS
  • Frameworks

  • Tools

    Apache Airflow, Spark SQL


  • Master's degree in Economics
    2003 - 2008
    University of Economics in Poznan - Poznan, Poland

To view more profiles

Join Toptal
Share it with others