1 Remote Sql jobs in India
Data Management Specialist (Remote)
560034 Bangalore City, Karnataka
Minutes to Seconds Pty Ltd
Posted 24 days ago
Job Viewed
Job Description
Job Title: Data Management Specialist Job Summary: We are seeking a Data Management Specialist to support our data processing operations. The ideal candidate will be responsible for cleaning, restructuring, validating, and uploading data into our system while ensuring accuracy and compliance with program rules. This role requires advanced Excel skills to manipulate and organize data efficiently. The selected candidate will also be responsible forconducting post-upload testing to confirm data integrity and accuracy.Key Responsibilities: 1. Data Cleaning & Preparation: o Identify and correct inconsistencies, duplicates, and errors in datasets. o Standardize and format raw data to match system requirements. o Ensure data consistency across different sources. 2. Data Reorganization & Formatting: o Transform data structures to align with the platform’s required format. o Create and modify Excel templates/macros for efficient data processing. o Use pivot tables, formulas, and automation techniques to organize data efficiently.3. Data Validation & Compliance: o Validate datasets against predefined business rules and logic. o Perform checks to ensure data accuracy, completeness, and integrity. o Collaborate with stakeholders to resolve discrepancies. 4. Data Upload & System Integration: o Prepare and upload validated data into the platform. o Address errors during upload and troubleshoot issues. o Document upload procedures and ensure compliance with system standards.5. Post-Upload Testing & Quality Assurance: o Conduct data verification after uploads to confirm accuracy. o Perform sample tests to identify missing or incorrect entries. o Generate reports to highlight any anomalies or errors. 6. Process Improvement & Documentation: o Identify opportunities for improving data management workflows. o Maintain records of data processing steps and update documentation. o Train team members on best practices in data management and Excel automation.RequirementsRequired Skills & Qualifications: • Advanced proficiency in Microsoft Excel, including: a) Pivot tables, VLOOKUP, HLOOKUP, INDEX-MATCH, and nested formulas. b) Data cleaning techniques using functions like TEXT, CONCATENATE, TRIM, SUBSTITUTE, etc. c) Macros and VBA scripting (preferred but not mandatory).• Experience in handling and processing large datasets. • Strong attention to detail and problem-solving skills. • Ability to follow complex data validation rules. • Understanding of data structures and data formatting principles. • Excellent organizational and documentation skills. • Ability to work independently and manage multiple tasks efficiently.Preferred Qualifications: • Bachelor’s degree in data science, Information Systems, Business Analytics, or related field.• Experience working with database tools or data management systems (optional).• Familiarity with Python or SQL for data manipulation (a plus but not required).
This advertiser has chosen not to accept applicants from your region.
Be The First To Know
About the latest Remote sql Jobs in India !
0