Security Data Engineer with experience using Power Automate, SQL, and PowerBI to build end-to-end automation routines as part of Data Fabric implementation. The role requires data analysis skills and the ability to work as part of a team.
The Information Security Data Engineer will develop, improve, and maintain executive security reporting workbooks and interactive PowerBI reports tied to security controls. Responsibilities include designing PowerBI report templates, enhancing data feeds for performance, and documenting procedures for report maintenance. Automated workflows and reports should be accessible online and offline, supporting regular monthly forums. The engineer will interpret reporting requests and translate them into actionable outputs.
This is a UK remote-based position reporting to the Lead Security Data Engineer.
Important Functions
1. Design, test, and implement Business Intelligence ETL solutions in PowerAutomate, PowerBI, PowerQuery, and Data Fabric, sourcing data from multiple inputs, including designing views and triggers used during ETL processes.
2. Analyze security metrics within PowerBI environment.
3. Interpret data in SQL, write queries, and understand stored procedures.
4. Familiarity with AWS environments for data storage in S3, Athena, RDS SQL.
5. Collaborate with systems analysts, engineers, and executives to update reports and maintain PowerBI automation routines, templates, and knowledge bases.
6. Ensure PowerBI and Power Automate reports utilize Access Control groups as defined in Active Directory.
7. Produce visually effective reports that allow users to filter and navigate data easily.
8. Knowledge of MS Data Fabric, Power Automate, MS Forms, PowerBI, MySQL, and AWS storage solutions.
9. Understand systems architecture and design Power Platform applications and reporting solutions with business rules and data validations.
10. Experience building standalone and integrated apps (e.g., Power Apps, SharePoint, SQL, Excel).
11. Experience with Data Fabric, Power Automate, PowerBI for enterprise reporting automation.
12. Proficient in creating and publishing interactive reports and dashboards, with report scheduling using MS Data Fabric & PowerQuery.
Company Description: Experian is a global data and technology company that helps redefine lending, prevent fraud, and provide insights across various industries. We invest in technology and talent to unlock data's power, operating in markets from financial services to healthcare and automotive. Listed on the London Stock Exchange (EXPN), with a team of 22,500 across 32 countries, headquartered in Dublin, Ireland. Learn more at experianplc.com.
Additional Information: Benefits include flexible work options, competitive compensation, pension, healthcare, sharesave scheme, 25 days annual leave, and more. Experian is an Equal Opportunity employer committed to diversity and inclusion. We welcome applicants requiring accommodations.
#J-18808-Ljbffr