Reporting & Data Analyst
The Reporting & Data Analyst will design, build, and maintain Power BI dashboards while ensuring data accuracy through rigorous SQL‑based extraction and validation. Over the first year they will transition from supporting the senior analyst to owning the end‑to‑end reporting and analytics function.
Skills required
About this role
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