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
- Engineered, maintained, and enhanced various ETL processes using SSIS, dbt, and Airflow, significantly improving data
processing efficiency. - Facilitated expedited data-driven decision-making by developing and sustaining comprehensive reports via MS SQL, BigQuery,
RedShift, SSRS, Looker, and Tableau. - Improved user satisfaction by guiding users to obtain precise information, leveraging advanced analytical skills.
- Nurtured a culture of continuous learning and professional growth within the team by mentoring junior team members on BI
concepts and best practices. - Enhanced data analysis process efficiency and accuracy through the effective utilization of SQL queries and stored procedures.
- Reduced query response times considerably by optimizing database indexes and fine-tuning SQL scripts.
Manager - Web Development
Nielsen/Gracenote
04.2019 - 11.2019
- Successfully onboarded and trained new hires on job-specific requirements, achieving full readiness within one month and
improving team productivity. - Streamlined communication of best practices between internal and external stakeholders to align efforts, foster collaboration, and
accelerate project timelines.
Database Developer, DBA
Nielsen/Gracenote
10.2008 - 04.2019
- Engineered and built "StudioSystem," a top-tier entertainment research tool, which reduced manual processes by 80%.
- Developed and implemented cutting-edge database designs and data models, consistently delivering complex business needs on
time under the agile method. - Created streamlined scripts and processes for fluid data integration and upkeep.
- Worked with cross-departmental teams to provide robust database solutions adhering to project timelines.
- Built strong relationships across departments by effectively communicating database needs and alterations.
Database & Software Developer
Precept
08.2004 - 10.2008
- Engineered and modified stored procedures for employee benefit file processing, automating complex calculations to eliminate
manual processes and errors, achieving a 90% performance improvement. - Developed an internal web application utilizing customized ASP Class objects, incorporating features that significantly improved
user experience. - Provided guidance and mentorship to data management analysts, leading to improved team performance 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
Software
Looker
SSIS
SSRS
DataGrip
Tableau
SSMS
Languages
Japanese
Native or Bilingual
Accomplishments
- Collaborated with team of 10 in the redesign of the industry leading research application, "StudiosSystem".
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