Information Security Data Engineer

Summary

Join Experian's Global Security Office as an Information Security Data Engineer to build end-to-end automation routines for its Data Fabric implementation using Power Automate, SQL, and PowerBI. Develop, improve, and maintain executive security reporting workbooks and interactive PowerBI reporting. Design PowerBI reporting templates, improve data feeds, and document reporting procedures. This UK-based remote position requires expertise in data analysis and teamwork. You will interpret reporting requests and create applicable outputs, ensuring reports meet agreed visual standards and are user-friendly. The role involves collaboration with various teams to update reporting and maintain PowerBI automation routines.

Requirements

• Knowledge of MS Data Fabric, Power Automate, MS Forms, PowerBI, MySQL and AWS Environments for data storage in S3 i.e. Athena, RDS SWL
• An understanding of systems architecture and designing Power Platform Applications and reporting solutions applying business rules and data validations
• Experience building both standalone and integrated apps (e.g. with Power Apps, SharePoint, SQL, Excel)
• Experience using Data Fabric, Power Automate, PowerBI for the creation and automation of enterprise scale reporting
• Proficient in building, publishing customized interactive reports and dashboards, report scheduling using MS Data Fabric & PowerQuery
• Proficient in building, publishing customized interactive reports and dashboards, report scheduling using Data Fabric

Responsibilities

• Design, test, and implement critical Business Intelligence ETL solutions in PowerAutomate, PowerBI, PowerQuery and Data Fabric, sourcing data from multiple inputs to include the design, modelling of views, and triggers used during the ETL process
• Work within the metrics framework to analyze security reporting within PowerBi Environment
• Interpret data in SQL, write queries, understand stored procedures
• Familiarity with AWS Environments for data storage in S3, Athena, RDS SWL
• Confer with systems analysts, engineers, and executive partners to update reporting and maintain PowerBi Automation Routines, Templates and internal knowledgebases
• Ensure PowerBI and Power Automate Report Development uses Access Control groupings as defined in Active Directory
• Produce all reports to agreed standards visually and ensure the content is suitable for users to filter and navigate through

Benefits

• Flexible work environment, working hybrid or in the office if you prefer
• Great compensation package and discretionary bonus plan
• Core benefits include pension, bupa healthcare, sharesave scheme and more
• 25 days annual leave with 8 bank holidays and 3 volunteering days. You can purchase additional annual leave