•Build and Manage ETLs: Develop and maintain efficient ETL pipelines using Python scripts and Fivetran connections to integrate data from multiple sources into BigQuery.•Optimization: Optimize SQL queries, ETL processes, and scripts to reduce processing times and potentially lower costs on cloud infrastructure.•Automation Development: Create automations that save time for stakeholders, streamlining workflows, and improving data accessibility for the team.•Data Cleaning and Preparation: Clean and transform semi-structured and raw data, ensuring quality and usability for stakeholders across various departments.•Advanced SQL for Analytics: Write and optimize complex SQL queries to prepare data for Looker dashboards, enabling data-driven decision-making.•Data Modeling: Design and implement data models that support scalable analytics, ensuring data is well-organized and easy to query.•Documentation & Data Dictionary: Develop thorough documentation, including data dictionaries, to ensure transparency and ease of use for all data users.•Cross-functional Collaboration: Work closely with analysts, business teams, and engineers to ensure data accuracy and alignment with business objectives.•Performance Tuning: Regularly monitor and optimize the performance of BigQuery datasets and Looker dashboards to enhance user experience.•Stakeholder Engagement: Act as a data subject matter expert for internal teams, addressing their needs and providing data insights to support strategic initiatives.

Data Engineer, New York, NY Automating Reports for a $1.5B client using Python & SQL saving days at a timeMaintaining version control by using GIT & VS code Organizing team tasks by the use of the Kanban board system with Asana and managing projects via collaborative tech-scopes Designed and implemented real-time data pipelines to process semi-structured data from sources such as search and social platforms using Python & SQLDocumenting development best practices via the kanban board system Asana and ConfluenceAssisting team tool migration to a more cloud based production environment, using AWS and Snowflake

- Use Datorama to display media activity on a global scale, for analysis and optimization of conversion-focused campaigns - Train offshore data analyst in dashboard QA, and process new build requests- Automated tasks such as weekly QA emails, data transfer into Datorama, and insight emails to clients- Optimized team performance by creating a tracker, maintaining structure for naming conventions, and email templates- Establish a connection between API endpoints to create a seamless data pipeline- Clean, prepare, aggregate data using Excel, C, R, and SQL- Analyze data from Kantar and MRI to support new business pitches with reports like competitive spend, consumer insights

- Guide students through 200+ hours of hands on data programming skills- Teach students vital data analysis concepts such as PIVOT table, vlookup, hlookup, powerBI, SQL, Google Analytics, Python, and Salesforce - Reviewed Student resumes, mentored students, and mapped out a long-term career plans with students- Coached students in client presentations with Morgan Stanley, and interview preparation with Facebook talent match event

- Using SQL to QA dashboards on Tableau- Conduct extensive QA process assets before launch- Used Excel Macro to check taxonomy on a weekly basis to ensure all naming conventions are accurateEvaluate global dashboards to align with platform data

- Analyzed and organizing media campaign data using SQL, R and C based languages building data visualization on Datorama- Compiled data using tools such as Excel, Brandwatch, Sprout Social, Neilsen, Scarborough, and Kantar, to measure real-time data and create insights consumable for the client’s next steps.- Analyzed real-time social, search, and programmatic data to measure the performance of campaigns from Google, Microsoft, Facebook, Pinterest, Snapchat, and similar platforms - Compiling quarterly data to provide insights on QBR presentations for future campaign optimizations

Data Analytics Apprentice▪ Participating in a program with a focus on data analytics through 200+ hours of hands-on workshops ▪ Learning techniques in Excel, PowerBI, SQL, Tableau, Google Analytics, and Salesforce▪ Researching different digital insights to understand market trends in the industry▪ Creating dashboards on Tableau based on data pulled online for group projects

Intern▪ Updating user data in MBS database for union-wide use using quality assurance▪ Assisting Human Resources department with union-wide event planning and coordinating▪ Archiving event department’s data on excel for further analysis of the budgeting of over 200 clients▪ Creating electronic copies of all case files for grievance department