Data Analyst / Data Engineer
Pavago · Remote · Egypt · 1mo ago
Data Analyst / Data Engineer – SQL, BI & Data Analytics | Remote
Position Type: Full-Time, Remote
Working Hours: U.S. Business Hours
About the Role
At Pavago, one of our clients is hiring a Data Analyst / Data Engineer to transform business data into reliable reporting, actionable insights, and scalable data systems.
Depending on your experience, this role may lean toward data analytics, business intelligence, data engineering, or a combination of these areas.
You’ll work with SQL, dashboards, reporting tools, databases, and data pipelines to help teams better understand performance and make informed business decisions.
This role is ideal for someone who combines strong technical and analytical skills with the ability to explain data clearly to non-technical stakeholders.
What You’ll Own
Data Analysis & Business Insights
- Collect, clean, organize, and analyze business data
- Identify trends, patterns, anomalies, and performance drivers
- Translate raw data into meaningful business insights
- Investigate data questions and provide evidence-based recommendations
- Support stakeholders with ad hoc analysis and recurring reporting needs
SQL & Data Management
- Write, maintain, and optimize SQL queries
- Extract and combine data from multiple sources
- Work with relational databases and structured datasets
- Validate datasets for completeness and accuracy
- Troubleshoot inconsistencies across reporting and source systems
Dashboards & Business Intelligence
- Develop and maintain dashboards using tools such as:
- Power BI
- Tableau
- Looker
- Similar BI platforms
- Build recurring reports for business stakeholders
- Create clear visualizations that make complex information easier to understand
- Maintain consistent definitions and reporting logic across dashboards
Data Pipelines & Integrations
- Build or maintain data pipelines and integrations
- Help connect business systems and reporting environments
- Support reliable movement of data between platforms
- Troubleshoot pipeline and integration issues
- Improve the scalability and reliability of data workflows
Reporting Automation
- Automate recurring reporting and data preparation processes
- Reduce manual spreadsheet and reporting work
- Build repeatable workflows for common reporting requirements
- Identify opportunities to improve reporting efficiency
- Help ensure stakeholders have timely access to reliable information
Data Quality & Reliability
- Monitor and improve data accuracy
- Identify missing, duplicated, or inconsistent information
- Validate reporting outputs against source data
- Improve processes that support reliable reporting
- Maintain organized documentation around reporting and data workflows
Stakeholder Collaboration
- Work with business stakeholders to understand reporting requirements
- Translate business questions into analytical requirements
- Present findings clearly to technical and non-technical audiences
- Explain trends, metrics, and recommendations in practical business terms
- Collaborate across teams to improve data accessibility and reporting
Requirements
- 2+ years of experience in data analytics, business intelligence, data engineering, or a related role
- Strong hands-on SQL skills
- Experience with Excel and/or Google Sheets
- Experience using at least one BI or visualization platform such as:
- Power BI
- Tableau
- Looker
- Similar tools
- Familiarity with databases and data warehouses
- Strong analytical and problem-solving skills
- Ability to identify patterns and insights within complex datasets
- Strong attention to data accuracy and reporting reliability
- Ability to communicate technical findings clearly to non-technical stakeholders
- Professional working English
- Comfortable working independently in a remote environment
Nice to Have
- Experience with Python for data analysis or automation
- Experience building or maintaining data pipelines
- Experience integrating data from multiple systems
- Familiarity with cloud-based databases or data warehouses
- Experience automating recurring reporting workflows
- Experience with data modeling and reporting architecture
- Experience supporting business intelligence or executive reporting
Tools & Technologies
SQL | Excel | Google Sheets | Power BI | Tableau | Looker | Python | Databases | Data Warehouses | Data Pipelines | BI & Reporting Tools
What Makes You a Strong Fit
You’ll likely thrive in this role if you:
- Enjoy turning messy data into clear, reliable information
- Are comfortable working deeply with SQL and datasets
- Question inconsistencies instead of accepting numbers at face value
- Can move between technical analysis and business conversations
- Look for opportunities to automate repetitive reporting
- Care about data accuracy and reporting reliability
- Can explain complex findings in simple, actionable terms
- Take ownership of analytical problems from question through insight
What a Typical Day Looks Like
Your day may include writing SQL queries, cleaning datasets, updating dashboards, investigating business trends, or automating a recurring report.
Depending on the project, you may also maintain data pipelines, troubleshoot reporting inconsistencies, work with stakeholders to define new metrics, or present findings to business leaders.
In short: you turn company data into reliable reporting, useful insights, and better business decisions.
Key Metrics for Success
- Accuracy and reliability of reporting
- Quality and usability of dashboards
- Timely delivery of recurring reports and analysis
- SQL query and reporting efficiency
- Reduction in manual reporting processes
- Reliability of data pipelines and integrations
- Improvement in overall data quality
- Stakeholder confidence in reporting and insights
Interview Process
- Initial Application
- Spark Hire One-Way Video Interview
- Video Interview with Pavago Recruiter
- Data / Technical Interview
- Client Interview
- Offer & Onboarding
Spark Hire Video Interview – Required
As part of the application process, all candidates are required to complete a one-way video interview through Spark Hire.
After completing the first step of your application, you’ll receive a Spark Hire invitation by email with instructions to record and submit your video responses.
Completion of the Spark Hire video is required to be considered for the next stage. Please check your inbox as well as your spam or junk folder for the invitation.
Apply Now
If you have experience with SQL, data analytics, business intelligence, dashboards, reporting, or data engineering and enjoy turning complex data into clear business insights, we’d love to hear from you.
Apply today and help build reliable data systems that support smarter business decisions.
#DataAnalyst #DataEngineer #BusinessIntelligence #SQL #PowerBI #Tableau #Looker #Python #DataAnalytics #DataEngineering #RemoteJobs #RemoteWork
#LI-AG1