Data Analyst
Somewhere
🇿🇦 Hirezar Summary for South African Applicants
This fully remote full time position at Somewhere is open to applicants from South Africa. The estimated monthly salary is R27,750 – R64,750 ZAR. This role is suited for mid-level professionals. As a remote position, you can work from anywhere in South Africa — whether you're based in Johannesburg, Cape Town, Durban, or a smaller town.
Job Description
Data Analyst (Excel, VBA & Automation Focus)
Location:Fully RemoteTime Zone Requirement:Must have overlap with U.S. business hours (MST preferred)Department:Data / AnalyticsReports To:Head of Data / Operations
About the Company
We are a data-driven company focused on helping businesses maximize profitability through advanced reporting, data visualization, and process automation.
Our work centers on transforming raw data into actionable insights, building efficient reporting systems, and automating manual processes to improve operational performance. We partner with clients across industries to streamline workflows, reduce inefficiencies, and enable smarter, faster decision-making.
We operate in a highly analytical, fast-paced environment where accuracy, efficiency, and innovation are critical.
We pride ourselves on:
* Delivering measurable, profit-driven outcomes
* Building scalable data and automation solutions
* Turning complex data into clear, actionable insights
* Maintaining high standards of accuracy and reliability
About the Role
We are seeking a highly skilled and detail-oriented Data Analyst with strong expertise in Excel, VBA, and Office Scripts to support data analysis, reporting, and automation initiatives.
This role is heavily focused on building and optimizing data workflows within Excel, creating automated reporting solutions, and improving operational efficiency through scripting and process automation.
This position is ideal for someone who enjoys working deeply with data, building systems, and finding ways to eliminate manual work through smart automation.
What You’ll Do
Data Analysis & Reporting
* Analyze large datasets to identify trends, insights, and opportunities
* Build and maintain detailed reports and dashboards in Excel
* Translate complex data into clear, actionable insights for stakeholders
* Ensure data accuracy and consistency across all reporting outputs
Excel & Automation Development
* Develop advanced Excel models using formulas, pivot tables, and structured data
* Write and maintain VBA scripts to automate repetitive tasks and workflows
* Build Office Scripts to streamline processes within Excel Online
* Continuously improve existing tools for performance, scalability, and usability
Process Optimization
* Identify inefficiencies in current workflows and propose automation solutions
* Design and implement systems to reduce manual data handling
* Improve reporting speed, accuracy, and accessibility
* Collaborate with stakeholders to align automation with business needs
Data Management
* Clean, organize, and structure data from multiple sources
* Ensure proper documentation and version control of data processes
* Maintain data integrity and troubleshoot inconsistencies
Cross-Functional Collaboration
* Work closely with operations and leadership teams to understand data needs
* Communicate findings and recommendations clearly and effectively
* Support ad hoc data requests and business analysis needs
What You Bring
Required Experience
* 2–8 years of experience in data analysis, business analysis, or similar roles
* Advanced proficiency in Microsoft Excel (required)
* Strong experience with VBA (Visual Basic for Applications)
* Experience building and maintaining Office Scripts
* Proven ability to automate workflows and improve operational efficiency
* Strong analytical and problem-solving skills
* High attention to detail and data accuracy
* Excellent written and verbal English communication skills
Technical Skills
* Microsoft Excel (advanced level – formulas, pivot tables, data modeling)
* VBA (required)
* Office Scripts (required)
* Data cleaning and transformation techniques
* Familiarity with data visualization best practices
* Comfortable working with large datasets
Nice to Have
* Experience with Power BI, Tableau, or other visualization tools
* Familiarity with SQL or databases
* Experience in process automation or operations optimization
* Background working with U.S.-based companies
* Experience integrating data from multiple systems
Technical Requirements
* Reliable high-speed internet connection
* Modern computer capable of handling large datasets and multiple applications
* Ability to run Excel efficiently with advanced models and scripts
Work Environment
* Fully remote role
* Fast-paced, analytical, and results-driven environment
* High focus on accuracy, efficiency, and problem-solving
* Collaborative and team-oriented culture
Schedule
Monday – FridayU.S. business hours (EST preferred overlap)(Exact schedule to be confirmed based on business needs)
Who This Role is Ideal For
* Detail-oriented and analytical professionals
* Excel power users who enjoy building systems and automations
* Problem-solvers who look for efficiency improvements
* Individuals who enjoy working with data to drive business outcomes
* Self-starters who can manage projects independently
What This Role Is Not
* Not a purely reporting role — automation a
Tips for South African Applicants
Timezone Advantage
South Africa (SAST, UTC+2) overlaps well with European business hours and has a few hours of overlap with US East Coast. Mention your timezone flexibility in your application.
Salary in Context
At R27,750/month, this role is on par with the average South African remote salary. The USD equivalent ($1,500/mo) benefits from the favourable exchange rate.
Application Tips
Tailor your CV to international standards — use a clean format, highlight remote work experience, and include your English proficiency. Many SA applicants succeed by emphasising their strong work ethic and cultural adaptability.
Load Shedding Preparedness
If you're applying for a remote role, having a backup power solution (UPS, inverter, or generator) and mobile data as a backup internet connection shows employers you're prepared for South Africa's infrastructure challenges.
About Somewhere
Somewhere is a company in the Recruitment & Staffing industry that hires remote workers from South Africa. They currently have 609 open positions on Hirezar. View all Somewhere jobs →