Principal Data Architect
San Francisco, California, Us
• Orchestrated streamlined database solutions for efficient data storage and retrieval.• Generated and managed tailored reports for executive teams, enhancing decision-making processes.• Spearheaded successful data migration from legacy systems to modern solutions.• Conducted routine tests, troubleshooting, and integrated new features to optimize system performance.• Provided staff education through training initiatives and individual support.Solutions Developed:• Sales Analysis and Reporting: o Designed and developed a comprehensive solution for Senior Management, providing visibility into opportunity management and sales. o Enabled real-time views of opportunities and historical changes, integrating CRM, HubSpot, and Snowflake. o Utilized Python, Power BI Dataflows, Datasets, and Analytics.• Technical Account Management and Support: o Developed reporting and analytics for Technical Account Management and Support teams, consolidating data from CRM, HubSpot, JIRA, and internal product monitoring. o Created a unified view, eliminating the need to navigate multiple systems.• Product Development: o Constructed reporting and analysis tools offering Senior Management visibility across all product development teams and projects. o Implemented custom ETL from JIRA for progress tracking, adhering to Agile SCRUM methodologies.• Finance: o Developed Financial datasets integrating CRM, Licensing system, and financial data for Senior Managers. o Utilized Power BI to extract data from Snowflake warehouse and financial tracking systems.