Abacus Finance and Power BI Specialist 80-100% (f/m/d)

• Abacus System Management: Administer, maintain, and optimize the Abacus regulatory reporting system, ensuring data accuracy and compliance with relevant financial regulations (e.g., Basel, CRR).
• Data Extraction and Transformation: Extract, transform, and load financial data from various source systems into Abacus and other reporting platforms.
• Report Generation and Validation: Generate statutory and internal financial reports using Abacus and MS PowerBI, ensuring their accuracy, completeness, and timely submission. Perform thorough data validation and reconciliation.
• Power BI Dashboard Development: Design, develop, and maintain interactive Power BI dashboards and reports to visualize key financial performance indicators, trends, and regulatory data.
• Data Analysis and Insights: Conduct in-depth financial data analysis, identify key trends, anomalies, and provide actionable insights to support decision-making.
• Process Improvement: Proactively identify and implement improvements in data management, reporting processes, and system functionalities related to Abacus and Power BI.
• Stakeholder Collaboration: Collaborate with finance, risk, IT, and other relevant departments to understand reporting requirements and deliver effective solutions.
• Documentation: Maintain comprehensive documentation for Abacus configurations, Power BI reports, data models, and reporting processes.
• User Support and Training: Provide support and training to end-users on Abacus and Power BI functionalities.

• Bachelor's degree in Finance, Accounting, Business Information Systems, or a related quantitative field. Master's degree is a plus.

• Minimum of 3-5 years of experience working with financial data, reporting, and analysis in the financial services industry.
• Proven hands-on experience with Abacus is essential.
• Strong proficiency in developing and maintaining Power BI dashboards, including data modeling (DAX), report creation, and data visualization best practices.
• Experience with SQL for data extraction and manipulation.

• Expertise in Abacus reporting software
• Advanced proficiency in Microsoft Power BI (Power Query, DAX, data modeling)
• Solid understanding of relational databases and SQL.
• Familiarity with other data visualization tools (e.g., Tableau, QlikView) is a plus.
• Proficiency in Microsoft Excel (advanced functions, pivot tables).

• Strong understanding of financial products, accounting principles (IFRS/GAAP), and financial reporting standards.
• Knowledge of banking regulations (e.g., Basel III, CRR) is highly desirable.

• Excellent analytical and problem-solving skills with a keen eye for detail.
• Strong communication and interpersonal skills, with the ability to explain complex data and technical concepts to non-technical stakeholders.
• Ability to work independently and as part of a team in a fast-paced environment.
• Proactive, self-motivated, and results-oriented with a strong commitment to quality and accuracy.
• Fluency in English is required; German language skills are a significant advantage.

LGT Bank