Company Description
Experian is a global data and technology company, powering opportunities for people and businesses around the world. We help to redefine lending practices, uncover and prevent fraud, simplify healthcare, create marketing solutions, and gain deeper insights into the automotive market, all using our unique combination of data, analytics and software. We also assist millions of people to accomplish their financial goals and help them save time and money.
We operate across a range of markets, from financial services to healthcare, automotive, agribusiness, insurance, and many more industry segments.
We invest in people and new advanced technologies to unlock the power of data. As a FTSE 100 Index company listed on the London Stock Exchange (EXPN), we have a team of 22,500 people across 32 countries. Our corporate headquarters are in Dublin, Ireland. Learn more at experianplc.com.
Internal Grade E
Job Description
Experian's Global Security Office is looking for an Information Security Data Engineer with experience using Power Automate, SQL and PowerBI to build end-to-end automation routines as part of its Data Fabric implementation. You will also have data analysis skills and the ability to work as part of a team.
The Information Security Data Engineer will develop, improving, and maintaining executive security reporting workbooks and interactive PowerBI reporting tied to important security controls. You will design templates for PowerBI reporting, improve data feeds for improved performance and document procedures for the updating and maintenance of reporting. Automated workflows and reporting are made available for online and offline use as part of regular monthly forums and you will interpret reporting requests and turn them into applicable outputs
This is a UK remote based position reporting to the Lead Security Data Engineer
Important Functions
- 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.
Qualifications
- 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.
Additional Information
Benefits package includes:
- 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.
Experian is proud to be an Equal Opportunity and Affirmative Action employer. Innovation is an important part of Experian's DNA and practices, and our diverse workforce drives our success. Everyone can succeed at Experian and bring their whole self to work, irrespective of their gender, ethnicity, religion, colour, sexuality, physical ability or age. If you have a disability or special need that requires accommodation, please let us know at the earliest opportunity.
Experian Careers - Creating a better tomorrow together
Find out what its like to work for Experian by clicking here
#J-18808-Ljbffr
