Reporting & Data Analyst
VBP City of Cebu, Cebu, Philippines
Financial Services · 2-10 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
The Reporting and Data Analyst will build, maintain, and enhance Power BI dashboards while ensuring data accuracy through SQL querying and validation. The role involves collaborating with stakeholders to gather requirements and providing actionable insights to support business decision-making.
What they look for
Requirements
Candidates must have at least 4 years of experience in data analysis or business intelligence with strong proficiency in SQL and Power BI. The role requires excellent problem-solving skills, experience with data reconciliation, and the ability to translate business needs into technical solutions.
Benefits
Full description
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.
- 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.
- 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
Similar roles
-
Data Analyst
VML Johannesburg, Gauteng, South Africa
-
Senior Data Analyst
VML Johannesburg, Gauteng, South Africa
-
Data Analyst
Aon Corporation Kuala Lumpur, Malaysia
-
Analytics Engineer, Commercial Systems
Bask Health United States
-
GTM Data Analyst
Bask Health United States
-
Data Analyst
Auxiant Cedar Rapids, Iowa, United States