Data Analyst

JOB PURPOSE:

The role of the Data Analyst is crucial in leading data-driven decision-making across the organization. This role includes the comprehensive procedure of importing, cleaning, transforming, and validating data to derive actionable insights. The analyst should have a high level of understanding in SQL for robust database management and querying, Excel for meticulous data validation, and Python for advanced data manipulation and analysis. A key part of this role involves translating complex data sets into easily understandable graphs and tables, making them accessible for non-technical stakeholders. In addition to internal data management, the analyst will cooperate with data research suppliers, adhering to internal protocols to ensure accurate data cleaning and acquisition. Using tools like JIRA, the analyst is expected to effectively manage, prioritize and multitask, ensuring that the marketing teams receive timely and fundamental support, thus reinforcing the organization's commitment to data-informed strategies.

KEY ACCOUNTABILITIES:

Analysis and Reporting

• Understanding customer’s requirements and providing quick and easy analytic solutions
• Conceptually/logically understanding the 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
• Extracting large and unstructured data sets from multiple platforms, cleansing the data to make it suitable for use
• Manipulating and transforming the data, categorizing it, and performing statistical analysis and visualizing insights on complex trend analysis to the business
• Drawing insights from the data, translating into strategy and feeding into the appropriate teams
• The data analyst is required to present their findings/analysis and translate them into an easily 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 selection request, Data uploads of 3^rd party data, Data integrity
• Building and maintaining 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: Selecting 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 at all times 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 similar data requests.
• Develop efficient workflow and work procedures
• When required, write 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 AND EXPERIENCE:

Minimum Experience:

• Highly numerate individual with an eye for detail, ensuring accuracy and precision in data handling.
• At least 3 years of hands-on experience in data analysis.
• Proven record of efficiency, prioritization, and delivering high-quality outputs.
• Demonstrated capability in multitasking and handling high-volume data transactions.

Technical and Job-Specific Skills:

• Database/Programming: Proficient in SQL Server, SQL/TSQL, and creating/maintaining stored procedures. Basic to intermediate skills in Python.
• Office Tools: Advanced proficiency in MS Excel, with experience in handling complex datasets and performing advanced data manipulations.
• CRM: Admin-level expertise in Salesforce (Desirable).
• Business Intelligence Tools: Strong familiarity with SQL and Excel for data analysis and visualization.
• Communication Skills: Effective public speaker with outstanding interpersonal capabilities. Proficient in translating complex business requirements into understandable non-technical terms for diverse audiences.

Behavioural Competencies:

• Efficiency: Ability to produce accurate results in optimal time.
• Quality-Driven: Priority given to high-quality outputs in every task.
• Creativity: Innovative in approach, bringing fresh perspectives to data-driven challenges.
• Teamwork: Collaborative, ensuring smooth intra-team communication and joint problem solving.
• Communication: Articulate, ensuring clarity and effectiveness in both written and verbal communications.

dmg events is an equal opportunity employer