Looking for a job

Piyush Jain

@piyushjain6

Analytics Engineer at PCGI Systems building Power BI platforms, including a healthcare marketing intelligence platform with custom HTML/SVG visuals.

India

Message

At PCGI Systems, I architected a marketing intelligence platform for a global healthcare client, bringing together a star-schema data model, GA4 web analytics, and custom HTML/SVG visuals. I also designed row-level security and consolidated three reports into one access-controlled platform.

I build localized Power BI solutions for European markets, including multi-language semantic model translation with Tabular Editor and XMLA. I’ve extended reports with Microsoft Fabric, Power Automate, Python, and an embedded Power Apps canvas application.

At PCGI Systems, I also engineered a Streamlit application using the GPT-4 API so business users could query data in natural language. Earlier, I developed Power BI reports and dashboards at Fractal Analytics and Kockpit Analytics.

Experience

Work history, roles, and key accomplishments

Current

Analytics Engineer

Current

PCGI Systems

Aug 2024 - Present (2 years 2 months)

Lead Power BI report development and data model design within agile sprint cycles, delivering iterative dashboard enhancements across business functions and international markets. Architected a marketing intelligence platform for a global healthcare client, including star-schema data model design and custom HTML/SVG visual library.

Power BI DAX Power Query Microsoft Fabric Row level security HTML SVG GA4 SQL Power Automate PowerApps Python Agile

AI Engineer – LLM Application Developer

PCGI Systems

Jan 2024 - Aug 2024 (7 months)

Engineered a production-grade LLM application using Streamlit and the GPT-4 API, enabling non-technical users to query business data through natural language. Built data ingestion pipelines supporting Excel and CSV formats for real-time AI-powered analysis.

Streamlit GPT 4 OpenAI API Python Data Ingestion Natural Language Processing

Power BI SME

PCGI Systems

Jan 2021 - Dec 2023 (2 years 11 months)

Architected enterprise-wide Power BI solutions with scalable data models and optimized report performance, serving as subject matter expert across client engagements. Led cross-functional teams in implementing Power BI best practices, governance frameworks, and deployment strategies.

Power BI DAX Power Query Row level security SQL Server Azure Data Modeling Governance

Power BI Developer

Fractal Analytics

Jan 2019 - Dec 2020 (1 year 11 months)

Delivered Power BI reports and dashboards for analytics-driven client projects, contributing to data modeling and DAX development within agile delivery teams.

Power BI DAX Data Modeling Agile