Nitin Jena

Data Analyst with 4+ years of experience in Python, SQL, and Power BI across finance, marketing, and operations. Skilled in dashboards, forecasting, A/B testing, and delivering data-driven business insights.

Data Analyst - Finance at Ernst & Young (2023-11 – Present)

• Translated business reporting requirements into scalable Power BI dashboards, enabling real-time visibility into revenue, pipeline health, and engagement metrics across 50+ client accounts.
• Analyzed large and sensitive datasets using advanced SQL (T-SQL/PL-SQL) to generate actionable insights and identify business trends.
• Delivered ad hoc and standardized reports to stakeholders across cross-functional teams, supporting data-driven decision-making.
• Built and optimized end-to-end ETL pipelines using Python and Power Query, improving reporting efficiency by ~50%
• Performed variance analysis and trend analysis to support financial forecasting, planning, and strategic initiatives.
• Defined and standardized KPIs and reporting frameworks, improving data governance, consistency, and alignment across teams.
• Conducted data validation and quality checks, auditing report outputs to ensure accuracy and reliability.

Data Analyst – Marketing & Sales at HK Diamonds (2023-06 – 2023-10)

• Conducted statistical analysis and A/B testing to evaluate campaign performance and optimize conversion rates.
• Built customer segmentation models (K-Means clustering) to enhance targeting and personalization strategies.
• Analyzed multi-channel datasets to generate insights for improving ROI and marketing effectiveness.
• Developed interactive dashboards and data visualizations (Power BI) to track sales KPIs, funnel metrics, and product performance.
• Delivered insight-driven recommendations to stakeholders, improving campaign efficiency and business outcomes.

Data Analyst – Operations at Gemological Institute of America (GIA) (2021-01 – 2023-03)

• Designed and delivered operational dashboards to monitor production efficiency, throughput, and revenue performance.
• Performed root cause analysis to identify process inefficiencies and recommend data-backed solutions.
• Built SQL-based ETL workflows and automated reporting pipelines for daily data processing.
• Developed forecasting and planning models in Excel to support inventory management and reconciliation.
• Implemented data quality audits and validation checks, ensuring the integrity and consistency of reporting datasets.

Bachelor of Science in IT – University of Mumbai

Diploma in Computer Engineering – MSBTE