Krzysztof Lechowski
Verified Expert in Engineering
Data Engineering Developer
Krzysztof is a successful data engineer, analyst, and entrepreneur who has built many data-centric solutions for companies like Santander TFI and Franklin Templeton Investments over the past decade. He's familiar with various data technologies and combines that knowledge with a thorough understanding of client's needs to ensure goals are met for each project.
Portfolio
Experience
Availability
Preferred Environment
Amazon Web Services (AWS), Python 3, SQL
The most amazing...
...project I've built is an investment professional database for the world's leading asset manager.
Work Experience
Owner | Manager | Data Engineer
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).
Performance Analyst
Mediolanum International Funds LTD
- Provided in-depth analysis of MSCI ESG and SDG methodologies. Presented to the business members to provide clarity on the subject. Supported executives in preparing presentations for the broad business.
- Implemented data sourcing feeding into the MSCI ESG analytics system. Used sophisticated data techniques to produce the most accurate representation of the investment portfolios.
- Supported portfolio management process, preparing key facts for allocation decision-making. Prepared the meetings and sought them through the execution, and streamlined the process.
- Analyzed portfolios for portfolio manager assessments and performed minor stock analysis.
SQL Developer (Contract)
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.
IT Consultant
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.
Senior Research Manager
Franklin Templeton
- Coordinated three site teams and directly managed one of them. We were in charge of product data governance, data structure development, and the automation of data processes. We managed over 1,600 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 monthly reports.
- Developed a travel coordination system for key client-facing personnel, reducing manual work by three times and producing reporting capabilities.
- Helped team members manage business logic residing in Microsoft Access.
- Recruited, onboarded, trained, and mentored nine team members.
- Conducted personal system training and demonstrations.
Business Analyst
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.
Experience
hopcar.pl
https://hopcar.pl/Investment Professional Database
CONTRIBUTIONS
TECHNICAL
• Designing database model and building the database
• Designing and testing data migrations
• Designing application layer (back-end and front-end)
• Troubleshooting
OTHERS
• 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 (Transact-SQL), Python, Python 3, Snowflake, PHP, R, SAS, GraphQL, Bash
Paradigms
Database Design, Database Development, ETL, Test-driven Deployment, Agile Software Development, Scrum
Storage
MariaDB, MySQL, PostgreSQL, Database Modeling, Relational Databases, Amazon S3 (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, APIs, SSH, Microsoft Data Transformation Services (now SSIS), TIBCO, Bloom Query Language (BQL), Business Analysis, Full-stack, Database Optimization, Investment Funds, Technical Project Management, Analytics, Data Build Tool (dbt), Informatica, Sustainability, Morningstar, ESG, Financial Data Analytics
Libraries/APIs
Pandas, PySpark, Bloomberg API, Python API, REST APIs
Platforms
Linux, Amazon Web Services (AWS), Windows, MacOS, Unix
Frameworks
Laravel, Spark, Django, Django REST Framework
Tools
DataGrip, Mercurial, Git, Microsoft Access, Microsoft Excel, Amazon Elastic MapReduce (EMR), Microsoft Power BI, Bloomberg, Apache Airflow, Spark SQL, Graphene, GitHub, BigQuery
Industry Expertise
Project Management
Education
Master's Degree in Economics
University of Economics in Poznan - Poznan, Poland
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring