Data Analyst
Current• Data Integration and Visualization: Leveraged complex SQL queries and Power BI to create comprehensive data reports by extracting, cleaning, and structuring data effectively.• Automation: Automated data acquisition and processing tasks through Python scripts and Microsoft Logic Apps, enabling efficient data entry and report generation.• Data Quality Assurance: Conducted investigative work to identify and resolve discrepancies in metrics and reporting, ensuring data accuracy.• API… Show more • Data Integration and Visualization: Leveraged complex SQL queries and Power BI to create comprehensive data reports by extracting, cleaning, and structuring data effectively.• Automation: Automated data acquisition and processing tasks through Python scripts and Microsoft Logic Apps, enabling efficient data entry and report generation.• Data Quality Assurance: Conducted investigative work to identify and resolve discrepancies in metrics and reporting, ensuring data accuracy.• API Utilization: Utilized APIs, such as Meta's and TikTok's, to collect and process marketing data, creating hourly breakdowns and automating the data transfer process.• Alerting and Thresholds: Implemented automated alerts through Slack channels based on predefined thresholds for specific data, enhancing data monitoring.• ETL Processes: Set up pipelines in Microsoft Azure Data Factory to efficiently move and merge data between various sources, ensuring data consistency and automating data transfers.• Data Extraction: Extracted data from various sources, including web scraping using Selenium for use in database and Power BI reports.• Project Management: Spearheaded cross-functional initiatives for Marketing, Sales, SEO, and other teams, breaking projects into actionable steps and consistently meeting tight deadlines. Show less
