Jump - Advisor AI

Staff Data Engineer

Orem Data

***Currently only taking advisory clients***

Modernizing data processes and tools to help startups drive revenue. I also do developer advocacy including technical writing as part of my independent work. 

● Managing full business operations, from client acquisition to solution development.
● Designing data strategies tailored to client needs, selecting the right tools, practices, and constructing a comprehensive data roadmap.
● Engineered an open-source-focused serverless stack with DuckDB, SQLMesh (Python models with Ibis), and S3 for a client.
● Developed data transformations in Python Polars while mentoring and empowering a data science team.
● Revamped and optimized a dbt project by automating the generation of source models from YAML and SQL files.
● Built an automated data system that parses emails, extracts attachments, and saves data to Google Drive.
● Producing technical content, blog articles, LinkedIn posts, and book(s) to educate, inspire, and support fellow data professionals.

Independent Consultant

Estuary

Content Partner

Humana

● Leading the BI user group across the department, delivering live training and consultations on BI implementations.
● Spearheading a CI/CD initiative using Azure DevOps for BI artifacts, enhancing the analytics lifecycle management.
● Managing stakeholders across teams and departments, ensuring seamless communication and collaboration on analytics projects.
● Developing end-to-end BI solutions, from gathering business requirements to building data models, metrics and visualizations.
● Integrating Azure Synapse Analytics with Power Platform (Power BI, Power Automate, Power Apps) to streamline BI solutions.

Senior Business Intelligence Engineer

Packt

I wrote "Polars Cookbook":
- Amazon: https://www.amazon.com/Polars-Cookbook-practical-transform-manipulate/dp/1805121154
- Packt:https://www.packtpub.com/en-us/product/polars-cookbook-9781805121152

Author

MasterControl

Business Intelligence Engineer

Data Clymer

● Implemented ELT pipelines and dashboards using Fivetran, BigQuery, Snowflake, Looker, Sigma, and Power BI.
● Developed a Fivetran custom connector in Python/Cloud Functions to unlock new data sources for analysis.
● Automated data pipelines to streamline investment decision-making, reducing manual effort by ~5 hours per week.
● Built an advanced Power BI data model supporting dynamic unit of measure conversions and analytics across multiple fact tables.
● Worked within an activity schema framework to standardize data modeling processes.
● Led business discussions to ensure technical solutions aligned with strategic objectives.

Analytics Engineer

Amplify Consulting Partners Inc

Working on the Microsoft project

● Led BI data model optimization efforts, reducing the dataset size and total refresh time by 50%~.
● Reengineered a dashboard, cutting the finance team’s manual workload by 40 hours per week, saving an estimated $100K annually
● Facilitated communications between business and the reporting team to translate the requirements into BI solutions.
● Acted as a bridge between business and reporting teams, ensuring effective translation of requirements into BI solution.

Analytics Consultant

Health Catalyst

Worked with/for Stanford Healthcare

● Developed Power BI solutions with advanced SQL, DAX, and Power Query to enhance visualization and analytics.
● Led a security initiative implementing a row/object level security along with metadata deployment in Power BI.
● Advised on BI architecture improvements to optimize data processing and modeling frameworks.
● Served as an internal BI expert, providing strategic guidance and best practices within the professional services department.

Analytics Engineer Intern

DigiCert, Inc.

●	Developed a Python package for upsert operation and improved the runtime of an ETL job from 3hrs to 10s.
●	Helped implement and maintain ETL jobs for our data warehouse with dimensional modeling.
●	Created a Python script to scrape over 1000 tables through web pages on Netcraft.

Data Engineer Intern

Analytics Engineer | Data Consultant

I'm currently working at Jump full-time. I still do independent consulting work in a limited capacity though. 

Reach out to me:
- yuki@oremdata.com
- https://oremdata.com
- cal.com/yuki-kakegawa

Blogs:
- https://thedatatoolbox.substack.com/
- https://stuffbyyuki.com/

How does Estuary help with streaming data from Kafka into MotherDuck? 🤔

Estuary (my content partner) will be hosting a webinar next week to show you how it can help reduce cost and complexity in working with Kafka. 

I'm no Kafka expert but this one definitely sounds interesting to learn about. 

If you're an existing Kafka user, this webinar is a must-attend. 

Register here: https://lnkd.in/g7hpHDwr

#data #dataengineering

Yuki Kakegawa

Data @ Jump | Independent Data Consultant

Taplio

Yuki Kakegawa's Linkedin Analytics

Yuki Kakegawa

Performance ScoreYuki Kakegawa's LinkedIn Performance

What is Yuki talking about?

Yuki Kakegawa's Best Posts (last 30 days)

Ready to grow your LinkedIn presence?

Taplio

.css-6ytdur{background-image:linear-gradient(284deg, rgba(39, 43, 72, 1) 0%, rgba(33, 47, 183, 1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Yuki Kakegawa's Linkedin Analytics

Yuki Kakegawa

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Yuki Kakegawa's LinkedIn Performance

What is Yuki talking about?

Yuki Kakegawa's Best Posts .css-1emoo84{font-size:var(--chakra-fontSizes-md);font-weight:400;color:var(--chakra-colors-gray-600);}(last 30 days)

Ready to grow your LinkedIn presence?

Yuki Kakegawa's Linkedin Analytics

Performance ScoreYuki Kakegawa's LinkedIn Performance

Yuki Kakegawa's Best Posts (last 30 days)