Data Management Specialist

As a Data Management Specialist at MinutestoSeconds, you will play a crucial role in supporting our data processing operations. Your primary responsibilities will include cleaning, restructuring, validating, and uploading data into our system with a strong emphasis on accuracy and compliance with program rules. Your expertise in advanced Excel skills will be essential for efficiently manipulating and organizing data. Additionally, you will be tasked with conducting post-upload testing to verify 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. Ensure data consistency across various sources. - **Data Reorganization & Formatting:** Transform data structures to align with the required platform format. Develop and adjust Excel templates/macros for streamlined data processing. Utilize pivot tables, formulas, and automation techniques to effectively organize data. - **Data Validation & Compliance:** Validate datasets against predefined business rules and logic. Perform checks to guarantee 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 accuracy post-upload. Conduct sample tests to identify missing or incorrect entries. Create reports to highlight anomalies or errors. - **Process Improvement & Documentation:** Identify areas for enhancing data management workflows. Maintain records of data processing steps and update documentation. Train team members on data management best practices and Excel automation. Requirements: **Required Skills & Qualifications:** - Advanced proficiency in Microsoft Excel, including pivot tables, VLOOKUP, HLOOKUP, INDEX-MATCH, and nested formulas. - Ability to utilize data cleaning techniques such as TEXT, CONCATENATE, TRIM, SUBSTITUTE, etc. - Experience with macros and VBA scripting is preferred. - Proficiency in handling and processing large datasets. - Strong attention to detail and adept problem-solving skills. - Ability to adhere to complex data validation rules. - Understanding of data structures and formatting principles. - Excellent organizational and documentation abilities. - Capability to work independently and efficiently manage multiple tasks. **Preferred Qualifications:** - Bachelor's degree in data science, Information Systems, Business Analytics, or a related field. - Experience with database tools or data management systems is optional. - Familiarity with Python or SQL for data manipulation is a plus. Benefits: **Compensation & Benefits:** - Competitive salary based on experience. - Opportunity to collaborate with a dynamic team and advance within the organization.,