ETL & Data Automation: Use Matillion to streamline data processes, ensuring efficient and reliable data integration across all reporting systems.
Data Quality Assurance: Verify and validate data accuracy within Power BI dashboards, proactively identifying and addressing discrepancies to maintain high data integrity.
Dashboard Development: Build, maintain, and optimize Power BI dashboards to deliver real-time insights that help clients understand the performance of their digital and mobile media campaigns.
Advanced Data Skills: Strong proficiency in SQL, advanced Excel, or other data manipulation tools for handling and analyzing large datasets.
Develop tools and models such as segmentation, dashboards, data visualizations, decision aids and business case analysis.
Use advanced Excel functions like VLOOKUP, HLOOKUP, Pivot Tables, IF formulas, and conditional formatting.
Create and maintain complex Excel models and dashboards