Financial Services
Technology, Information and Media
Consumer Services
Active

Erin Mahagan

Lead Analytic Consultant | Data Governance & Architecture | Transforming Data Strategy into Action

About Me

I’m a data professional with a Master’s in Applied Economics and over six years of experience bridging data analytics, governance, and architecture. I specialize in structuring information systems, defining governance frameworks, and ensuring that data is both compliant and actionable. In my current role as a Functional Architect within CIB IT Architecture, I validate IT solutions against enterprise data policies and frameworks to ensure alignment with data strategy and lifecycle standards. I collaborate with project managers, data architects, and governance specialists to design compliant data models, manage metadata, and contribute to a consistent enterprise-wide data architecture. Previously as a Lead Analytic Consultant, I partnered with cross-functional teams—including engineers, product managers, and designers—to transform complex datasets into meaningful insights. My work ranged from building data pipelines and dashboards to developing KPIs for tax compliance and product engagement. Notably, I created fraud report cards for tax agencies that allowed stakeholders to proactively respond to compliance risks. I’m proficient in SQL, Postgres, Looker, Tableau, Power BI, Airflow, and AWS and additional experience in governance tools like Collibra, Purview.

Jurisdiction

Region: Europe

Experience

Seniority LevelMid-Senior level
Years of Experience6-10 years
Current StatusActive
Functional ArchitectBNP Paribas
2025 - Present

• Ensure data systems comply with governance standards and enterprise data policies across the full lifecycle • Design and maintain data models and metadata structures that align with organizational strategy • Validate IT solutions from a data management and architecture perspective • Collaborate with data architects, project managers, and governance specialists to support compliant, high-quality data systems • Contribute to the development of data governance frameworks, policies, and best practices

Lead Analytic ConsultantVoyatek
2024 - 2025

• Collaborate closely with stakeholders to design and implement a Neo4j graph database, improving data management and analysis for clean vehicle tax credit programs. • Translate business requirements into scalable data models that represent complex relationships within the tax credit ecosystem. • Enable efficient querying and visualization of interconnected data to support program evaluation and compliance monitoring. • Partner with cross-functional teams to ensure the database supports evolving reporting and analytical needs.

Data EngineerExcella
2021 - 2024

• Partnered with product and business teams to automate data flows and reporting, reducing manual effort and enabling real-time decision-making. • Delivered a Jira-to-database pipeline that feeds into a Power BI dashboard used by leadership to monitor project performance. • Improved visibility into key product metrics by ensuring accurate data collection, transformation, and integration across systems. • Worked with Looker dashboards and business users to turn data into clear visual stories deployed on a monthly basis. • Participated in Agile ceremonies and collaborated with product managers to align analytics development with evolving business needs.

Data Analyst Hagerty Consulting
2021 - 2021

NYCEM– Emerging Compliance Issues • Developed and presented interactive Tableau dashboards for over 10 NYC agencies, helping stakeholders monitor KPIs related to emergency compliance. • Facilitated data-sharing discussions and worked closely with non-technical stakeholders to define requirements and improve data accessibility.

Senior ConsultantASR Analytics
2017 - 2021

IRS – Security Summit (Public-Private Partnership to Combat Identity Theft) • Led data analysis and reporting efforts for the IRS Security Summit, a collaboration between government agencies and private tax industry partners (e.g., Experian, TurboTax). • Designed and implemented a standardized fraud "report card" to track performance metrics across industry partners, providing clear visibility into suspicious activity and enabling partners to take targeted action. • Developed and optimized SQL queries to efficiently extract and aggregate metrics from large-scale tax data systems, enabling timely performance reporting for industry partners. • Worked directly with external stakeholders to gather business requirements, translate them into data models, and deliver actionable insights through automated reports and dashboards. • Transformed raw and complex datasets into user-friendly summaries that supported executive decision-making and policy refinement. • Regularly presented findings to non-technical audiences, including executives at IRS, and partner companies. Emerging Compliance Issues • Conducted product usage and behavioral analysis on millions of tax filings, identifying patterns that informed policy and compliance strategy. • Delivered regular reports and visual summaries to internal and external audiences, including Congress and federal oversight bodies. • Provided a monthly report including details of deployment design and methodology, data collection procedures, key findings, analytic techniques and recommendations Detecting Business Tax Fraud • As part of agile approach, conducted data-driven hypothesis testing using SQL on the 10 million plus annual business returns in order to identify suspicious trends • Supported the machine learning model development team by creating features/indicators • Aggregated and analyzed various data sets based on business inputs and provide datasets to enable actionable insight from and by the business.

Skills

Core skills0
Languages1

Languages

English