Carly Wagner
Summary
Accomplished Data Architect with extensive expertise in SQL, Azure, and business intelligence tools like Microsoft Power BI and ThoughtSpot. Proven track record of leading complex data integration projects, designing and implementing advanced data warehouse solutions, and enhancing business intelligence capabilities to drive strategic decision-making. Adept at fostering collaborative high-performance teams, delivering innovative client solutions, and reengineering data systems to improve reporting accuracy and efficiency. Holds a Master's in Data Science and Analytics and a Bachelor's in Statistics with a strong foundation in business acumen.
Overview
8
8
years of professional experience
Work History
Data Architect
NIMBLE SOLUTIONS
06.2021 - 05.2024
- Spearheaded the seamless integration of data and reporting systems following two major acquisitions from AS400 and SQL environments into an Azure SQL environment using Python and SQL stored procedures to normalize data, ensuring business continuity and data integrity
- Architected state-of-the-art data warehouse solution and a robust transactional application database
- Led and mentored a dynamic team of 3 Data Integration Developers and 2 Business Intelligence Developers, fostering a collaborative and high-performance work environment
- Architected and implemented advanced stored procedures to enhance the functionality of a data-driven microservice architecture for an internal business application
- Gathered requirements, designed, developed and delivered innovative client business intelligence products that significantly boosted revenue streams
- Reengineered a complex data warehouse encompassing 55 data sources and over 125 dimension and fact tables, dramatically improving internal and external reporting capabilities
- Directed an offshore team of 50 business analysts in developing a standardized reporting template and ensuring rigorous data validation procedures occurred.
Data Analyst
NIMBLE SOLUTIONS
06.2017 - 06.2021
- Deployed self-service BI solution, ThoughtSpot, leveraging normalized production database sources; supporting 10,000 user created dashboards providing near real time insights to leadership, managers and production staff
- Developed a comprehensive Power BI dashboard that provided in-depth analysis of client profitability, driving strategic decision-making, by collaborating with the finance team and driven by production databases and labor resource allocations and productivity corresponding to client deliverables
- Created over 25 innovative Power BI dashboards that provided management with unprecedented reporting capabilities, enabling more effective team and business oversight.
Intern
NIMBLE SOLUTIONS
05.2016 - 05.2017
- Designed and implemented a Microsoft Power BI report for executive staff, enabling enhanced management of staff productivity
- Automated a labor-intensive report using Macros and Power Query, increasing operational efficiency
- Created a database consolidating 3,000 separate Client End of Month reports using Power Query, streamlining data access and analysis.
Education
Master of Science - Data Science And Analytics
University of Missouri
Columbia, MO05.2021
Bachelor of Science - Statistics
University of Missouri
Columbia, MO05.2017
Skills
- SQL
- Azure SQL
- Azure DevOps
- Microsoft Power BI
- Microsoft Power Query
- ThoughtSpot
- Azure Analysis Services
- DAX
- Python
- R
- Data Modeling
- Problem Solving
- Data Analysis
- Continuous Integration/Continuous Deployment (CI/CD)
- Azure Data Warehousing
- Master Data Management (MDM)
- Microsoft Visual Studio
- Business Intelligence
- Database Design
Timeline
Data Architect
NIMBLE SOLUTIONS
06.2021 - 05.2024
Data Analyst
NIMBLE SOLUTIONS
06.2017 - 06.2021
Intern
NIMBLE SOLUTIONS
05.2016 - 05.2017
Master of Science - Data Science And Analytics
University of Missouri
Bachelor of Science - Statistics
University of Missouri
Similar Profiles
Nicholas RuffinNicholas Ruffin
Lead Full Stack Developer at Nimble SolutionsLead Full Stack Developer at Nimble Solutions
Madison ShermanMadison Sherman
Intern at Nimble SolutionsIntern at Nimble Solutions
Heather KuefferHeather Kueffer
Assistant Director at nimble solutionsAssistant Director at nimble solutions
Keshav InderjeetKeshav Inderjeet
Data Architect at Axciom Salesforce Practice (Formerly Rafter One)Data Architect at Axciom Salesforce Practice (Formerly Rafter One)
Sathyanath GopinathanSathyanath Gopinathan
Data Architect at Scyne AdvisoryData Architect at Scyne Advisory