Sam Saha
Data Analyst · Business Intelligence
About
Turning Data Into Decisions
I'm a Data Analyst with hands-on experience at Renuity Operations, National Grid, and Columbia Threadneedle Investments — building the dashboards, pipelines, and reports that operational and executive teams rely on daily.
My work sits at the intersection of SQL engineering, Power BI development, and business process optimization. Whether I'm untangling 6,000+ payment sessions to surface funnel drop-offs or automating a reporting cycle that used to take two days, I focus on delivering clarity at scale.
Based in Burlington, MA. BS in Information Technology with a Business Intelligence concentration from UMass Boston.
Data Analytics
Transforming raw data into actionable business insights using SQL, Power BI, and Python.
ETL & Automation
Building automated pipelines with Snowflake and Power Query, cutting reporting cycles by 24+ hours weekly.
Business Intelligence
Designing dashboards and KPI scorecards that drive data-driven decisions at the executive level.
Expertise
Skills & Technologies
Programming
Data Visualization
Data Platforms
Analytics & Excel
Methodologies
Enterprise Platforms
Career
Work Experience
Renuity Operations LLC
CurrentData Analyst I
Production & Scheduling Team
June 2025 – Present
Woburn, MA
- Managed and tracked completion documentation for 50+ weekly installation jobs within Lead Perfection (LP), ensuring work orders, installer assignments, and job records were accurate at every stage.
- Produced SQL Server queries and stored procedures for data error review, removing 33% of flawed elements from the data load.
- Automated weekly open order reports by creating Snowflake queries connected to Excel via Power Query — reducing the reporting cycle by 24+ hours per week.
- Applied VLOOKUP and INDEX-MATCH formulas to reconcile installer assignments and scheduling data pulled from Lead Perfection across multiple spreadsheets.
- Designed a monthly Power BI report tracking scheduler call volumes and installer production rates to surface performance trends and operational gaps for field managers.
National Grid
Business Intelligence Intern
Performance Lab Team
Oct 2024 – April 2025
Waltham, MA
- Analyzed 6,000+ payment sessions with SQL and advanced Excel to map the Pay-by-Bank customer journey, isolating funnel drop-offs that drove targeted product fixes now in A/B testing.
- Built Power BI dashboards with decomposition trees, KPI cards, and trend lines giving leadership real-time visibility into the conversion funnel.
- Designed Power BI scorecards covering 60+ suppliers across 16 KPIs, integrating Snowflake data with complex DAX measures so execution-level staff could make data-driven decisions.
- Analyzed Advanced Metering Infrastructure (AMI) data and backend utility systems to surface anomalies, producing weekly performance reports on key metrics, error rates, and user behavior trends.
Columbia Threadneedle Investments
Global Data Strategy Intern
Data Team
May 2024 – Aug 2024
Boston, MA
- Developed a dynamic Excel-based 2024 Work Forecast allocation tool with pivot tables and conditional formatting, improving scheduling accuracy by 25% and optimizing resource allocation across 3 business units.
- Maintained the Authoritative Source Master spreadsheet of 1,200+ entries, ensuring 100% consistency across internal data platforms.
- Conducted a Training Needs Analysis (TNA) for the Onshore Level 2 Team in Gurugram, India, identifying 7 key skill gaps and recommending targeted learning programs.
- Built an interactive Power BI dashboard with Python-based data modeling integrating 4 sources to track KPIs and automate trend analysis, reducing manual reporting time by 30%.
Background
Education
University of Massachusetts Boston
Bachelor of Science in Information Technology
Business Intelligence Concentration
Contact
Get In Touch
Open to full-time data analyst roles, BI opportunities, and consulting projects. Let's connect.
© 2025 Sam Saha · Burlington, MA
Built with Next.js & Tailwind CSS