Summary
Overview
Work History
Skills
Timeline
Generic
Katie Kalk

Katie Kalk

Valparaiso

Summary

Senior Power BI Developer with over 2 decades of expertise in data engineering and business analytics, leveraging advanced skills in Azure, SSIS, and Power Apps to drive innovative solutions. Demonstrates a visionary approach to enhancing financial reporting accuracy and compliance, evidenced by a successful overhaul of reporting strategies and seamless system integrations. Committed to pioneering advancements in data management, fostering collaborative environments, and delivering actionable insights for strategic decision-making.

Overview

30
30
years of professional experience

Work History

Senior Data Engineer

JLL
12.2010 - 04.2025
  • Implemented Master Data Management best practices in ETL development.
  • Designed and developed ETL processes for SQL Server 2008 R2 Performance Data Warehouse
  • Created Power BI reports, dataflows, datasets, and composite models.
  • Automated report distribution and data refresh cycles using Power Automate
  • Designed and implemented a new reporting strategy, enhancing financial reporting accuracy and delivering 22 comprehensive reports across 6 business areas in under a year.
  • Conducted in-depth BI tool analysis to replace the Cognos reporting environment, presenting actionable insights to management that informed strategic decision-making.
  • Worked closely with external SOX Auditors to ensure compliance, providing accurate documentation for financial reports that bolstered audit readiness and transparency.
  • Provided ongoing end-user training and support, facilitating user acceptance testing and ensuring seamless adoption of new reporting tools and processes.
  • Led the design and implementation of a Global HR Data Warehouse, enabling data-driven insights for over 100,000 employees and streamlining HR reporting.

Principal and Owner – Business Consultant

Katie Kalk Consulting
05.2009 - 08.2012
  • Implemented executive dashboards and OLAP reports.
  • Developed report distribution solutions for sales force integration.
  • Upgraded reporting environments and implemented security measures.
  • Provided detailed end-to-end migration and implementation estimates.
  • Conducted weekly status meetings with CIO and CFO.

Technical Consultant

BrightStar Partners
12.2006 - 05.2009
  • Focused on performance application solutions and data warehousing.
  • Developed requirements documentation and project scope.
  • Designed and implemented integrated solutions for financial reporting.
  • Presented integrated solutions at Cognos Forum.

Professional Services Consultant

SSA / Infor
01.1999 - 11.2006
  • Implemented Cognos Finance, Cognos Planning, and Infor CPM Solutions.
  • Supported Cognos Decision Stream, Oracle, and SQL Server versions of Infor Analytics.
  • Provided technical support for GUI ERP environments and RPG products.
  • Supported supply chain management modules.


Additional Work History and References available upon request.

Skills

    Technical Expertise

  • Advanced: Power BI Data Warehousing Business Intelligence & Analytics
  • Proficient: SQL Server Power Automate Data Engineering ERP Systems System Integration Performance Tuning
  • Working Knowledge: SSIS ETL Oracle PeopleSoft Power Apps REST APIs

    Core Data & Analytics
    Data Modeling Advanced SQL & Relational Databases Real-time Analytics Data Integration Data Security Advanced Analytics & Statistical Analysis Data Visualization Decision Trees

    Tools & Methodologies
    Agile Methodologies Project Management Cloud Computing (Azure) Power Platform (Power Apps Automate)

    Business & Interpersonal
    Analytical & Critical Thinking Complex Problem-Solving Attention to Detail Organizational & Time Management Task Prioritization Goal-Setting Continuous Improvement Excellent Communication & Active Listening Collaborative Teamwork Adaptability & Self-Motivation

Timeline

Senior Data Engineer

JLL
12.2010 - 04.2025

Principal and Owner – Business Consultant

Katie Kalk Consulting
05.2009 - 08.2012

Technical Consultant

BrightStar Partners
12.2006 - 05.2009

Professional Services Consultant

SSA / Infor
01.1999 - 11.2006
Katie Kalk