Technical Data Analyst - Freelance, Remote
Magic One
Technical Data Analyst - Freelance, Remote
DescriptionAbout the ClientOur client is a business intelligence and data management company that helps organizations optimize telecom and technology services. They deliver visibility into service inventories, contracts, and billing to reduce costs and improve performance. You will support their Business Intelligence team to ensure clean, complete, and timely service data that powers decision-making.\n
Why does this role exist?
This role exists to acquire, validate, and maintain mission-critical telecom and technology service data that feeds the client’s BI reporting and optimization programs. By conducting proactive outreach to service providers, remediating data issues, and processing service changes, the Technical Data Analyst ensures data accuracy and continuity across systems. The outcome is reliable, actionable information that supports cost control, contract management, and service lifecycle decisions.
The Impact you’ll makeData Acquisition & Provider Outreach\nContact telecom/technology service providers by phone and email to obtain missing details (e.g., term dates, circuit IDs, addresses, voice numbers, pricing).\nIdentify and reach the right provider contacts using provided lists, invoices, portals, and public resources.\nTrack outreach activity and document dates, contacts, and responses.\nData Validation & Record Remediation\nReview Excel/Smartsheet datasets to identify missing, inconsistent, or duplicate entries.\nValidate against invoices, provider communications, and internal documentation.\nStandardize formats (IDs, numbers, addresses, dates), merge/remove duplicates, and flag issues for BI review.\nData Entry & System Updates\nEnter newly gathered information into designated workbooks and Smartsheet project sheets.\nUpdate service attributes (location, provider, service type, contract status) following defined validation rules.\nDouble-check updates to maintain >99% accuracy.\nService Change & Disconnect Processing\nSubmit requests to move services to month-to-month terms or prevent auto-renewal as instructed.\nIdentify services for disconnection, initiate termination, track status, and confirm billing cessation.\nUpdate records with new statuses and effective dates.\nTask Management, Reporting & Collaboration\nMaintain clear task tracking and logs in Smartsheet for all outreach, updates, and service requests.\nProvide weekly summaries of progress, outstanding items, disconnect activity, and escalations.\nPartner with BI, Customer Success, and Account Services; respond to on-demand data requests (e.g., associated numbers, term dates, circuit data).\n
Skills, Knowledge and ExpertiseRequired:\n2+ years in technical support and/or data analysis within telecom/technology services or a closely related domain.\nAdvanced Excel skills (lookups, pivot tables, data validation, de-duplication) and accuracy working with large datasets.\nHands-on experience with Smartsheet or similar project/data tracking tools.\nProven experience conducting professional phone/email outreach and validating data against invoices/portals.\nExcellent written and verbal English communication; available to work Monday–Friday, 9:00 a.m.–5:00 p.m. CST.\nWFH Set-Up:\nComputer with at least 8GB RAM, an Intel i5 core processor/AMD Ryzen 5 Processor and up.\nInternet speed of at least 40MBPS\nHeadset with an extended mic that has noise cancellation and a webcam\nBack-up computer and internet connection\nQuiet, dedicated workspace at home\n\n\nYour Superpowers:\nTechnical: Excel power user; Smartsheet (or similar); data cleansing and normalization; record deduplication; invoice/portal navigation; use of LLM tools (e.g., ChatGPT) to draft emails or summarize documents.\nProcess & quality: Meticulous attention to detail, rigorous QA mindset, documentation discipline, strong follow-through.\nCommunication: Clear, professional phone/email presence; confident escalating issues with context and evidence.\nWork style: Analytical, self-directed, organized, and dependable; able to manage recurring tasks and deadlines.\nEthics: Reliable handling of confidential data and adherence to data privacy expectations.\nYou should apply if… \nYou love transforming incomplete, messy datasets into clean, reliable information that others can trust.\nYou are persistent and professional when chasing details from service providers and can keep meticulous records of every step.\nYou thrive in a structured, process-driven environment but communicate proactively when something needs clarification or escalation.\nYou value accuracy, accountability, and teamwork—and you’re comfortable working autonomously day to day.\n\nWhat to expect...
\nWork Setup:\nRemote position\nMust have a reliable internet connection and a quiet workspace\nRequired to provide own computer with Intel Core i5 or something similar or higher operating system\nWorking Hours:\n40 hours per week\nMonday to Friday 9 AM to 5 PM Central Time\nCompensation:\n$7 per hour\nNo benefits package included\n
Benefits
Department: Support & Leadership
Employment Type: Full Time
Location: Philippines
Reporting To: Client via Magic
Compensation: $7.00 / hour
DescriptionAbout the ClientOur client is a business intelligence and data management company that helps organizations optimize telecom and technology services. They deliver visibility into service inventories, contracts, and billing to reduce costs and improve performance. You will support their Business Intelligence team to ensure clean, complete, and timely service data that powers decision-making.\n
Why does this role exist?
This role exists to acquire, validate, and maintain mission-critical telecom and technology service data that feeds the client’s BI reporting and optimization programs. By conducting proactive outreach to service providers, remediating data issues, and processing service changes, the Technical Data Analyst ensures data accuracy and continuity across systems. The outcome is reliable, actionable information that supports cost control, contract management, and service lifecycle decisions.
The Impact you’ll makeData Acquisition & Provider Outreach\nContact telecom/technology service providers by phone and email to obtain missing details (e.g., term dates, circuit IDs, addresses, voice numbers, pricing).\nIdentify and reach the right provider contacts using provided lists, invoices, portals, and public resources.\nTrack outreach activity and document dates, contacts, and responses.\nData Validation & Record Remediation\nReview Excel/Smartsheet datasets to identify missing, inconsistent, or duplicate entries.\nValidate against invoices, provider communications, and internal documentation.\nStandardize formats (IDs, numbers, addresses, dates), merge/remove duplicates, and flag issues for BI review.\nData Entry & System Updates\nEnter newly gathered information into designated workbooks and Smartsheet project sheets.\nUpdate service attributes (location, provider, service type, contract status) following defined validation rules.\nDouble-check updates to maintain >99% accuracy.\nService Change & Disconnect Processing\nSubmit requests to move services to month-to-month terms or prevent auto-renewal as instructed.\nIdentify services for disconnection, initiate termination, track status, and confirm billing cessation.\nUpdate records with new statuses and effective dates.\nTask Management, Reporting & Collaboration\nMaintain clear task tracking and logs in Smartsheet for all outreach, updates, and service requests.\nProvide weekly summaries of progress, outstanding items, disconnect activity, and escalations.\nPartner with BI, Customer Success, and Account Services; respond to on-demand data requests (e.g., associated numbers, term dates, circuit data).\n
Skills, Knowledge and ExpertiseRequired:\n2+ years in technical support and/or data analysis within telecom/technology services or a closely related domain.\nAdvanced Excel skills (lookups, pivot tables, data validation, de-duplication) and accuracy working with large datasets.\nHands-on experience with Smartsheet or similar project/data tracking tools.\nProven experience conducting professional phone/email outreach and validating data against invoices/portals.\nExcellent written and verbal English communication; available to work Monday–Friday, 9:00 a.m.–5:00 p.m. CST.\nWFH Set-Up:\nComputer with at least 8GB RAM, an Intel i5 core processor/AMD Ryzen 5 Processor and up.\nInternet speed of at least 40MBPS\nHeadset with an extended mic that has noise cancellation and a webcam\nBack-up computer and internet connection\nQuiet, dedicated workspace at home\n\n\nYour Superpowers:\nTechnical: Excel power user; Smartsheet (or similar); data cleansing and normalization; record deduplication; invoice/portal navigation; use of LLM tools (e.g., ChatGPT) to draft emails or summarize documents.\nProcess & quality: Meticulous attention to detail, rigorous QA mindset, documentation discipline, strong follow-through.\nCommunication: Clear, professional phone/email presence; confident escalating issues with context and evidence.\nWork style: Analytical, self-directed, organized, and dependable; able to manage recurring tasks and deadlines.\nEthics: Reliable handling of confidential data and adherence to data privacy expectations.\nYou should apply if… \nYou love transforming incomplete, messy datasets into clean, reliable information that others can trust.\nYou are persistent and professional when chasing details from service providers and can keep meticulous records of every step.\nYou thrive in a structured, process-driven environment but communicate proactively when something needs clarification or escalation.\nYou value accuracy, accountability, and teamwork—and you’re comfortable working autonomously day to day.\n\nWhat to expect...
\nWork Setup:\nRemote position\nMust have a reliable internet connection and a quiet workspace\nRequired to provide own computer with Intel Core i5 or something similar or higher operating system\nWorking Hours:\n40 hours per week\nMonday to Friday 9 AM to 5 PM Central Time\nCompensation:\n$7 per hour\nNo benefits package included\n
Benefits
Confirmar seu email: Enviar Email