Data Management Specialist

As a Data Management Specialist, you will play a crucial role in supporting data processing operations by cleaning, restructuring, validating, and uploading data into our system. Your primary responsibility will be to ensure the accuracy and compliance of data with program rules. To excel in this role, you must possess advanced Excel skills to efficiently manipulate and organize data. Post-upload testing will also be a key aspect of your responsibilities to confirm data integrity and accuracy. Key Responsibilities: - Data Cleaning & Preparation: Identify and rectify inconsistencies, duplicates, and errors in datasets. Standardize and format raw data to meet system requirements. Maintain data consistency across various sources. - Data Reorganization & Formatting: Transform data structures to match the required platform format. Develop and modify Excel templates/macros for effective data processing. Utilize pivot tables, formulas, and automation techniques to streamline data organization. - Data Validation & Compliance: Validate datasets against predefined business rules and logic. Conduct checks to ensure data accuracy, completeness, and integrity. Collaborate with stakeholders to address discrepancies. - Data Upload & System Integration: Prepare and upload validated data into the platform. Resolve errors during upload and troubleshoot any issues. Document upload procedures and ensure adherence to system standards. - Post-Upload Testing & Quality Assurance: Verify data post-upload to ensure accuracy. Conduct sample tests to identify missing or incorrect entries. Generate reports highlighting anomalies or errors. - Process Improvement & Documentation: Identify opportunities to enhance data management workflows. Maintain records of data processing steps and update documentation. Train team members on data management best practices and Excel automation. Required Skills & Qualifications: - Proficiency in Microsoft Excel, including pivot tables, VLOOKUP, HLOOKUP, INDEX-MATCH, and nested formulas. - Familiarity with data cleaning techniques using functions like TEXT, CONCATENATE, TRIM, SUBSTITUTE, etc. - Experience in handling and processing large datasets. - Strong attention to detail and problem-solving abilities. - Ability to adhere to complex data validation rules. - Understanding of data structures and formatting principles. - Excellent organizational and documentation skills. - Capability to work independently and manage multiple tasks efficiently. Preferred Qualifications: - Bachelor's degree in data science, Information Systems, Business Analytics, or related field. - Experience with database tools or data management systems (optional). - Familiarity with Python or SQL for data manipulation (a plus but not required).,