Skip to content
View ChristianLG2's full-sized avatar
💼
Open to Work!
💼
Open to Work!
2 followers · 1 following

Achievements

Achievement: YOLOAchievement: Pull SharkAchievement: Pair Extraordinaire

Achievements

Achievement: YOLOAchievement: Pull SharkAchievement: Pair Extraordinaire

Highlights

  • Pro

Organizations

@OrpheusAnalytics

Block or report ChristianLG2

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ChristianLG2/README.md

Christian Lira G. — Analytics Engineer

About Me

你好, Hola, Hello GitHub Community!

I build end-to-end data and analytics systems, from pipelines and data models to APIs, machine learning, and business intelligence applications.

My work sits at the intersection of data engineering, analytics, applied AI, and business context. I care about data that is governed, modeled correctly, and ultimately used to drive decisions.

Currently building Orpheus Analytics, an economic intelligence platform combining:

FRED + BLS → ELT Pipelines → PostgreSQL + pgvector → ML Forecasting → RAG API

Previously worked on production analytics and data solutions at Tesla and BYU-Idaho.

Languages: English · Español · 普通话


Tesla
Tesla
Data Analyst Finance Operations
Sep 2023 – Sep 2024 		BYU-Idaho
BYU–Idaho
Analytics Engineering Lead
Apr 2025 – Dec 2025 		Orpheus Analytics
Orpheus Analytics
Founder & AE Lead
Feb 2026 Present


Current Projects

Project Stack Status
Orpheus Analytics Platform Python · FastAPI · PostgreSQL · Docker · pgvector Active ELT + ML + RAG
olist-lakehouse-pipeline Azure · Databricks · dbt · PySpark Active
SQL Analytics Portfolio T-SQL · dbt · Snowflake · PySpark · Quarto 4 projects completed 3 in progress
DP-600 Fabric Analytics Engineer Microsoft Fabric · Power BI · DAX In progress
IBM Data Engineering Professional Data Engineering fundamentals In progress

GitHub stats

Pinned Loading

  1. olist-lakehouse-pipeline olist-lakehouse-pipeline Public

    End-to-end Azure Databricks pipeline (PySpark, Delta Lake, dbt, CI/CD) on the Olist e-commerce dataset, medallion architecture with orchestration and automated deployment.

  2. SQL-Analytics-Portfolio SQL-Analytics-Portfolio Public

    SQL analytics portfolio: T-SQL, window functions, cohort analysis, query optimization, star schema, dbt, and Snowflake on the Northwind database

    TSQL

  3. legacy-to-fabric-migration legacy-to-fabric-migration Public

    End-to-end SQL Server to Microsoft Fabric migration: medallion Lakehouse, dimensional model, and a governed Direct Lake semantic layer.

    Python

  4. international-student-rag-assistant international-student-rag-assistant Public

    Privacy-focused local RAG application using LlamaIndex, Ollama, and local LLMs for document-grounded question answering, with retrieval and response evaluation.

    Python

  5. CPI-Wage-Disparity-Statistical-Analysis CPI-Wage-Disparity-Statistical-Analysis Public

    Statistical analysis of CPI (Consumer Price Index) and wage disparity trends, combining data exploration, visualization, and R-based econometric methods. Includes a review of prior research and a r…

    3

  6. NLP_Topic_Modeler NLP_Topic_Modeler Public

    This project is an application of unsupervised machine learning to analyze open-ended survey responses. The goal was to automate the process of extracting key themes from large-scale text data and …

    Jupyter Notebook 3