Jahnavi G

About Jahnavi G

As a Data Analyst, I specialize in data analytics, ETL pipelines, and cloud technologies…

Experience

1. Data Analyst

   Clairvoyant

   Feb 2024 — Present · US

   Built low-latency ETL pipelines and automated data collection with 100+ Selenium and PySpark scripts, implementing CI/CD for scripts to add weekly releases, boosting Flexera One Platform data efficiency by 10%. • Collected, transformed, and loaded data using SQL, Python, and AWS into Snowflake data warehouse, enabling rapid analytics and deriving data-driven insights for customer segmentation, LTV, ROI, and trend analysis. • Led design and deployment of scalable Power BI reports and dashboards using advanced DAX and Power Query, cutting manual reporting by 10 hours weekly and speeding report load times by 30%. • Designed and optimized data processing workflows by leveraging Hadoop HDFS for scalable storage and MapReduce for efficient large-scale data analysis, improving data insights for business decision-making. • Integrated REST APIs with complex OAuth 2.0 for real-time data, reducing manual consolidation by 40%, and automated testing plus deployment pipelines, cutting data refresh failures by 25%. • Developed dashboards, KPIs, and self-service BI with Snowflake, Tableau, and Power BI, collaborating cross-functionally to enhance data access, decision speed, and business insights. • Led project to host a product data lake on Flexera One, improving data access and insights by documenting requirements, creating demos and reports, and delivering regular stakeholder updates. • Managed Power BI service and capacity, optimized workspace performance, ensured security and compliance, and enhanced BI infrastructure using new features and AI-driven analytics. • Created clear documentation and training materials to boost BI tool adoption focusing on SQL and Python and led mentoring to enhance data literacy and BI skills using Agile and Scrum methodologies organization-wide.