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.
Key Accountabilities:
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 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 track record of efficiency, prioritization, and delivering high-quality outputs.
• Demonstrated capability in multitasking and managing 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 intricate business requirements into comprehensible non-technical terms for diverse audiences.
• Data Management: Deep understanding and hands-on experience with complex data extraction, transformation, and loading techniques. Ability to discern trends, pinpoint issues, and devise corrective actions based on data-driven insights.
dmg :: events is an equal opportunity employer, should you not hear back from us within 14 days, please consider your application as unsuccessful at this time.
