Data Specialist

Job Description

We are looking for a skilled Data Specialist with an excellent command of Microsoft Excel, Access databases, and a working knowledge of ERP systems to join our team. The Data Specialist will be responsible for collecting, organizing, and maintaining data from multiple sources, ensuring accuracy and efficiency in data management. The successful candidate will also develop macros and other automated solutions to streamline processes and provide support to various departments with actionable data insights.Key Responsibilities: Data Management and Organization: Collect, consolidate, and organize data from various sources (e.g., spreadsheets, databases, ERP systems) to create a unified and structured database. Maintain and update existing databases, ensuring data accuracy, integrity, and security. Data Analysis and Reporting: Analyze large datasets to identify trends, patterns, and insights that support decision-making for different departments. Generate reports, charts, and visual representations of data, providing actionable insights to stakeholders. Macro Development: Create and maintain advanced Excel macros to automate repetitive tasks, streamline data analysis, and improve workflow efficiency. Customize macros to meet the specific needs of different departments, ensuring that data processes are tailored to their requirements. Database Management: Design, manage, and maintain Access databases to ensure efficient data storage and retrieval. Implement database queries, forms, and reports to facilitate smooth operations for various functions. ERP Integration: Collaborate with ERP system users to integrate data processes and workflows into the system. Leverage ERP knowledge to enhance data management practices and improve operational efficiency. Quality Assurance: Regularly audit and clean up data to ensure accuracy, completeness, and consistency across all platforms. Troubleshoot and resolve any data-related issues that arise. Collaboration and Support: Work closely with IT, finance, operations, and other departments to understand their data needs and provide timely solutions. Train and support staff in data management, Excel, and database best practices.Required Qualifications and Skills: Education: Bachelors degree in Information Technology, Data Management, Business Administration, or a related field. Experience: Minimum of 2-3 years of experience as a Data Specialist, Data Analyst, or similar role. Technical Skills: Advanced proficiency in Microsoft Excel (e.g., pivot tables, VLOOKUP, HLOOKUP, formulas, charts, and complex macro development). Proficient in Microsoft Access (e.g., database design, query writing, forms, reports). Working knowledge of ERP systems is highly desirable. Experience with data visualization tools (e.g., Power BI, Tableau) is a plus. Familiarity with data validation, cleaning, and quality assurance techniques. Soft Skills: Strong analytical and problem-solving skills. Excellent attention to detail and organizational skills. Ability to work both independently and as part of a team. Strong communication skills with the ability to present data insights clearly to non-technical stakeholders. Preferred Qualifications: Certifications in data management, Excel, or database administration will be an advantage.What We Offer: Competitive salary and benefits package. Opportunities for professional development and growth within the company. Collaborative and dynamic work environment. Exposure to diverse data management and analytics projects.,

Keyskills :
Microsoft Exceldata managementdata analysisdatabase managementquality assurancecollaborationdata visualizationdata validationcommunication skillsAccess databasesERP systemsmacro developmentERP integration