L

Lucas Bakx

About

Detail

California, United States

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Current Health
    Senior Software Engineer
    Current Health
    Feb 2023 - Current (3 years 8 months)
    • Led the design and development of a HIPAA-compliant analytics platform integrating patient health data, IoT devices, and lab reports through ETL pipelines using Python, SQLAlchemy, and PostgreSQL, improving query performance by 40%. • Built advanced Metabase dashboards (embedded in a React-based clinician portal) for real time patient monitoring, leveraging Row & Column security and multi-tenant data models. • Designed optimized data models and views for lab analytics, supporting over 100+ concurrent Metabase queries with sub-second response time. • Implemented data aggregation pipelines using AWS Lambda, RDS, and S3, automating daily ETL jobs and reducing manual data prep time by 70%. • Developed benchmarking dashboards comparing an
  • Scoro
    Software Engineer
    Scoro
    Mar 2018 - Dec 2022 (4 years 10 months)
    • Designed and optimized business intelligence dashboards in Metabase and Tableau, connecting PostgreSQL-based CRM and billing data. • Built ETL pipelines for time-tracking, invoices, and project data using Python (Pandas, Airflow) and AWS Glue, reducing processing time from hours to minutes. • Developed scalable RESTful APIs with Node.js (Express) and Django, exposing key analytics endpoints for internal and partner systems. • Created multi-tenant reporting modules for client accounts, ensuring strict row-level access control and optimized SQL performance. • Contributed to modernization of the analytics stack, migrating from legacy MySQL to PostgreSQL, resulting in 25% faster query execution. • Integrated analytics dashboards into Sc
  • S
    Junior Software Engineer
    Software Mind
    Aug 2014 - Feb 2018 (3 years 7 months)
    • Assisted in development of data processing APIs and ETL workflows using Java, Spring Boot, and PostgreSQL. • Implemented automated data transformations and exports to support customer analytics tools and reporting systems. • Built SQL queries and stored procedures for reporting modules, enhancing data accessibility for internal stakeholders. • Supported migration of on-premise databases to AWS RDS, improving scalability and backup reliability. • Collaborated with senior developers to refactor legacy monoliths into microservices, improving system maintainability. • Introduced unit and integration testing using JUnit, Mocha, and Cypress for backend and frontend reliability. • Gained foundational experience in REST API design, JSON sc
Education verified_user 0% verified
  • University of Warsaw
    Bachelor's Degree
    University of Warsaw
    Jan 2011 - Jan 2014 (3 years 1 month)