Data Analyst
dmg events
The Role
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 ReportingUnderstanding customer’s requirement and providing easy/quick analytics solutionsConceptually/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 stakeholdersExtract large and unstructured datasets from multiple platforms, cleansing the data to make it fit for purposeManipulate and transform the data, categorizing it, and performing statistical analysis and visualizing insight on complex trend analysis to the businessDrawing insight from the data, translating into strategy and feeding into the right teamsData analyst is required to present their finding/analysis and translate them into an easy understandable document for businessClearly reporting to communicate complex ideas to business in an easy wayDatabase AdministrationConceptualizing different aspects/features of the CRM to cater to projects like data selections request, Data uploads of 3rd party data, Data integrityBuilding and maintain a data warehouse to better manage global data, including data sourcing / mapping, data modelling, master data management and data migrationDeduplication: 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 databasesData 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 automationWrite procedures in order to reduce the time for same kind of data requests.Develop efficient workflow and work processesWhenever required, writing queries, triggers, stored procedures, views etc.Data AcquisitionCommunicate 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.