Data Analyst / Data Engineer

🏢 Pavago
📍 EgyptRemote
📅 Posted: 1w ago🔄 Updated: 1w ago
CV%
✨ AI Summary
Pavago is seeking a Data Analyst / Data Engineer for a full-time, remote position working U.S. business hours. This role involves transforming business data into reliable reporting, actionable insights, and scalable data systems, with a focus on SQL, BI tools, and data analytics. Responsibilities include data analysis, SQL query writing, dashboard development, data pipeline maintenance, reporting automation, and ensuring data quality. The ideal candidate has strong technical and analytical skills, excellent communication abilities, and enjoys turning complex data into clear, actionable information. Experience with Python for data analysis or automation, data pipelines, and cloud databases is a plus.
Required Skills
Information Technology
SQLPower BITableauLookerDatabase DesignData Warehouse
Productivity & Workplace Tools
ExcelGoogle Sheets
Soft Skills & Professional Competencies
Analytical SkillsProblem SolvingCommunication
Other
Data accuracyReporting reliabilityEnglish
Nice to have:
Information Technology
PythonData PipelinesData IntegrationData WarehouseData Modeling
Other
Cloud databasesReporting architecture
Engineering, Construction & Trades
Automation
Description
Data Analyst / Data Engineer – SQL, BI & Data Analytics | RemotePosition Type: Full-Time, Remote Working Hours: U.S. Business HoursAbout the RoleAt 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 OwnData Analysis & Business InsightsCollect, clean, organize, and analyze business dataIdentify trends, patterns, anomalies, and performance driversTranslate raw data into meaningful business insightsInvestigate data questions and provide evidence-based recommendationsSupport stakeholders with ad hoc analysis and recurring reporting needsSQL & Data ManagementWrite, maintain, and optimize SQL queriesExtract and combine data from multiple sourcesWork with relational databases and structured datasetsValidate datasets for completeness and accuracyTroubleshoot inconsistencies across reporting and source systemsDashboards & Business IntelligenceDevelop and maintain dashboards using tools such as:Power BITableauLookerSimilar BI platformsBuild recurring reports for business stakeholdersCreate clear visualizations that make complex information easier to understandMaintain consistent definitions and reporting logic across dashboardsData Pipelines & IntegrationsBuild or maintain data pipelines and integrationsHelp connect business systems and reporting environmentsSupport reliable movement of data between platformsTroubleshoot pipeline and integration issuesImprove the scalability and reliability of data workflowsReporting AutomationAutomate recurring reporting and data preparation processesReduce manual spreadsheet and reporting workBuild repeatable workflows for common reporting requirementsIdentify opportunities to improve reporting efficiencyHelp ensure stakeholders have timely access to reliable informationData Quality & ReliabilityMonitor and improve data accuracyIdentify missing, duplicated, or inconsistent informationValidate reporting outputs against source dataImprove processes that support reliable reportingMaintain organized documentation around reporting and data workflowsStakeholder CollaborationWork with business stakeholders to understand reporting requirementsTranslate business questions into analytical requirementsPresent findings clearly to technical and non-technical audiencesExplain trends, metrics, and recommendations in practical business termsCollaborate across teams to improve data accessibility and reportingRequirements2+ years of experience in data analytics, business intelligence, data engineering, or a related roleStrong hands-on SQL skillsExperience with Excel and/or Google SheetsExperience using at least one BI or visualization platform such as:Power BITableauLookerSimilar toolsFamiliarity with databases and data warehousesStrong analytical and problem-solving skillsAbility to identify patterns and insights within complex datasetsStrong attention to data accuracy and reporting reliabilityAbility to communicate technical findings clearly to non-technical stakeholdersProfessional working EnglishComfortable working independently in a remote environmentNice to HaveExperience with Python for data analysis or automationExperience building or maintaining data pipelinesExperience integrating data from multiple systemsFamiliarity with cloud-based databases or data warehousesExperience automating recurring reporting workflowsExperience with data modeling and reporting architectureExperience supporting business intelligence or executive reportingTools & TechnologiesSQL | Excel | Google Sheets | Power BI | Tableau | Looker | Python | Databases | Data Warehouses | Data Pipelines | BI & Reporting ToolsWhat Makes You a Strong FitYou’ll likely thrive in this role if you:Enjoy turning messy data into clear, reliable informationAre comfortable working deeply with SQL and datasetsQuestion inconsistencies instead of accepting numbers at face valueCan move between technical analysis and business conversationsLook for opportunities to automate repetitive reportingCare about data accuracy and reporting reliabilityCan explain complex findings in simple, actionable termsTake ownership of analytical problems from question through insightWhat a Typical Day Looks LikeYour 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 SuccessAccuracy and reliability of reportingQuality and usability of dashboardsTimely delivery of recurring reports and analysisSQL query and reporting efficiencyReduction in manual reporting processesReliability of data pipelines and integrationsImprovement in overall data qualityStakeholder confidence in reporting and insightsInterview ProcessInitial ApplicationSpark Hire One-Way Video InterviewVideo Interview with Pavago RecruiterData / Technical InterviewClient InterviewOffer & OnboardingSpark Hire Video Interview – RequiredAs 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 NowIf 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
✨ Premium Match Details
Deep-dive CV analysis, customized Cover Letters, and Interview prep!
📊 Match Analysis
Insights against your active CV
📊
Personalized Match Analysis
Upload your CV to see exact matching percentages, detailed skills mapping, and gap analysis for this role.
🎯 Overalli74%
⚡ Skillsi85%
View Breakdown
Ontology Match: 85.0
Matched:✓ Requirements Matching✓ Ontology Skills Mapping
📜 Eligibilityi49%
View Breakdown
Local: 19600%
🏗️ Career Fiti91%
View Breakdown
Seniority: 91.0
📋 Requirementsi67%
View Breakdown
Domain: 67.0
🔥 Motivationi78%
View Breakdown
Title Fit: 78.00