Hi, I'm Jake.
A data engineer and analyst, with a background in biotechnology, focused on turning complex data into actionable insights. Welcome to my portfolio page! Feel free to explore my work and get in touch if you'd like to work together.
- PythonAnalytics & Automation
- SQLEngineering & Reporting
- Microsoft FabricEfficient Data Pipelines
- DashboardsPower BI & Tableau
Featured Projects
A selection of some of my personal projects in data analysis, engineering, and visualization.
Walmart Sales Projections
Simple, robust regression modeling of weekly sales with regularization to avoid overfitting and strong predictive accuracy.
IMDb Movies: Vote‑weighted Ratings
Interactive dashboard built in Tableau Public using IMDb data to explore the popularity of movies through time.
About Me
I'm a data-driven professional with a background in data engineering, analytics, and biotechnology. I build reliable data products and pipelines that enable decision-making, automate workflows, and improve operational efficiency.
Experience
Data Analyst II
- Engineered scalable data solutions, including redesigning a core ingestion process that reduced runtime by 99%.
- Automated high-volume workflows using Python, increasing data accessibility, reliability, and throughput by 125%.
- Architected and maintained distributed data pipelines leveraging Microsoft Fabric’s DirectLake access mode for scalable data processing and rapid visualization.
- Designed and executed A/B tests to evaluate large language model (LLM) deployment strategies, optimizing automation of high-volume workflows.
Data Analyst I
- Developed production-grade SQL queries and stored procedures to support a multi-terabyte relational database.
- Collaborated with cross-functional teams to build Power BI and SSRS dashboards, reducing data search time for stakeholders.
- Built resilient ingestion pipelines for high-volume vendor data, ensuring accuracy and reliability across millions of records.
- Implemented SQL-based transformations within Microsoft Fabric pipelines to enable ingestion of critical external vendor data.
- Interfaced with project managers with consideration for internal data handling standards in order to drive standard production processes forward in a compliant and efficient manner.
Scientist I
- Led research initiatives regarding production efficiency and process optimization.
- Designed and maintained ETL pipelines to streamline statistical analysis and visualization of experimental data.
- Applied Lean Six Sigma methodologies to improve data collection and handling practices.
- Coordinated international experimentation to scale and standardize manufacturing processes.
- Mentored research associates and lab technicians to ensure data integrity and compliance with SOPs.
Research Associate
- Designed, tested, documented, and implemented robotic automation for key liquid handling processes.
- Conducted laboratory research and collected data in accordance with esatblished SOPs.
- Performed statistical analysis and created visualizations to communicate findings to key stakeholders
- Maintained detailed laboratory records and ensured data integrity.
Get In Touch
Let's discuss how we can work together on your next data project.
I'm always interested in new opportunities and collaborations. Whether you need help with data analysis, dashboard development, or building data infrastructure, I'd love to hear about your project and discover what I can do to help drive your business forward.
What I Can Help With
- Data analysis automation and insight generation
- Dashboard and visualization development
- ETL pipeline design and implementation
- Machine learning model development
- LLM model implementation
- Data strategy and architecture consulting
Based in Livonia, MI • Email: jacobkrol66@gmail.com