Jake R.

About Jake R.

At Aterian, our team leverages Power BI and Alteryx to transform data into actionable business intelligence, a skill honed over a significant tenure in financial planning and analysis. With a mastery of strategic management, the focus is on driving insightful decision-making and enhancing organizational performance through advanced analytics.As the Director of Data Analytics, collaboration and clear communication are the bedrock of our strategy to streamline financial analysis and reporting processes. This commitment to BI solutions empowers informed decision-making, ensuring that Aterian remains at the forefront of innovation and efficiency in the industry.

Experience

1. Lead Data Engineer

   Kamps Pallets

   Jun 2025 — Present

   As Lead Data Engineer, I drive the design, development, and optimization of enterprise data systems to enable actionable insights and scalable analytics.Redesigned and modernized Power BI models, transforming a single, complex enterprise model into multiple streamlined, business-focused models. This improved performance, scalability, and governance while enabling faster refresh times and more agile reporting.Re-architected the Databricks environment with optimized table and view structures, increasing data accessibility, reducing compute overhead, and aligning our architecture with Microsoft Fabric’s capacity and performance framework for a smoother transition.Built a multidimensional forecasting model in Databricks to support granular budget and forecast seeding, improving accuracy and supporting enterprise-wide financial planning.Developed an automated forecast ingestion pipeline that consolidates adjusted forecast data into the data warehouse, improving reliability, auditability, and end-to-end workflow efficiency.Collaborated with business and analytics teams to design reporting structures tailored to operational needs, increasing efficiency, adoption, and trust in data-driven decision-making.Day-to-day, I:Mentor on architecture, coding standards, and best practices.Design, build, and optimize ETL/ELT pipelines across multiple platforms, ensuring data quality, integrity, and compliance.Collaborate with stakeholders to translate requirements into technical solutions that align with strategic goals.Evaluate and implement new technologies to improve scalability, efficiency, and maintainability of data systems.Drive data governance initiatives, including lineage, documentation, and compliance with company and regulatory standards.Build impactful reporting through the use of Power BI.

Education

• Davenport University

  Bachelor of Business Administration (BBA), Accounting

  2007 — 2012

• Davenport University

  Master of Business Administration (MBA), Strategic Management

  2012 — 2014