Information Security Data Engineer

Experian; Nottingham; Remote; GBP 40,000 - 60,000; Full time

Job summary

A leading technology firm is seeking an Information Security Data Engineer to enhance its security reporting processes using Power Automate, SQL, and Power BI. You'll work on data analysis and automate reporting routines as part of a collaborative team. This UK remote position offers flexibility and competitive benefits, including a great compensation package and generous annual leave.

Benefits

Flexible work environment

Great compensation package and discretionary bonus plan

Core benefits include pension and healthcare

25 days annual leave with 8 bank holidays

Qualifications

• Experience in building enterprise scale reporting using Power BI, Data Fabric, and Power Automate.
• Knowledge of systems architecture and designing Power Platform Applications.
• Proficient in creating and automating interactive reports and dashboards.

Responsibilities

• Design, test, and implement Business Intelligence ETL solutions.
• Interpret SQL data, write queries, and improve executive reporting workbooks.
• Ensure proper data feeds and reporting standards.

Skills

Power Automate

SQL

Power BI

Data Analysis

Tools

AWS

MySQL

Power Query

Data Fabric

Job description

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