Senior Business Intelligence Analyst

Seoktae Lee

Senior BI Analyst

Austin, TX, USA

E: ********@*******.***

L: @seoktae-john-lee

SUMMARY

Senior Business Intelligence Analyst with 7+ years of experience driving OKR goal establishment, advanced analytics, and report development. Expertise in data manipulation with Python (Pandas, Numpy), SQL, and creating visualizations with Tableau and Jupyter Notebook.

EXPERIENCE

Indeed.com, Austin TX - Senior Business Intelligence Analyst JANUARY 2023 - PRESENT

● Managed establishment of 5 top level Fiscal Year OKRs (3 attribution-related, 1 influence-related, and 1 traffic-related) for Marketing across 3 components

(Experience / Growth / Brand) serving as direct liaison to Marketing leadership

● Developed end-to-end analytics infrastructure for SMB Growth using dbt models, Snowflake SQL, and Tableau Desktop to deliver self-service monitoring solution tracking campaign performance across 7+ channels in 10+ countries

● Designed dashboards and ETL workflows in Tableau Desktop and Prep to understand job seekers by size, intent, activity on the site, and the critical mass of job seekers by occupation, by market for Sales / CS / Talent Insights teams to present to external clients

● Implemented and compared fbprophet and ARIMA time-series forecasting models to establish monthly projections for a traffic-related OKR reporting directly to the CMO and VP of Marketing

● Established 70% of data source access via AWS Athena and Snowflake depending on availability while moving roughly 30% of access to Jupyter Notebooks from direct queries and Google Spreadsheets

● Mentored 4 Business Intelligence Analysts (including 1 intern) in exercising stakeholder management skills resulting in reducing the time to complete a request by 30%

Indeed.com, Austin TX - Business Intelligence Analyst MAY 2018 - JANUARY 2023 (4 yr 9 mo)

● Delivered comprehensive Tableau dashboards analyzing Marketing campaign performance and connecting data extracts in SQL or Python using Jupyter Notebooks

● Mentored team members and interns on project management and stakeholder management techniques

Indeed.com, Austin TX - Technical Analyst (Aggregation) JUNE 2017 - MAY 2018 (1 yr)

● Collaborated with Developers to enhance functionality of search engine by modifying Procedural Python scripts and SQL queries Indeed.com, Austin TX - Aggregation Data Maintenance NOVEMBER 2015 - JUNE 2017 (1 yr 8 mo)

● Identified and aggregated information using CSS selectors and Regular Expressions (Regex)

● Enhanced usage of XHR in replacement of JavaScript to minimize workload of search engine

EDUCATION

Texas A&M University, (College Station, TX)

MS in Electrical, Electronics and communications

The Ohio State University, (Columbus, OH)

BS in Electrical, Electronics and communications

CERTIFICATIONS

Artificial Intelligence & Machine Learning Bootcamp - Texas State University, (July 2024)

Contact this candidate