John Bemenderfer

Enterprise Data Architect | Meat Distribution Client

November 2024 - Present

• Spearheaded the design and development of a cutting-edge Data Lakehouse on Azure Databricks, revolutionizing how the organization integrates and analyzes data from four acquired companies
• Orchestrated enterprise-wide data workflows, eliminating inefficiencies and enabling real-time decision-making with minimal manual intervention
• Engineered a highly scalable ingestion framework, future-proofing data architecture and streamlining the onboarding of new acquisitions
• Provided strategic leadership in data integration, governance, and reporting, ensuring executive buy-in and adoption of modern data-driven methodologies

AI Engineer | Internal HR Slack Chatbot

November 2024

• Designed and implemented an AI-driven HR chatbot, transforming employee interactions by delivering fast, accurate policy responses via Slack
• Introduced advanced tracking and monitoring capabilities using LangSmith, uncovering key insights into chatbot engagement and optimizing performance
• Engineered a query refinement engine, dramatically improving response accuracy and eliminating misinformation

Enterprise Data Architect | International Engineering Accreditation Organization

August - September 2024

• Led a high-impact data strategy assessment, identifying critical inefficiencies and crafting a roadmap to modernize the organization’s analytics infrastructure
• Recommended Databricks on AWS, positioning the company for scalable, high-performance data processing
• Delivered a compelling modernization roadmap, securing executive buy-in and setting the stage for a transformative implementation

Data Analyst – Power BI | Fortune 1000 Footwear Company

June - August 2024

• Led a Power BI optimization initiative, implementing 100+ enhancements to maximize analytics efficiency
• Developed an executive-level dashboard, slashing reporting turnaround times from hours to minutes

Enterprise Data Architect | Private Micro-Hospital Solutions Company

April - May 2024

• Conducted an in-depth evaluation of the company’s data architecture, identifying systemic bottlenecks and areas for optimization
• Championed the adoption of Azure Databricks, enabling FHIR-compliant healthcare data integration and unlocking new analytical capabilities
• Engaged with executive stakeholders to align technical solutions with business objectives, ensuring seamless adoption and long-term sustainability

Enterprise Data Architect | Last Mile Delivery & Logistics Company

June 2022 - September 2023

• Architected a transformational Data Lakehouse on Azure Databricks, creating a unified analytics environment and empowering decision-makers with real-time insights
• Built and scaled a high-performing data engineering team, elevating the company’s ability to manage complex data challenges
• Designed and implemented a standardized data ingestion framework, ensuring seamless data integration across multiple sources
• Established and enforced enterprise-grade data governance standards, fostering consistency, security, and compliance across all business units

Lead Data Engineer & Data Analyst | International RV Manufacturer & Supplier

November 2019 - November 2021

• Designed and deployed enterprise-scale data solutions, leveraging Azure Data Factory and Power BI to unlock new levels of business intelligence
• Led the development of HR compensation dashboards, providing executives with unprecedented visibility into pay equity and workforce trends

Enterprise Data Analyst | Largest Beauty Retailer in the U.S.

April - September 2017

• Developed a comprehensive BI and reporting strategy, aligning data initiatives with overarching business objectives
• Spearheaded the implementation of User Acceptance Testing (UAT), ensuring data accuracy and usability across all reporting layers