I am Lisa K. Bennett, a Senior Data Analyst with 20+ years of experience delivering data-driven insights across ETL, cleansing, analysis, modeling, visualization, migration, and integration. I excel in SQL, Power BI, Excel VBA, Python, and R to extract meaningful insights, solve complex problems, and craft compelling data stories. I thrive in cross-functional collaboration to drive continuous improvement and measurable outcomes. From healthcare and insurance data to enterprise maintenance analytics and ERP data migrations, I design dashboards, automate processes, and build scalable data pipelines that improve regulatory compliance and operational efficiency. I enjoy translating technical findings into clear recommendations and mentoring teammates to elevate data capabilities.

Lisa K. Bennett

I am Lisa K. Bennett, a Senior Data Analyst with 20+ years of experience delivering data-driven insights across ETL, cleansing, analysis, modeling, visualization, migration, and integration. I excel in SQL, Power BI, Excel VBA, Python, and R to extract meaningful insights, solve complex problems, and craft compelling data stories. I thrive in cross-functional collaboration to drive continuous improvement and measurable outcomes. From healthcare and insurance data to enterprise maintenance analytics and ERP data migrations, I design dashboards, automate processes, and build scalable data pipelines that improve regulatory compliance and operational efficiency. I enjoy translating technical findings into clear recommendations and mentoring teammates to elevate data capabilities.

Available to hire

I am Lisa K. Bennett, a Senior Data Analyst with 20+ years of experience delivering data-driven insights across ETL, cleansing, analysis, modeling, visualization, migration, and integration. I excel in SQL, Power BI, Excel VBA, Python, and R to extract meaningful insights, solve complex problems, and craft compelling data stories. I thrive in cross-functional collaboration to drive continuous improvement and measurable outcomes.

From healthcare and insurance data to enterprise maintenance analytics and ERP data migrations, I design dashboards, automate processes, and build scalable data pipelines that improve regulatory compliance and operational efficiency. I enjoy translating technical findings into clear recommendations and mentoring teammates to elevate data capabilities.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Work Experience

Data Analyst at TriCom Technical Services (Client: Quest Analytics) – Remote
December 1, 2024 - December 1, 2024
Conducted in-depth analysis of large healthcare and insurance practitioner datasets to support Medicare No Surprises Act compliance, ensuring accurate reporting and regulatory adherence. Developed SQL and Excel tools to support team analytics, influenced problem-solving based on business rules and relational keys. Performed deep-dive analyses to identify software improvement opportunities and provided actionable recommendations. Investigated data inquiries independently within an Agile environment to minimize scrum disruptions. Used data mining to uncover thousands of failed outreach attempts caused by missing fax tone detection; traced to mismapped phone fields and realigned to restore data accuracy. Created Databricks notebooks to combine data from Data Lake for cross-functional reporting. Supported scrum teams with ad hoc data needs and validated bug fixes with SQL queries.
Sr. Maintenance Analyst at CRST International
May 1, 2023 - May 1, 2023
Designed, developed, and maintained Power BI dashboards and datasets across five departments and eight business units. Investigated mileage data anomalies linked to a vendor telematics API, correcting odometer readings. Streamlined end-of-month close by optimizing general ledger data; recovered $40K in vendor overcharges. Automated recurring processes and report distribution; maintained 99% data integrity in SQL Server maintenance software with audit tools. Documented schemas for proprietary software to improve query accuracy. Built an MS Access tool integrating XML and relational data to track 20,000+ vehicle inspections for DOT compliance. Mentored new analysts and created VBA Excel tools for financial reporting. Served as database SME for data migration during ERP transition.
Sales Engineer at Kurtz Communications
January 1, 2013 - January 1, 2013
Prepared customer quotes and presentations; automated quoting processes by developing Excel VBA tools.
Planning Engineer II at McLeodUSA
July 1, 2011 - July 1, 2011
Project manager for customer and network equipment installations; designed MS Access database tools to track new build projects and forecast equipment usage for DSL, MPLS, and VOIP; developed models and custom reporting tools to support planning and deployment; forecasted network needs to support budget planning and sales initiatives.

Education

Master of Science (M.S.) in Business Analytics at The University of Iowa
January 11, 2030 - November 4, 2025
MBA in Business Administration at The University of Iowa
January 11, 2030 - November 4, 2025
Bachelor of Science (B.S.) in Mechanical Engineering at The University of Iowa
January 11, 2030 - November 4, 2025

Qualifications

Add your qualifications or awards here.

Industry Experience

Healthcare, Professional Services, Transportation & Logistics, Software & Internet