Miami-Fort Lauderdale Area
Results-driven Data Engineer and Analyst with 5+ years of experience designing scalable ETL pipelines, predictive models, and executive dashboards that enhance decision-making and operational efficiency. Adept in Python, SQL, Snowflake, and cloud platforms (AWS/GCP), with a strong foundation in economics and advanced data modeling. Proven track record of reducing manual handling by 30%, improving operational KPIs by 25%, and cutting dashboard load times by 40%.
• Architected and maintained end-to-end pricing data pipelines using SQL, Python, and Snowflake, transforming raw transactional and product data into optimized pricing datasets. • Designed modular pricing engines that automated rule-based and margin-driven price calculations across millions of SKUs. • Developed reusable Python scripts for elasticity modeling, price simulations, and scenario forecasting to support strategic pricing decisions. • Built data validation and anomaly detection frameworks to identify pricing discrepancies and prevent revenue leakage. • Optimized complex SQL queries and warehouse schemas to improve pricing report performance and reduce processing time by 80%. • Integrated external APIs (competitor pricing, market indices) into internal pricing models to enable dynamic and data-driven adjustments. • Implemented version-controlled pricing logic using Git and structured deployment workflows to ensure reproducibility and governance.
•Designed and deployed scalable ETL pipelines in Python and R, integrating MySQL, MongoDB, and BigQuery to support real-time data ingestion and analytics. •Automated critical workflows by migrating manual processes into robust pipelines, improving data quality and reducing manual handling by 30%. •Built and maintained production-grade data marts to support analytics, reporting, and future machine learning use cases. •Developed and maintained executive dashboards, scheduled reports, and analytical tables, enabling operational visibility and financial planning at the company level. •Improved interdepartmental efficiency through automation of data flows and reduction of discrepancies across systems. •Managed and monitored data infrastructure using Git, Rundeck, and JIRA, ensuring high pipeline uptime and reliability. •Validated and tested critical datasets, proactively identifying and resolving data integrity issues before they affected business reporting.
•Developed internal tools and automated reporting pipelines, reducing report delivery time by 19% and streamlining recurring business processes. •Built merchant-specific dashboards and data marts in Snowflake and Redshift, enabling detailed reporting and insights for C-suite executives and high-value merchant partners. •Conducted source-to-target data mapping and modeling to support decision-ready datasets across AWS Redshift and Snowflake. •Performed deep-dive analyses using Python and AWS Redshift SQL to uncover actionable insights that improved operational KPIs by 25% across multiple business units. •Delivered ad hoc reports and real-time dashboards, increasing merchant operational efficiency and enhancing executive decision-making accuracy. •Refactored and maintained analytical code to follow internal coding standards and ensure maintainability across the team.
•Secured $5.15M in funding by conducting research and evaluating high-impact grant opportunities. •Developed interactive dashboards in Power BI to visualize grant performance across departments. •Analyzed funding trends and aligned opportunities with the municipality’s strategic goals. •Delivered economic analysis reports on infrastructure projects and tracked KPIs through real-time dashboards. •Ensured data quality and compliance through standardized QA and validation processes. •Built and maintained a centralized grants database with data pipelines to track application performance, outcomes, and ROI.
•Collected, cleaned, and structured raw data from multiple sources to support business reporting and analytics efforts. •Built operational and performance reports using Power BI and Tableau, enabling data-driven decisions for C-level executives and operations teams. •Maintained internal dashboards and data repositories, ensuring stakeholders had real-time access to accurate and up-to-date information. •Partnered with cross-functional teams to translate business requirements into actionable data insights. •Analyzed trends and patterns to identify inefficiencies and support strategic decision-making. •Improved reporting accuracy by implementing basic data validation checks and QA processes on key datasets.