data analyst

Design, implement, and support key datasets that provide structured information with the needs of the end customer.

•          Build ETLs/ELTs to take data from various telemetry streams, data lakes and supporting data sources and craft a unified dimensional or star schema data model for marketing, analytics and reporting

•          Develop a deep understanding of vast data sources (existing on the cloud) and know exactly how, when, and which data to use to tackle business problems

•          Design efficient data structures and database schemas

•          Work with large-scale data sets

•          Utilize a variety of data stores including Azure Data Lakes, SQL Database, SQL Data Warehouse, and Azure Analysis Services

•          Retrieve and analyse data using SQL, Excel, Power BI and other data management systems

•          Collaborate with other teams (agencies & engineering data upstream) to maximize available resources for client support and successful outcomes.

•          Track ongoing progress of projects and deliver timely updates to leads.

•          Be knowledgeable on email best practices, technologies, and trends such as CAN-SPAM, CCPA and GDPR compliance.