Monika Verma
Lead Data Engineer @Greater Kansas City Community Foundation | Greater Horizons
Signup · Get unlimited contacts
WORK HISTORY
Lead Data Engineer @Greater Kansas City Community Foundation | Greater Horizons
Kansas City, MO, US
Designed and delivered end to end data pipelines integrating Fund, Donor, Grant, and Investment data across multiple internal and third party systems.• Built scalable data models and curated datasets to support donor reporting, grantmaking operations, compliance, and financial analytics.• Developed Spark/PySpark based ETL/ELT pipelines to improve data quality, reduce processing time, and enhance reliability across philanthropic data domains.• Implemented orchestration frameworks ADF and SSIS to automate complex workflows and ensure observability.• Established data governance practices including lineage, metadata standards, quality checks, and secure access patterns.• Develop and administer community foundation’s donor web portal using Django python, Postgres, T-SQL, JSON, docker in Linux environment. • Data Warehouse implementation to integrate financial data from 15 databases from FIMS (source system). • DW integration with multiple downstream applications Like Salesforce (using Kingsway soft SSIS toolkit), SharePoint (using SSIS and Layer2 components) and Power BI using Certified Data flows and Datasets. • Developed internal financial reports using SQL Server Integration services (SSRS). • Developed Power BI Apps, dashboards, and reports for community foundation’s donors. • Manage user groups without compromising on the security aspect using Row level security. Published, scheduled, and shared the dashboards with relevant groups. • Developed AI generated summaries for donor trends, fund performance, and operational metrics to support leadership decision making.• Partnered with analytics and business teams to translate requirements into architecture, data flows, and integration patterns.• Mentored junior engineers, enforced coding standards, and led best practice adoption across the engineering team.
EDUCATION
Guru Gobind Singh Indraprastha University
Bachelor of Technology (B.Tech.), Information Technology
MIT Professional Education
Applied Data Science Program, Artificial Intelligence
SKILLS
ABOUT MONIKA VERMA
I am a Lead Data Engineer and Data Architect with 16+ years of experience building enterprise‑grade data platforms, governed data products, and analytics ecosystems that support large‑scale operational and financial decision‑making. Over the past 7+ years at the Greater Kansas City Community Foundation, I have designed and implemented robust data pipelines and scalable data models that integrate fund, donor, grant, and investment data across diverse internal and third‑party systems. My work directly enables donor reporting, grantmaking operations, compliance, and financial analytics through curated datasets and modern engineering practices.My technical expertise spans Microsoft SQL Server, MSBI, SSIS, Power BI, Azure Data Engineering, Databricks, and Spark/PySpark, with a strong focus on building efficient ETL/ELT pipelines, implementing data governance frameworks, and automating workflows using orchestration tools such as ADF and SSIS. I am passionate about delivering reliable, high‑quality data solutions that empower philanthropic initiatives and drive meaningful organizational impact.Beyond engineering, I bring experience in leading data product delivery, collaborating with cross‑functional teams, defining data strategies, and enabling self‑service analytics through Power BI and certified semantic models. I enjoy solving complex data challenges, mentoring engineers, and leveraging AI‑driven automation to enhance data quality, documentation, and analytics capabilities.I thrive on building modern, scalable, and intelligent data ecosystems that help organizations make confident, data‑driven decisions.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.