About us - dmg events dmg events is an international exhibitions and publishing company. We attract more than 425,000 visitors to our global portfolio of 80 exhibitions each year. Through our global events, our aim is simple. We want to accelerate business through face-to-face events, which is why we work so hard to bring people together, creating opportunities for them to network, learn and do business. dmg events is part of the Daily Mail Group Trust (DMGT). DMGT Manages a diverse, multinational portfolio of companies with total revenues of \xc2\xa32bn, that provide businesses and consumers with compelling information, analysis, insight, events, news, and entertainment. JOB PURPOSE: The Data Analyst role is pivotal in driving data-driven decision-making across the organization. This position encompasses the comprehensive process of importing, cleaning, transforming, and validating data to draw actionable insights. The analyst should possess a high level understanding in SQL for robust database management and querying, Excel for meticulous data validation, and Python for advanced data manipulation and analysis. A cornerstone of this role involves translating intricate data sets into easily comprehensible graphs and tables, making them accessible for non-technical stakeholders. Beyond internal data management, the analyst will liaise with data research suppliers, abiding by internal protocols to guarantee accurate data cleansing and acquisition. Employing tools like JIRA, the analyst is expected to efficiently manage, prioritize, and multitask, ensuring the marketing teams receive timely and essential support, thus solidifying the organization\'s commitment to data-informed strategies. JOB CONTEXT: Liaise with Database, Marketing, IT and Web team to ensure data automation, integrity, and quality. KEY ACCOUNTABILITIES: Specify the output required from the job. Identify not more than 8 Key Accountabilities & their performance indicators. NB-Focus on outcomes not tasks Analysis and Reporting:

• Understanding customer\'s requirement and providing easy/quick analytics solutions
• Conceptually/logically understand current business CRM/tool to build and support reusable data analysis structures within the technical environment, enabling self-service analytical capability for key technical stakeholders
• Extract large and unstructured datasets from multiple platforms, cleansing the data to make it fit for purpose
• Manipulate and transform the data, categorizing it, and performing statistical analysis and visualizing insight on complex trend analysis to the business
• Drawing insight from the data, translating into strategy and feeding into the right teams
• Data analyst is required to present their finding/analysis and translate them into an easy understandable document for business
• Clearly reporting to communicate complex ideas to business in an easy way

Database Administration:

• Conceptualizing different aspects/features of the CRM to cater to projects like data selections request, Data uploads of 3rd party data, Data integrity
• Building and maintain a data warehouse to better manage global data, including data sourcing / mapping, data modelling, master data management and data migration
• Deduplication: Working through various mechanisms in order to eliminate duplication within existing data and/or for new data upload.
• Data Selection: Selection and exporting each marketing segment that currently exists within our CRM (Salesforce) and other databases
• Data formatting and uploading: To remove any error, typos and mapping fields in order to update or upload new data from various sources in Salesforce.
• Data integrity: Clean and update data all the time in order to maintain data integrity in the system, this may include updating contact information, inactive contacts, mail returns etc.

Data automation:

• Write procedures in order to reduce the time for same kind of data requests.
• Develop efficient workflow and work processes.
• Whenever required, writing queries, triggers, stored procedures, views etc.

Data Acquisition:

• Communicate with internal teams to gather accurate requirements related to target market list research.
• Liaise with list research suppliers and brief in internal requirements.
• Quality check received data.
• Upload data and communicate to internal teams.

QUALIFICATIONS, EXPERIENCE, & SKILLS: