Skill diminta
Financial ReportingMetabaseSQL
Deskripsi
Requirements
- Education & Experience
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
- Minimum 2–4 years of experience developing BI dashboards or reporting solutions.
- Proven experience using Metabase for dashboard development and business reporting.
- Technical Skills
- Strong proficiency in SQL, including writing and optimizing complex analytical queries.
- Solid understanding of Data Warehouse concepts and analytical data structures.
- Experience working with ClickHouse or other analytical databases.
- Strong knowledge of data aggregation, filtering, grouping, joins, and calculated metrics.
- Understanding of dashboard design principles, data visualization best practices, and user experience.
- Experience performing data validation and reconciliation to ensure reporting accuracy.
- Ability to translate business requirements into effective dashboards and analytical reports.
- Familiarity with dashboard performance optimization and query tuning.
- Experience working within structured software development projects using defined timelines and requirements.
- Soft Skills
- Strong analytical thinking and problem-solving skills.
- Excellent attention to detail with a focus on data accuracy.
- Good communication and stakeholder collaboration skills.
- Ability to manage multiple reporting requests and meet project deadlines.
- Proactive mindset with a continuous improvement approach.
- Key Responsibilities
- Develop and maintain interactive dashboards and reports using Metabase.
- Write, optimize, and maintain complex SQL queries to support dashboard and reporting requirements.
- Connect and retrieve analytical data from ClickHouse using the native ClickHouse driver.
- Design and build various data visualizations, including tables, charts, KPI cards, trend analysis, comparisons, and summary reports.
- Create dashboards that align with business and financial reporting requirements.
- Implement filters, parameters, drill-down capabilities, and interactive dashboard features.
- Ensure dashboard data accurately reflects defined business rules and calculation logic.
- Perform data validation and reconciliation between dashboards and source data.
- Optimize dashboard performance through SQL tuning and visualization improvements.
- Troubleshoot issues related to queries, data accuracy, and dashboard visualizations.
- Collaborate with Backend/Nexus Developers, Data Engineers, and Business/Finance Analysts to deliver reliable reporting solutions.
- Support User Acceptance Testing (UAT), defect resolution, and dashboard deployment to production.