Erum Chagani
Prosper,TX
Summary
Results-driven data management professional with over four years of experience in enterprise data security, governance, and cloud data platform initiatives. Extensive expertise in Snowflake architecture, RBAC design, SOX compliance, and the development of scalable ELT frameworks. Proven leader skilled in enhancing security measures, facilitating cross-functional integrations, and implementing automation strategies across Finance, HR, and Operations systems. Highly regarded for proactive ownership, technical proficiency, and the ability to deliver impactful solutions during organizational transformation.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Management Analyst
Q2
12.2021 - Current
- Architected and implemented enterprise-wide RBAC framework aligned with least-privilege principles across Development and Production environments.
- Led Snowflake Security Enhancements, strengthening access controls, auditability, and regulatory alignment.
- Designed role hierarchies, object-level security, and automated access governance processes.
- Owned and executed SOX compliance initiatives for Snowflake and Fivetran, improving audit readiness and control maturity.
- Partnered with ALTR to implement and demo advanced data classification and security controls.
- Designed modular, scalable ELT pipelines in Snowflake using Coalesce with strong lineage, dependency management, and incremental modeling.
- Built enterprise-grade fact and dimension models including SCD logic and optimized incremental loads.
- Architected automated ingestion pipelines via Fivetran from various sources such as Salesforce, Netsuite, Workday, Jira, etc.
- Ensured source-to-target reconciliation, completeness validation, and production data accuracy.
- Developed workflow automation solutions using Workato, reducing manual operational effort.
- Built enterprise integrations and validation workflows using Informatica.
- Delivered production-grade ETL frameworks with structured logging, monitoring, and error handling.
- Led root-cause resolution of complex employee data sync and security incidents within Snowflake.
- Presented technical initiatives during sprint demos and stakeholder sessions. translating complex work into clear business impact.
- Mentored new team members, accelerating onboarding and strengthening team capability.
- Recognized for cross-team collaboration, reliability, and calm, solution-oriented troubleshooting under pressure.
- Stepped up during leadership transitions and heavier project loads maintaining delivery excellence without disruption.
Data Management Analyst (Contractor)
Q2
02.2021 - 12.2021
- Designed and implemented complex SSIS-based ETL solutions for multi-source enterprise data migration.
- Built scalable transformation pipelines utilizing advanced data transformation patterns.
- Supported production operations and business-critical change requests.
- Contributed to foundational architecture that later supported Snowflake migration and governance improvements.
- Remote
Education
Information Technology
Colaberry School of Data Analytics
Plano, TXHigh School Diploma -
Ellison High School
Killeen, TX06-2005
Skills
- Snowflake Security Architecture
- RBAC & Least-Privilege Design
- SOX & Audit Compliance
- Data Governance & Classification
- ELT / ETL Architecture
- Enterprise System Integration
- Root Cause Analysis
- Cross-Functional Leadership
- Stakeholder Communication
- Data Modeling (Fact/Dimensional, SCD)
- Snowflake, Coalesce, Fivetran, Workato, Informatica, SSIS, T-SQL, SSMS, SharePoint, Microsoft Office
Certification
- Snowflake SnowPro Core Certification
- Snowflake SnowPro Advanced: Architect Certification
Timeline
Data Management Analyst
Q2
12.2021 - Current
Data Management Analyst (Contractor)
Q2
02.2021 - 12.2021
Information Technology
Colaberry School of Data Analytics
High School Diploma -
Ellison High School