Skip to content
View ChristianLG2's full-sized avatar
💼
Open to Work!
💼
Open to Work!

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


Christian Lira G. Analytics Engineer

I build data platforms and AI systems from pipeline to delivery.

Currently founding Orpheus Analytics, an end-to-end analytics engineering platform that transforms public economic datasets into standardized, API-accessible data products. Designing ELT ingestion pipelines, OLAP-oriented data models, and a FastAPI + PostgreSQL + Docker delivery layer for enterprise analytics consumers.

Previously: Tesla Finance Operations (vendor data pipeline redesign, KPI automation for 1,000+ entities) · BYU-Idaho Analytics Engineering Lead (centralized OLTP-to-OLAP architecture, Power BI semantic models from scratch) · BYU-Idaho Research Analyst (full Qualtrics-to-Power BI pipeline, LDA topic modeling, Python validation tool adopted as standard across two institutions).

Trilingual: English · Español (native) · 普通话 (Intermidiate - HSK4)


Experience

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


What I'm building right now

Project Stack Status
Orpheus Analytics Platform Python · FastAPI · PostgreSQL · Docker · pgvector Active — ELT + ML + RAG layers
SQL Analytics Portfolio T-SQL · dbt · Snowflake · PySpark · Quarto 7 projects — in progress
Economic Intelligence RAG API LangChain · pgvector · FastAPI · Docker In development
DP-600 Fabric Analytics Engineer Microsoft Fabric · Power BI · DAX In progress
IBM Data Engineering Professional Data Engineering fundamentals In progress

Featured projects

Orpheus Analytics Platform: End-to-end data platform: ELT pipelines → OLAP models → FastAPI delivery (in active development)

SQL Analytics Portfolio: 7-project T-SQL portfolio covering supplier analytics, cohort retention, query optimization, star schema design, dbt, Snowflake, and PySpark (in progress)

HackUSU 2026 — Databricks AI Pipeline: Supply chain analytics pipeline built in 24 hours — Databricks, Python, SQL, Streamlit, and Databricks AI/BI Genie conversational interface for natural language data querying

CPI & Wage Disparity Analysis: Econometric analysis across all U.S. states (2015–2023): regression, ANOVA, ARIMA in R · View analysis

NLP Topic Modeler: Unsupervised LDA topic modeling on large-scale survey response data (Python, Jupyter)

GradeBase: Relational database system for academic performance management (Python, SQLite)


Technical focus

Analytics Engineering ELT/ETL pipelines · Microsoft Fabric (Lakehouse, Pipelines, Data Warehouse) · Power BI (DAX, semantic models) · SSIS · Power Automate · OLAP/OLTP architecture · data flow mapping · data validation frameworks

Data Engineering
Python (FastAPI, pandas, Docker) · SQL (T-SQL, PostgreSQL, MySQL) · Apache Spark · Databricks · API integration · schema design · medallion architecture

Machine Learning Decision Trees · Gradient Boosted Trees · Neural Networks · CNNs · RNNs · K-Means clustering · LDA topic modeling · ARIMA · scikit-learn · RAG pipelines · LangChain — Supervised & Unsupervised

Statistics & Analysis
R (tidyverse, ggplot2, R Markdown) · statistical inference · ARIMA / time series · econometrics · NLP (LDA topic modeling)


GitHub stats

LinkedIn Portfolio Email Blog

Pinned Loading

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

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

  3. GradeBase GradeBase Public

    This project builds a relational database system for managing and visualizing student academic performance. The system tracks students, courses, attendance, grades, and assignments using SQLite and…

    Python 1

  4. Elchamos64/finalVersion Elchamos64/finalVersion Public

    Python 1

  5. Student-Apartments-Statistical-Analysis Student-Apartments-Statistical-Analysis Public

    This project provides a detailed statistical analysis and visualization of apartment rental data for students in Rexburg, Idaho. The data includes various characteristics of 122 apartments, with th…

    R 2

  6. Global-Air-Quality-ArcGIS Global-Air-Quality-ArcGIS Public

    This project provides an interactive web-based map that visualizes air quality measurements worldwide using data from the OpenAQ API. It supports pollutant filtering, intuitive color scaling, and d…

    JavaScript 1