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
- Architected and maintained Microsoft Fabric pipelines for real‑time analytics and reporting.
- Wrote production‑grade SQL (queries, stored procedures) for multi‑terabyte relational databases.
- Evaluated deployment strategies for on‑prem LLMs to automate high‑volume production workflows.
- Established data quality standards and monitoring processes in support of new business initiatives.
Data Analyst I
- Engineered scalable data solutions with cross‑functional teams to support business expansion into new markets.
- Automated production processes with Python scripts and Jupyter notebooks.
- Delivered Power BI and SSRS reports to inform stakeholders and drive efficiency.
- Implemented robust SQL transformations within Fabric ingestion pipelines to support critical business functions.
- 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