Summary
Overview
Work History
Skills
Timeline
Generic

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

26
26
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, data flows, 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.

Senior Business Consultant

Katie Kalk Consulting
04.1999 - 08.2012

Key Accomplishments & Responsibilities:

  • Spearheaded a culture of continuous improvement, delivering innovative, client-focused solutions and enhancing team capabilities through training and knowledge sharing.
  • Led cross-functional teams to deliver complex projects on time and within budget, aligning deliverables with business goals and performance metrics.
  • Managed multiple concurrent projects by applying strong organizational and time management skills in high-pressure environments.
  • Identified and resolved technical issues through root cause analysis, boosting system performance and reliability.
  • Delivered technical training and system onboarding to end-users, ensuring smooth adoption and maximizing ROI on new technologies.
  • Collaborated with sales teams to support pre-sales activities, including demos, technical consultations, and client engagement to drive deal closures.
  • Strengthened client relationships and retention by understanding business needs and delivering tailored BI and analytics solutions.
  • Upgraded and secured reporting environments; developed executive dashboards, OLAP reports, and automated distribution systems supporting 300+ employees.
  • Led successful implementations of Cognos Finance, Cognos Planning, Infor CPM, and supported Cognos Decision Stream, Oracle, and SQL Server-based analytics.
  • Provided technical support for GUI ERP and RPG systems, enhancing operational efficiency.
  • Reduced project risks through early issue identification and strategic mitigation planning.
  • Aligned team objectives with organizational strategy, tracked progress, and facilitated regular executive reporting (CIO/CFO-level).
  • Continuously pursued professional development through industry events and applied insights to enhance consulting practice.

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

Senior Business Consultant

Katie Kalk Consulting
04.1999 - 08.2012
Katie Kalk