Job Description

Senior Power BI Analyst
Division
Deutsche Borse AG, Chief Information Officer/Chief Operating Officer (CIO/COO), Chief Technology Officer (CTO), Plan & Control
Field of activity:
The Deutsche Borse CTO develops and runs the groupwide Information Technology (IT) infrastructure, develops and operates innovative IT products and offers services to the rest of the Group upon which they can build. The CTO area plays a significant role in the achieving the Groups strategic goals by leading transformation and supporting a stable operating environment.
The Plan & Control unit supplies reliable management information to the CTO and enables the other delivery units within the area to focus on their core activities by supplying central administration and coordination within the area. The successful candidate will support the Plan & Control unit in carrying out its responsibilities.
Your area of work:
The Deutsche Borse CTO area develops and runs the groupwide Information Communication Technology (ICT) infrastructure, develops and operates innovative IT products and offers services to the rest of the Group upon which they can build. The CTO area plays a significant role in achieving the Groups strategic goals by leading transformation and supporting a stable operating environment.
The Plan & Control unit supplies reliable management information to the CTO and enables the other delivery units within the area to focus on their core activities by supplying central administration and coordination within the area. The successful candidate will support the Plan & Control unit in carrying out its responsibilities.
Your responsibilities:

• Design and develop BI solutions: Translate business requirements into technical specifications for BI reports, dashboards, and analytical tools, ensuring alignment with overall data architecture and governance.
• Implement and maintain BI infrastructure: Oversee the implementation, configuration, and ongoing maintenance of data pipelines ensuring system stability, performance, and security.
• Conduct data analysis and validation: Perform rigorous data analysis to identify trends, patterns, and insights, validating data accuracy, completeness, and consistency across different sources.
• Develop and execute test plans: Create comprehensive test plans and test cases for BI solutions, ensuring data quality, report accuracy, and functionality across various scenarios and user groups.
• Collaborate with stakeholders: Work closely with business units, IT teams, and data governance teams to gather requirements, provide support, and ensure effective communication and collaboration throughout the BI development lifecycle.
• Document and train: Develop comprehensive documentation for BI solutions, including user manuals, technical specifications, and training materials for end-users and support teams.
• Support the collection, consolidation, analysis and reporting of key performance indicators from across Deutsche Borse Group.

• Power BI Desktop Proficiency: Mastery in data modeling, creating relationships between tables, using DAX for calculated columns and measures, building interactive visualizations, and designing reports and dashboards.
• Data Source Connectivity: Experience connecting to various data sources, including databases (SQL Server, Oracle, etc.), cloud platforms (Azure, GCP), flat files (CSV, Excel), and APIs.
• ETL/Data Wrangling: Skills in data transformation and cleaning is crucial.
• DAX (Data Analysis Expressions): Demonstrable expertise in writing complex DAX expressions for calculations, aggregations, and filtering data is essential.
• Problem-Solving: Ability to troubleshoot issues, identify root causes, and implement solutions related to data quality, report performance, or other BI-related challenges.
• Communication: Excellent written and verbal communication skills to effectively interact with technical and non-technical stakeholders. Ability to explain complex technical concepts in a clear and concise manner.
• Collaboration: Ability to work effectively in a team environment and collaborate with other developers, business analysts, and end-users.
• Time Management and Prioritization: Ability to manage multiple tasks and prioritize workload effectively to meet deadlines.
• Expertise working with office applications (Word, SharePoint, Excel, etc.).
• Proficiency in written and spoken English, German skills a benefit.
• A relevant degree, or equivalent, in business, business administration, finance, accounting, communications or IT.