Austin B. Lenth
Summary
Seasoned BI Developer with proven track record of high productivity and efficient task completion. Skilled in data warehousing, ETL processes, and business intelligence software tools. Excel in problem solving, critical thinking, and communication, ensuring seamless integration of complex data into actionable insights for decision-making.
Overview
5
5
years of professional experience
Work History
BI Developer
Tri Counties Bank
05.2024 - 08.2024
- Created a dashboard that highlighted key performance metrics for the CFO.
- Used SQL to created complex queries to facilitate timely dashboard refreshes.
- Collaborated with stakeholders to gather reporting requirements and feedback.
- Designed interactive dashboards for user-friendly data visualization.
- Created reports, scorecards, and KPIs in Microsoft PowerBI to measure business performance metrics.
Data Analyst
Educational Results Partnership
07.2021 - 12.2023
- Developed business KPI from Community Safety, Education, Health, and Socioeconomic data sets. As part of this project, I developed a Python ETL tool using population data from the US Census API
- Developed KPI for the Community College Chancellors office website, calpassplus.org
- Built an automated testing suite for the underlying data displayed on the site and reconciled the provided artifact from the Chancellor's office
- Automated procedures to better align with artifacts given by stakeholder and auditing of procedures
- Created and Executed ER Modeling
- Collaborated with stakeholders to develop data-driven reports for program evaluation.
- Analyzed educational data to identify trends and inform decision-making processes.
- Maintained comprehensive documentation of data sources and methodologies used.
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Translated raw data into meaningful information using statistical techniques.
- Provided data-driven solutions to support decision making.
- Leveraged SQL queries to extract, transform and load data into databases.
- Generated reports and obtained data to develop analytics on key performance and operational metrics.
- Worked with internal teams to understand business needs and changing strategies.
- Collaborated with cross-functional teams to prioritize business and information needs.
Data Analyst
First Tech Federal Credit Union
06.2019 - 07.2021
- Created several Tableau dashboards through Alteryx for the Digital Fraud team, eSupport team and overall CXC
- Tracked CXC agent Occurrences by creating a database and automated email daily as well as monthly and created a tableau dashboard with KPI for management
- Headed an automated product change and email alert for Deposit Products and compiled Member Overview dashboard in Tableau (Member Growth and Sentiment)
- Audited reporting and forecasting needs for the Contact Center
- Headed a project that audited transactions for fraudulent cases and created a dashboard for upper management
- Collaborated with stakeholders to develop data-driven reports for program evaluation.
- Assisted in creating visualizations to present findings to diverse audiences.
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Translated raw data into meaningful information using statistical techniques.
- Leveraged SQL queries to extract, transform and load data into databases.
- Generated reports and obtained data to develop analytics on key performance and operational metrics.
- Built visualizations that enabled users to quickly interpret results from complex analyses.
- Developed dashboards with Tableau to monitor key performance indicators.
- Created data visualizations and reports for management, showcasing findings and recommendations.
- Developed and maintained databases, data systems, reorganizing data in a readable format.
Education
Master's Degree - Data Science
University of Denver
Denver, Colorado12.2024
Bachelor's Degree - Applied Mathematics
California State University Sacramento
Sacramento, California12.2018
Skills
- R (RStudio)
- Data visualization
- SQL querying
- Python programming
- Dashboard development
- Project management
- Cross-functional collaboration
- Trend analysis
- Business intelligence tools
- Report design
- Performance tuning
- Data warehousing
- Predictive analytics
- SQL programming
- Dashboard creation
- ETL development
- Data integration
- Relationship building
- Team collaboration
- Validate code
- Programming languages
- Multitasking capacity
- Self motivation
- GitHub collaboration
- JIRA
- Analytical thinking
- Teamwork and collaboration
- Multitasking
- Testing and debugging
- Problem-solving
- Python
- Tableau
- SSMS
- Snowflake
- SQL Data Modeling
- Alteryx
- EDW
- MongoDB
- LaTeX
- XML
- Oracle
- MS-Office
- Oracle SQL Developer
- Agile/Scrum
- Windows XP
- Windows 10
- Jira
- Git/GitHub/bitbucket
- Confluence
- Azure Data Studio
- AWS
- Data Brew
- Auditing
- ER Modeling
- Machine Learning
Timeline
BI Developer
Tri Counties Bank
05.2024 - 08.2024
Data Analyst
Educational Results Partnership
07.2021 - 12.2023
Data Analyst
First Tech Federal Credit Union
06.2019 - 07.2021
Master's Degree - Data Science
University of Denver
Bachelor's Degree - Applied Mathematics
California State University Sacramento