Senior Data & Reporting Analyst
Company:Employee Referrals
Location:South Africa
Languages:English
Seniority level:Senior, 5+ years
Experience:5+ years
Skills:
PostgreSQLSQLBusiness IntelligenceData AnalysisData MiningMicrosoft Power BIMicrosoft SQL ServerMySQLJiraTableauMicrosoft ExcelAgile methodologiesData modeling
Requirements:
5+ years experience with data and/or systems analysis experience, at least some within a formal BI environment. University degree in Business, Finance, Mathematics, Statistics, Informatics or equivalent industry training and experience. Proven ability in analytics, business process analysis and presenting / communicating recommendations. Real-world understanding of data processing and storage. Relational database management systems experience (e.g., MySQL, PostgreSQL, Redshift, SQL Server). Proven ability to write complex data queries. Ability to self-discover and understand complex data domains. Advanced Excel skills. Understanding of Data Governance, Agile methodologies and QA standards. Critical thinking under pressure with ambiguity and tight deadlines. Experience working with Github and JIRA or similar task or project management tools.
Responsibilities:
Work closely with stakeholders to perform investigations on data warehouse and operational data stores. Understand end-to-end architecture of functional domains and deep dive into data to resolve issues or perform ad-hoc extracts. Perform quality assurance on data sets and pipelines to discover inconsistencies and anomalies. Use advanced data query and discovery skills for ad hoc analysis. Clearly define reporting requirements to BI Developers for build.
