Key Responsibilities
Analytics Dashboarding
- Write, optimize, and maintain complex SQL queries to support real-time analytics dashboards and reporting solutions.
- Conduct data validation and troubleshoot data accuracy and integrity issues.
Cross-Functional Collaboration
- Partner with Product Managers and Solution Architects to identify analytics requirements and define project scope.
- Work closely with Data Engineers to ensure data accessibility, reliability, and alignment with business needs.
Data Management & Delivery
- Gather, document, and prioritize analytics requirements from stakeholders.
- Define data requirements for pipelines to enable end-to-end analytics delivery.
Performance Optimization
- Implement best practices in query optimization for large and complex datasets.
- Monitor and improve the performance of analytical processes and data models.
Data Quality & Governance
- Establish and maintain data quality metrics and governance standards.
- Identify gaps in data and work with engineering teams to implement corrective actions.
Reporting & Insights
- Develop and maintain dashboards, reports, and ad hoc analyses to inform business decisions.
- Translate analytical findings into actionable recommendations and present insights to stakeholders.