Lucas A.

Data Engineer

Lucas est un ingénieur de données avec six ans d'expérience commerciale dans la construction et l'optimisation de solutions de données. Il maîtrise Python, SQL et les bases de données NoSQL, avec une expertise approfondie d'outils tels que Airflow, Spark et Databricks.

Son expérience s'étend à Google Cloud et Power BI, ce qui lui permet de relever des défis complexes en matière de données, tels que la modélisation des données de crédit et l'analyse des ressources humaines. Lucas a développé avec succès des produits de données et des processus automatisés pour des start-ups et de grandes institutions financières au Brésil.

Son sens aigu des affaires lui permet d'aligner les solutions de données sur les objectifs stratégiques, en travaillant en étroite collaboration avec les unités opérationnelles pour prendre des décisions fondées sur des données. Il est connu pour sa capacité à relever des défis techniques complexes.

Principale expertise
  • SQL
    SQL 5 ans
  • BigQuery
    BigQuery 3 ans
  • dbt
    dbt 3 ans
Autres compétences
  • PostgreSQL
    PostgreSQL 2 ans
  • Apache Airflow
    Apache Airflow 1 ans
Lucas
Lucas A.

Brazil

Commencer

Expérience sélectionnée

Emploi

  • Data Engineer

    TerraMagna - 11 mois

    • Development of Data Products: Spearheaded the creation of data products that seamlessly integrate with credit analysis platform applications and services, ensuring the provision of accurate and timely data to business units.

    • Pipeline Development and Data Modeling: Engineered robust data pipelines and performed advanced data modeling to facilitate the effective use of credit and disbursement data. This enabled operations teams to efficiently manage and optimize day-to-day activities.

    Les technologies:

    • Les technologies:
    • BigQuery BigQuery
    • dbt dbt
    • NumPy NumPy
    • Pandas Pandas
  • Data Engineer

    Stone - 1 an 4 mois

    • Credit Data Ingestion and Modeling: Managed the ingestion and modeling of credit data within a lakehouse environment using the Medallion architecture. Key deliverables included loan portfolio monitoring data products tailored for accounting, treasury, and business teams.

    • Process Automation: Collaborated with the product team to automate critical aspects of the credit granting processes. This involved streamlining the data flow from guarantees to the risk team and its associated systems, enhancing efficiency and accuracy.

    • Strategic Indicator Creation: Developed and implemented strategic indicators to support analytics, billing, and various other business units, driving data-driven decision-making across the organization.

    • Data Ingestion Optimization: Led the optimization of data ingestion processes and management practices, focusing on cost efficiency and resource optimization.

    Les technologies:

    • Les technologies:
    • BigQuery BigQuery
    • NumPy NumPy
    • Pandas Pandas
  • People Analytics Manager

    Creditas - 9 mois

    • Leadership and Development: Oversaw the management and growth of all People Analytics teams, ensuring alignment with organizational goals and HR strategies.

    • Development and Integrations: Directed a team responsible for automating and integrating various HR tools, including recruitment and payroll systems, through custom applications developed in Python. This enhanced the efficiency and connectivity of HR operations.

    • Analytics: Led a team focused on data modeling and the delivery of actionable insights. This team provided stakeholders outside HR with comprehensive reports, dashboards, and ad-hoc analyses using Sheets, PostgreSQL, and Metabase.

    • Products and Processes: Supervised a team dedicated to identifying efficiency opportunities within HR processes. This team was responsible for designing innovative products and workflows to streamline HR functions and improve overall operational effectiveness.

    Les technologies:

    • Les technologies:
    • Pandas Pandas
    • VBA VBA
  • Analytics Engineer

    Loft - 7 mois

    • Data Modeling: Modeled the sales and legal data logical layer using SQL, Python, and Databricks with the DBT tool. Enabled the business intelligence teams to create analyses and dashboards in Looker for stakeholder insights.

    • Data Migration Oversight: Managed the migration process between Salesforce environments for the sales and legal teams. Modeled legacy data and data from the new architecture to ensure seamless transition and data integrity.

    • Tool Testing and Feedback: Tested and provided feedback on a new tool developed by the data engineering team for the new data ingestion architecture. Documented data domains and contributed to the optimization of data ingestion processes.

    Les technologies:

    • Les technologies:
    • dbt dbt
  • Data Engineer

    XP Inc - 1 an 7 mois

    • Data Mapping: Mapped HR data across various sources, including SAP, Greenhouse, Mereo, and Mindisght Systems. Ensured comprehensive data integration and consistency.

    • HR Management Tool Integration: Implemented HR management tools for company managers by integrating various data sources (such as compensation, recruitment, goals, and organizational climate surveys) through APIs using batch Python scripts. This integration enhanced data accessibility and streamlined HR processes.

    • Automated Data Extraction: Developed automated routines in Python for extracting data from Greenhouse to support the admissions and recruitment processes, improving data efficiency and accuracy.

    • Power BI Dashboard Creation: Designed and developed the Power BI People Partner Dashboard, providing managerial insights for decision-making and facilitating strategic discussions with business leaders.

    Les technologies:

    • Les technologies:
    • NumPy NumPy
    • Pandas Pandas
    • VBA VBA
  • Data Science & Analytics

    Guiabolso - 11 mois

    • Data Warehouse Modeling and Implementation: Designed and implemented a data warehouse focused on CRM and product data using Databricks and PySpark (an interface for Apache Spark in Python). This architecture supported scalable data processing and integration.

    • Ad-Hoc Analysis: Conducted ad-hoc analyses for the CRM team and assessed campaign performance using Redshift queries and Tableau dashboards. Provided actionable insights to optimize marketing strategies.

    • Recommendation and Conversion Models: Developed recommendation and conversion models for CRM and marketing purposes. These models enhanced targeted marketing efforts and improved customer engagement.

  • Data Science & Analytics

    EY - 1 an 2 mois

    • Developed models to predict and explain short-term and long-term hospitalizations for insurance companies.

    • Provided actionable insights to enhance risk management and decision-making.

    • Created comprehensive reports and strategic indicators to help companies identify new strategies and improve process efficiency.

    • Enabled data-driven decisions to optimize business operations.

    Les technologies:

    • Les technologies:
    • NumPy NumPy
    • Pandas Pandas
    • VBA VBA

Éducation

  • License ès sciencesApplied mathematics

    University of São Paulo · 2014 - 2019

Trouvez votre prochain développeur en quelques jours et non sur plusieurs mois

Dans un court appel de 25 minutes, nous voulons:

  • Comprendre vos besoins en développement
  • Vous expliquez comment nous allons vous mettre en relation avec le développeur le mieux qualifié pour votre projet, sélectionné avec soin
  • Vous indiquez nos prochaines démarches afin de vous trouver le meilleur développeur, souvent en moins d'une semaine

Contactez-nous