At a Glance
- Tasks: Develop and enhance reporting solutions using SAS and SQL for financial and regulatory outputs.
- Company: Join Aztec, a dynamic company focused on operational excellence and client partnerships.
- Benefits: Gain professional training, career development, and exposure to modern reporting technologies.
- Why this job: Make an impact by ensuring accurate data flows and supporting innovative reporting solutions.
- Qualifications: 3-5 years in reporting or data engineering, strong SAS and SQL skills required.
- Other info: Collaborative culture with opportunities for growth and learning in a supportive environment.
The predicted salary is between 36000 - 60000 £ per year.
At Aztec, we provide talented and dynamic individuals with the opportunity to build a rewarding career. We’re an ambitious company, committed to building long-term partnerships with our clients and delivering operational excellence at every stage of their fund’s lifecycle. Our culture is what makes us a standout place to work. Our people are at the heart of our business: putting clients first; delivering service excellence; working as one team; building lasting connections and embodying our values and purpose. Join our journey and discover what makes us the bright alternative.
The Reporting and Data Specialist will play a central role in the development, enhancement, and operational support of eFront Invest reporting solutions across the group. This role focuses on building and maintaining SAS and SQL‑driven report outputs, supporting structured data integrations, and ensuring high‑quality, well‑governed data flows used across client reporting, regulatory submissions, and internal analytics. You will collaborate closely with the wider Markets Technology team, Operational support, Client-facing teams, and integration specialists to ensure reports, data pipelines, and downstream data processors receive accurate, validated, and timely information. With growing demand for scalable and automated data integrations, experience with structured data flows, CSV/XML outputs, and integration platforms is highly valuable.
Key Responsibilities
- Build, maintain, and enhance eFront Invest reporting solutions using SAS and SQL for financial reporting, investor reporting, regulatory outputs, and internal analysis.
- Develop structured output formats such as XML, CSV, or flat-file extracts for downstream systems.
- Translate reporting requirements into SAS/SQL logic and reusable code modules, ensuring scalability and consistency.
- Support and enhance data feeds between eFront Invest, data warehouses, and external systems.
- Troubleshoot data-flow issues related to ETL orchestration, transformation rules, and scheduling.
- Monitor and manage integrations using platforms such as MuleSoft, SSIS, and internal automation tooling.
- Maintain data lineage, mapping documentation, and transformation logic.
- Resolve reporting errors, identify data inconsistencies, and workflow issues in line with SLAs.
- Perform root‑cause analysis and implement remediation steps to prevent recurrence.
- Maintain documentation, test evidence, and approvals aligned to change management, audit, and ISAE 3402 standards.
- Identify opportunities to automate manual steps and improve end‑to‑end reporting processes.
- Collaborate with financial reporting, fund accounting, and technology teams to streamline reporting cycles.
- Provide day‑to‑day user support and contribute to internal knowledge‑base material.
- Proactively escalate systemic issues and recommend process improvements.
Required
- 3–5 years’ experience in reporting, data engineering, structured data flow engineering or financial systems support, ideally within fund administration or financial reporting.
- Strong hands-on experience with SAS and SQL, including data transformation, validation logic, and optimisation.
- Knowledge of private‑markets platforms is essential, preferably eFront Invest.
- Solid understanding of fund structures and financial statement components.
- Strong Excel and data‑validation skills, with a focus on accuracy and data quality.
- Clear communicator, capable of supporting users and working effectively with Operational Support, Client-Facing, and Onboarding teams.
- Bachelor’s degree in Information Systems, Data/Computer Science, Finance or related fields.
Desirable
- Experience with DevOps Boards, Agile development workflows, and managing work through sprints.
- Familiarity with GIT repositories for version control and collaborative development.
- Experience producing structured data outputs such as CSV or XML.
- Exposure to integration tools such as MuleSoft, SSIS, Alteryx, or other ETL/orchestration platforms.
- Knowledge of regulatory reporting automation or private‑markets data flows.
- Awareness of different development methodologies, with a strong preference for Agile as the strategic direction.
Career Development & Opportunity
You will gain exposure to enterprise data platforms, integration patterns, and modern reporting technologies. Aztec will provide the training, both in-house for relevant technical knowledge and also professional qualifications to enhance your professional development. You will need to be quick to learn new systems and great with people, as close working relationships between our colleagues and clients is at the heart of what we do.
Reporting and Data Specialist employer: Aztec Group
Contact Detail:
Aztec Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Reporting and Data Specialist
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect with potential colleagues on LinkedIn. We all know that sometimes it’s not just what you know, but who you know that can help you land that Reporting and Data Specialist role.
✨Tip Number 2
Prepare for those interviews by brushing up on your SAS and SQL skills. We recommend doing some mock interviews with friends or using online platforms to practice common questions related to data reporting and integrations. The more confident you are, the better!
✨Tip Number 3
Showcase your problem-solving skills! Be ready to discuss how you've tackled data inconsistencies or reporting errors in the past. We want to see your thought process and how you approach challenges, especially in a fast-paced environment like Aztec.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who take the initiative to engage directly with us. Let’s make this journey together!
We think you need these skills to ace Reporting and Data Specialist
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Reporting and Data Specialist role. Highlight your experience with SAS, SQL, and any relevant data integration tools. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background makes you a great fit. Don’t forget to mention your understanding of fund structures and financial reporting.
Showcase Your Problem-Solving Skills: In your application, share examples of how you've tackled data inconsistencies or reporting errors in the past. We love candidates who can demonstrate their analytical thinking and proactive approach to problem-solving.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at Aztec Group
✨Know Your SAS and SQL Inside Out
Make sure you brush up on your SAS and SQL skills before the interview. Be prepared to discuss specific projects where you've used these tools, and think about how you can demonstrate your ability to translate reporting requirements into effective code.
✨Understand Data Integration Tools
Familiarise yourself with data integration platforms like MuleSoft and SSIS. Be ready to talk about any experience you have with ETL processes and how you've managed data flows in previous roles. This will show that you understand the technical aspects of the job.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've resolved reporting errors or data inconsistencies in the past. Highlight your analytical skills and your approach to root-cause analysis, as this is crucial for the Reporting and Data Specialist role.
✨Communicate Clearly and Collaboratively
Since collaboration is key in this role, practice articulating your thoughts clearly. Think of instances where you've worked with cross-functional teams and how you contributed to streamlining processes. This will demonstrate your ability to work effectively with others.