Dbt
Shinichi Yamamoto
Sr. Business Intelligence Engineer
Los Angeles,CA
Summary
Results-driven business intelligence professional recognized for delivering impactful data solutions that enhance business performance. Expertise in leveraging advanced analytics to generate actionable insights and support strategic initiatives, driving informed decision-making across organizations. Highly collaborative team player known for adaptability and commitment to achieving results in dynamic environments. Proficient in data visualization tools such as Looker, SSRS, and Tableau, with strong skills in SQL, data warehousing, and dbt development.
Overview
21
21
years of professional experience
1
1
Language
Work History
Senior Business Intelligence Developer
Auctane
03.2020 - 08.2025
- Developed, maintained, and enhanced various ETL processes with SSIS, dbt, and Airflow, improving data processing efficiency.
- Created and maintained reports with MS SQL, BigQuery, RedShift, SSRS, Looker, and Tableau, enabling faster data-driven decision making.
- Assisted users in obtaining precise information through analytical skills, enhancing user satisfaction.
- Mentored junior team members on BI concepts and best practices, fostering a culture of continuous learning within the team.
- Streamlined data analysis processes for improved efficiency and accuracy, utilizing SQL queries and stored procedures.
- Reduced query response times significantly, optimizing database indexes and fine-tuning SQL scripts.
Manager - Web Development
Nielsen/Gracenote
04.2019 - 11.2019
- Trained new employees in specific job requirements, ensuring readiness within one month, enhancing team productivity.
- Communicated best practices among internal and external personnel to align efforts and goals, improving collaboration and achieving an improvement in project delivery timelines.
Database Developer, DBA
Nielsen/Gracenote
10.2008 - 04.2019
- Developed and organized the leading entertainment industry research tool, "StudioSystem," resulting in an 80% reduction of manual processes.
- Created and implemented database designs and data models, delivering complex business requirements on time.
- Developed scripts and processes for data integration and maintenance.
- Collaborated with cross-functional teams to deliver high-quality database solutions within established project timelines.
- Established strong working relationships between different departments by effectively communicating database requirements and changes.
Database & Software Developer
Precept
08.2004 - 10.2008
- Created and modified stored procedures for processing employee benefit files, eliminating manual processes and errors with automated complex calculations, achieving a 90% performance improvement.
- Developed internal web application with customized ASP Class objects, adding features that improved user experiences.
- Advised and mentored fellow data management analysts, enhancing team efficiency and knowledge sharing.
Education
Bachelor of Science - Computer Science
Minot State University
Minot, ND05.2000
Bachelor of Arts - Foreign Language - British & American Studies
Nanzan University
Nagoya, Japan03.1995
Skills
SQL expertise
undefinedSoftware
Looker
SSIS
SSRS
DataGrip
Tableau
SSMS
Timeline
Senior Business Intelligence Developer
Auctane
03.2020 - 08.2025
Manager - Web Development
Nielsen/Gracenote
04.2019 - 11.2019
Database Developer, DBA
Nielsen/Gracenote
10.2008 - 04.2019
Database & Software Developer
Precept
08.2004 - 10.2008
Bachelor of Science - Computer Science
Minot State University
Bachelor of Arts - Foreign Language - British & American Studies
Nanzan University
Languages
Japanese
Native or Bilingual