Information Security Data Engineer

3C Deutschland GmbH; Nottingham; Remote; GBP 50,000 - 70,000; Full time

Job summary

A leading company in the data and technology space seeks an Information Security Data Engineer. The role involves designing automation routines and managing security reporting using Power BI, SQL, and AWS. Candidates with strong analytical skills and automation experience will thrive in this collaborative environment.

Benefits

Flexible work environment

Great compensation package

Core benefits like pension and healthcare

Generous annual leave policy

Qualifications

• Experience in data automation and reporting solutions.
• Knowledge of Power BI, SQL, and data storage in AWS.
• Ability to design and implement ETL solutions.

Responsibilities

• Develop executive security reporting workbooks in Power BI.
• Design and implement Business Intelligence ETL solutions.
• Interpret data in SQL and update Power BI automation routines.

Skills

MS Data Fabric

Power Automate

PowerBI

SQL

AWS Environments

Job description

• Schedule: Full Time

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

• 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