Krzysztof Lechowski, Data Engineering Developer in Dublin, Ireland
Krzysztof Lechowski

Data Engineering 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

Portfolio

  • Archmedian Ltd
    Spark, Apache Airflow, SQL, Python, Microsoft SQL Server
  • Toptal Client
    Apache Airflow, AWS S3, AWS EMR, SAS, PySpark, Python, SQL
  • Archmedian Ltd
    Microsoft Excel, Microsoft Access, jQuery, JavaScript, Laravel, Python, PHP...

Experience

Location

Dublin, Ireland

Availability

Part-time

Preferred Environment

Amazon Web Services (AWS), AWS, Python 3, SQL

The most amazing...

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

Employment

  • Owner | Manager | Data Engineer

    2017 - PRESENT
    Archmedian Ltd
    • Managed a globally distributed development team of analysts and developers.
    • Built data pipelines to model, merge, and clean data from various sources (Python, Apache Airflow). Built systems to analyze and interpret the data (Python, Apache Spark).
    • Designed DB objects, procedures, functions, views, and tables (MS SQL).
    • Built an investment professional platform from the ground up (DB design, application development).
    Technologies: Spark, Apache Airflow, SQL, Python, Microsoft SQL Server
  • 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: Apache Airflow, AWS S3, AWS EMR, SAS, PySpark, Python, SQL
  • IT Consultant

    2017 - 2017
    Archmedian Ltd
    • 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 the most suitable logic to be placed in the database layer.
    • Built a significant portion of server-side application logic in PHP with a Laravel framework.
    • Built a large portion of the front-end display layout (Blade, Bootstrap 3, HTML5, and CSS3). Added minor JavaScript usability improvements (jQuery UI).
    • Provided timely and clear project status updates and overviews of the solution.
    Technologies: Microsoft Excel, Microsoft Access, jQuery, JavaScript, Laravel, Python, PHP, MySQL
  • Senior Research Manager

    2012 - 2017
    Franklin Templeton
    • Coordinated three site teams and directly managed one of them. We were responsible for product data governance, data structure 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 by three times, and producing reporting capabilities.
    • Helped team members to manage business logic residing in MS Access.
    • Recruited, onboarded, trained, and mentored nine team members.
    • Conducted personal system trainings and demonstrations.
    Technologies: PHP, Python, Microsoft Access, MySQL, TIBCO, Investment Funds, Business Analysis, Technical Project Management
  • 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: C#, Microsoft Data Transformation Services (now SSIS), Microsoft SQL Server

Experience

  • hopcar.pl
    https://hopcar.pl/

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

  • Investment Proffesional Database

    Database and on-line reporting system hosting information on investment professionals for the world-leading asset manager.
    My involvement included:
    Technical:
    - designing database model and building the database
    - designing and testing data migrations
    - designing application layer (back-end and front-end)
    - troubleshooting
    Other:
    - mentoring the project team in project management and business analysis practices
    - providing project status updates
    - providing demonstrations and training to the business clients

Skills

  • Languages

    SQL, T-SQL, Python, Python 3, PHP, R, SAS, GraphQL, Snowflake
  • Paradigms

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

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

    Data Engineering, Software Development, Relational Database Design, Finance, Optimization, Data Reporting, Data Analysis, Data Analytics, Complex Data Analysis, SQL Design & Reporting, Big Data, Microsoft Data Transformation Services (now SSIS), TIBCO, Bloom Query Language (BQL), Business Analysis, Full-stack, Database Optimization, AWS, Investment Funds, Technical Project Management, Analytics, DBT SQL
  • Platforms

    Linux, Amazon Web Services (AWS), Windows, Mac OS
  • Frameworks

    Laravel, AWS EMR, Spark, Django
  • Libraries/APIs

    PySpark, Bloomberg API
  • Tools

    DataGrip, Mercurial, Git, Microsoft Access, Microsoft Excel, Microsoft Power BI, Bloomberg, Apache Airflow, Spark SQL, Graphene
  • Industry Expertise

    Project Management

Education

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

To view more profiles

Join Toptal
Share it with others