Amir Khan

Lead BI Engineer

Jul 2024 - Present • 1 yr 10 mos

Enterprise Architecture & Migration: Managed the entire BI ecosystem from data modeling and cleaning to end-user dashboard building. Spearheaded the end-to-end migration of legacy enterprise data from Oracle to Google BigQuery, implementing automated data pipelines and scheduled Power BI refreshes to replace static data with a centralized, real-time analytics engine. BI Team Leadership & Scale: Led a team of BI professionals to deliver a portfolio of 15+ high-impact dashboards (spanning Procurement, Flight & Base Operations, Finance, Medical, and HR). Eliminated 100% of manual, spreadsheet-based reporting across these departments, providing leadership with unprecedented, real-time access to historical data. Financial Analytics Transformation: Created a comprehensive Finance dashboard for the CFO, consolidating P&L and other critical metrics. Transformed a completely manual reporting process into an automated, self-serve system, allowing leadership to monitor expenses and budgets in real-time and significantly enhancing decision-making efficiency. Medical & HR Operations: Developed a Medical dashboard that completely eliminated the need to manually collect insights from disconnected sheets, providing a 360° view of clinical KPIs. Simultaneously built an automated HR dashboard tracking headcount, FTEs, and demographic distributions to enable timely, informed people analytics. Core Technologies: Power BI, Python, Google BigQuery, SQL, Oracle

Senior Business Intelligence Engineer

May 2022 - Dec 2024 • 2 yrs 7 mos

Cloud Data Warehousing & Architecture: Designed and deployed a dynamic Snowflake data warehouse from scratch to support AlphaGeo, an AI-powered geospatial predictive analytics product. Engineered automated data pipelines to seamlessly ingest and update climate data from AWS S3 at scheduled monthly and quarterly intervals. Time & Resource Optimization: Architected a real-time Power BI dashboard providing a 360° view of employee time logs across departments and teams. This automated previously error-prone, manual spreadsheet processes, effectively eliminating 100% of manual reporting effort for management and saving 95% of time. Financial & Business Intelligence: Created a consolidated Finance dashboard in Power BI that tracked key business metrics in real-time, empowering leadership to actively monitor budgets and expenses to enhance decision-making efficiency. Workforce Analytics: Developed an automated HR dashboard tracking critical metrics including headcount, FTEs, terminations, and demographic distributions, enabling the HR team to make timely, data-backed decisions on workforce management. Client-Facing Analytics: Collaborated with data scientists and researchers to build client-facing reports, translating complex data into actionable insights to answer critical business questions and drive strategic decisions. Core Technologies: Power BI, Snowflake, Python, SQL, Looker, AWS S3.

Data Analyst - Product Growth & Performance

Aug 2021 - May 2022 • 9 mos

Hardware Diagnostics & Error Reduction: Partnered within a 22-person agile cross-functional team to build performance, reliability, and health dashboards for Hubble, an AI-powered safety dashcam used by fleets across the USA and Canada. This analytics infrastructure proactively alerted the hardware team to customer-reported issues, ultimately reducing the product error rate by 25%. Product Launch & Telemetry (Vehicle Gateway): Facilitated critical data point collection for the launch of the Vehicle Gateway (VG) product. Designed and deployed an end-to-end monitoring solution that kept product managers continuously updated on VG metrics, enabling proactive issue resolution rather than reactive troubleshooting. Deep-Dive Usage Analytics: Conducted comprehensive deep-dive analyses of product usage across both hardware and software. Translated complex telemetry data into actionable insights, ensuring the product management team had a constant pulse on product performance, reliability, and overall health. Core Technologies: Python, Redash, MySQL, Snowflake, Jupyter Notebook.