Juan Pablo Luna

I am an Industrial Engineer obsessed with Data, Automation, and Efficiency. While my background is rooted in Total Rewards and Talent Management, my true passion lies in the technical architecture that powers business decisions. I don’t just analyze the "people side" of the business; I build the data pipelines and automated workflows that make Finance and HR teams scalable, profitable, and intelligent. I thrive where Data Engineering meets Business Strategy. Whether it's automating a complex payroll reconciliation or training an LLM to analyze survey feedback, I am constantly looking for ways to transform raw data into a competitive advantage. 🛠 My Technical Edge (The "How"): -I go beyond standard reporting. I leverage Generative AI and Low-Code Automation to solve problems that Excel can't handle. -Advanced Analytics: SQL (Complex Querying), Power BI (DAX, Data Modeling), and Tableau. -Automation & AI: Building complex workflows with n8n to integrate HRIS (BambooHR) with Financial systems. Expert in Prompt Engineering (Claude, Gemini, ChatGPT) and prototyping with Lovable.dev. -Benchmarking: Deep expertise in managing salary surveys and market pricing using Mercer and other global data sources. 💼 Business Impact & Domain Expertise (The "What"): -Currently, as a Compensation Analyst, I partner with Finance and Leadership to ensure fiscal sustainability across distributed teams. -Financial & Payroll Strategy: I manage multi-million dollar labor budgets, ensuring precise alignment between Payroll, Finance, and HRIS. -Total Rewards Architecture: I design competitive salary structures using Mercer methodologies to ensure internal equity and market competitiveness. -Process Engineering: I successfully architected a Talent Management department from scratch, achieving the Great Place to Work certification and increasing retention by 20% through data-backed benefit strategies. -Recruitment Ops: Previously achieved an 85% fill rate in 30 days for high-volume roles by using data to optimize the funnel. 🚀 Why Me? -Because I speak the languages of Business (Profitability, ROI, Retention) and Tech (SQL, API Integrations, AI Agents). I am looking to continue solving complex data challenges in high-growth Tech environments. Core Skills: Data Analysis • SQL • Power BI • n8n • Python (Basics) • Mercer • Payroll Analysis • Financial Modeling • BambooHR • Prompt Engineering • Industrial Engineering.