Sobre este puesto de Reporting & Data Analyst en VBP
Overview of the Role:
The Reporting and Data Analyst plays a key role in delivering reporting and analytical support for Captegra. Initially, the position works closely with the Senior Data Business Analyst to gain a deep understanding of the business, platform, and data environment while building reports, validating data, and resolving data-related issues. Over the first 12 months, the role progressively assumes greater responsibility, ultimately becoming the primary owner of reporting and analytics function.
Key Responsibilities:
- Build, test, maintain, and enhance Power BI reports and dashboards, ensuring the delivery of accurate, reliable, and actionable business insights.
- Write and optimize SQL queries to extract, analyze, validate, and troubleshoot data from multiple sources, including Microsoft Fabric.
- Perform data validation and reconciliation activities to ensure report outputs align with source system data and investigate any discrepancies or variances.
- Engage with business stakeholders to gather, clarify, and document reporting requirements, ensuring a clear understanding of business objectives, KPIs, filters, and reporting audiences.
- Translate business and reporting requirements into technical data requirements and reporting solutions that support decision-making and operational efficiency.
- Identify, investigate, and resolve data quality issues, working closely with relevant teams to ensure data accuracy, consistency, and integrity.
- Monitor, troubleshoot, and resolve reporting issues, including report failures, refresh errors, performance concerns, and unexpected reporting outcomes.
- Deliver recurring operational reports and respond to ad hoc reporting and analytical requests in a timely and accurate manner.
- Maintain reporting documentation, including KPI definitions, data dictionaries, report specifications, and operational runbooks to support governance and consistency.
- Collaborate with internal teams to evaluate the impact of system changes, releases, and enhancements on reporting processes and data outputs.
- Proactively recommend reporting improvements, dashboard enhancements, and process efficiencies based on user feedback, report usage trends, and business needs.
- Support a culture of data-driven decision-making by providing meaningful insights and ensuring stakeholders have access to trusted and well-governed reporting assets.
- Proven hands-on experience in Power BI report and dashboard development.
- Strong proficiency in SQL querying, data analysis, and data validation.
- Experience reconciling data and investigating reporting discrepancies.
- Ability to gather and translate business requirements into reporting and analytics solutions.
- Strong analytical, problem-solving, and troubleshooting capabilities.
- Excellent stakeholder management and communication skills, with the ability to work effectively with both technical and non-technical audiences.
Requirements
- Minimum 4 years of experience in Data Analysis, Reporting, or Business Intelligence roles.
- Strong hands-on experience with SQL, including joins, aggregations, and data analysis.
- Proven expertise in building and maintaining Power BI dashboards and reports, including data modeling and DAX.
- Advanced Excel skills for data validation, analysis, and reconciliation.
- Solid understanding of relational databases, data relationships, and data structures.
- Experience investigating and resolving data quality and reporting discrepancies.
- Ability to work with REST APIs and interpret JSON data.
- Strong communication and documentation skills, with experience gathering and clarifying stakeholder requirements.
- Experience with Salesforce reporting and data structures.
- Exposure to Microsoft Fabric or Azure Data Services.
- Experience supporting Australian, UK, or US-based teams.
- Background working with financial services data.
Benefits
- 500K per incident HMO coverage + Dental & Optical benefits
- 2-week paid Christmas vacation
- Electricity & Data subsidies
- 25K Educational Assistance
- Training and equipment will be provided
- Fixed Schedule of Mon-Fri from 7 AM to 4 PM