Lucas A.

Data Engineer

Lucas er en dataingeniør med seks års forretningsbakgrunn i å bygge og optimalisere dataløsninger. Han er dyktig i Python, SQL og NoSQL databaser, med omfattende ekspertise i verktøy som Airflow, Spark og Databricks.

Hans erfaring spenner over Google Cloud og Power BI, noe som gjør ham dyktig til å håndtere komplekse datautfordringer som kredittdatamodellering og HR-analyse. Lucas har med suksess utviklet dataprodukter og automatiserte prosesser for oppstartsbedrifter og store finansinstitusjoner i Brasil.

Hans sterke forretningssans gjør at han kan tilpasse dataløsninger til strategiske mål, og samarbeide tett med forretningsenheter for å drive datadrevne beslutninger. Han er kjent for sin evne til å håndtere komplekse tekniske utfordringer.

Hovedekspertise
  • SQL
    SQL 5 år
  • BigQuery
    BigQuery 3 år
  • dbt
    dbt 3 år
Andre kunnskaper
  • PostgreSQL
    PostgreSQL 2 år
  • Apache Airflow
    Apache Airflow 1 år
Lucas
Lucas A.

Brazil

Kom i gang

Utvalgt opplevelse

Arbeidserfaring

  • Data Engineer

    TerraMagna - 11 months

    • 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.

    Teknologier:

    • Teknologier:
    • BigQuery BigQuery
    • dbt dbt
    • NumPy NumPy
    • Pandas Pandas
  • Data Engineer

    Stone - 1 year 4 months

    • 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.

    Teknologier:

    • Teknologier:
    • BigQuery BigQuery
    • NumPy NumPy
    • Pandas Pandas
  • People Analytics Manager

    Creditas - 9 months

    • 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.

    Teknologier:

    • Teknologier:
    • Pandas Pandas
    • VBA VBA
  • Analytics Engineer

    Loft - 7 months

    • 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.

    Teknologier:

    • Teknologier:
    • dbt dbt
  • Data Engineer

    XP Inc - 1 year 7 months

    • 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.

    Teknologier:

    • Teknologier:
    • NumPy NumPy
    • Pandas Pandas
    • VBA VBA
  • Data Science & Analytics

    Guiabolso - 11 months

    • 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 year 2 months

    • 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.

    Teknologier:

    • Teknologier:
    • NumPy NumPy
    • Pandas Pandas
    • VBA VBA

Utdannelse

  • BSc.Applied mathematics

    University of São Paulo · 2014 - 2019

Finn din neste utvikler innen dager, ikke måneder

I løpet av en kort 25-minutters samtale ønsker vi å:

  • Forstå dine utviklingsbehov
  • Forklare prosessen vår der vi matcher deg med kvalifiserte, evaluerte utviklere fra vårt nettverk
  • Dele de neste stegene for å finne riktig match, ofte på mindre enn en uke

La oss ta en prat