Senior Data Engineer - Microsoft Fabric

Prudential Annuities Distributors (PAD); Letterkenny; On-site; EUR 90,000 - 120,000; Full time

Job summary

PGIM Ireland seeks a Senior Data Engineer to design, build, test, and maintain data pipelines powering platform delivery. You will work across data engineers, analysts and architects to translate complex business problems into scalable solutions using Python, SQL and Spark, with Microsoft Fabric as a core platform.

You will apply modern engineering practices, write automated tests, and collaborate in an agile environment, delivering reliable data services while continually learning new

Qualifications

• Bachelor's degree in Computer Science or Engineering or related field.
• Experience with DevOps automation tools and SDLC knowledge.
• Proven ability to learn new skills and collaborate across teams.
• Strong problem solving and communication, with agile working experience.

Responsibilities

• Build and optimize data pipelines using Python, SQL and Spark on MS Fabric.
• Develop high-quality, well-documented code meeting Prudential standards.
• Analyze data, prepare sources for modeling and insights across platforms.
• Collaborate with analysts, scientists and architects to improve data processes.
• Write unit/integration tests and automate quality checks.
• Apply emerging technologies and coach others to embed learning.
• Work on complex problems requiring in-depth evaluation of factors.

Skills

Python

SQL

Scala

Pyspark/Apache Spark

Shell scripting

Microsoft Fabric

Airflow

Tableau/Power BI

Data pipelines

Education

Bachelor of Computer Science or Engineering

Tools

Microsoft Fabric

Airflow

AWS

SQL

NoSQL/Graph DBs

Job description

Are you interested in building capabilities that enable the organization with innovation, speed, agility, scalability and efficiency? The Global Technology team takes great pride in our culture where digital transformation is built into our DNA! When you join our organization at Prudential, you’ll unlock an exciting and impactful career – all while growing your skills and advancing your profession at one of the world’s leading financial services institutions.

Your Team & Role

As a Senior Data Engineer you will analyze, design, develop, test, and perform ongoing maintenance to build high quality data pipelines that drive platform delivery. You will implement capabilities to solve sophisticated business problems, deploy innovative products, services and experiences to delight our customers! In addition to applied experience, you will bring excellent problem solving, communication and teamwork skills, along with agile ways of working, strong business insight, an inclusive leadership attitude and a continuous learning focus to all that you do.

• Build and optimize data pipelines in Microsoft Fabric, logic and storage systems with latest coding practices and industry standards and modern design patterns and architectural principles; actively code and execute against the roadmap
• Develop high quality, well documented and efficient code adhering to all applicable Prudential standards
• Conduct complex data analysis and report on results, prepare data for prescriptive and predictive modeling, combine raw information from different sources
• Collaborate with data analysts, scientists, and architects on data projects to enhance data acquisition, transformation, organization processes, data reliability, efficiency, and quality
• Write unit, integration tests and functional automation, researching problems discovered by quality assurance or product support, developing solutions to address the problems
• Bring an applied understanding of relevant and emerging technologies, begin to identify opportunities to provide input to the team and coach others, and embed learning and innovation in the day-to-day
• Work on complex problems in which analysis of situations or data requires an in-depth evaluation of various factors
• Use programming languages including but not limited to Python, SQL, Scala, Pyspark/Apache Spark, Shell scripting

The Skills & Expertise You Bring

• Bachelor of Computer Science or Engineering or experience in related fields
• Experience in working with DevOps automation tools &practices; Knowledge of full software development life cycle (SDLC)
• Leverage diverse ideas, experiences, thoughts and perspectives to the benefit of the organization
• Knowledge of business concepts tools and processes that are needed for making sound decisions in the context of the company's business Ability to learn new skills and knowledge on an on-going basis through self-initiative and tackling challenges Excellent problem solving, communication and collaboration skills; enjoy learning new skills!
• Applied experience with several of the following: Programming Language: Python, SQL, Scala, Pyspark/Apache Spark, Shell scripting Microsoft Fabric - proven experience building and optimizing data pipelines in MS Fabric Data Ingestion, Integration &Transformation: Moving data from multiple sources, formats, and volumes to analytics platforms through various tools. Preparing data for further analysis; transforming and mapping raw data to generate insights and wrangling data through tools. Database Management System: Storing, organizing, managing, and delivering data using relational DBs, NoSQL DBs, Graph DBs, and data warehouse technologies. Database tools: Data architecture to store, organize, and manage data. Experience with SQL and NoSQL based databases for storage and processing of structured, semi-structured &unstructured data. Real-Time Analytics: Spark, Kinesis Data Streams Data Buffering: Kinesis, Kafka Workflow Orchestration: Airflow, AppFlow, Austosys, Cloudwatch, Splunk Data Visualization: Tableau, Power BI, MS Excel Data Lakes &Warehousing: Building Data Models, Data Lakes and Data Warehousing Data Protection and Security: Knowledge of data protection, security principles and services; data loss prevention, role based access controls, data encryption, data access capture and core security services Common Infrastructure as Code (IaC) Frameworks: Ansible, CloudFormation Cloud Computing: Knowledge of fundamentals of AWS architectural principles and services; Strong ability on cloud formation and to write code; Knowledge of AWS core services Testing/Quality: Unit, interface and end user testing concepts and tooling inclusive of non-functional requirements (performance, usability, reliability, security/vulnerability scanning, etc.) including how testing integrated into Dev Ops; accessibility awareness
• Preferred qualifications: Serverless data pipeline development using AWS Glue, Lambda and Step functions
• Other Certifications?

You’ll Love Working Here Because You Can

You’ll Love Working Here Because You Can Join a team and culture where your voice matters; where every day, your work transforms our experiences to make lives better. As you put your skills to use, we’ll help you make an even bigger impact with learning experiences that can grow your technical AND leadership capabilities. You’ll be surprised by what this rock-solid organization has in store for you.

PGIM Ireland is proud to be an equal opportunity employer and is committed to equal employment opportunity regardless of applicants’ gender, civil status, family status, sexual orientation, religion, age, disability, race or membership of the traveler community.

PGIM Ireland's aim is to hire the best people for the open roles and all appointments will be made on merit.

Any offer of employment made by PGIM Ireland will be contingent on receiving satisfactory references.

Applicants should be aware that background checks will be carried out on all candidates offered a position within PGIM Ireland.

Prudential Financial, Inc. (NYSE: PRU), a global financial services leader and premier active global investment manager with approximately $1.4 trillion in assets under management as of Dec. 31, 2023, has operations in the United States, Asia, Europe, and Latin America.

Prudential’s diverse and talented employees help make lives better and create financial opportunity for more people by expanding access to investing, insurance, and retirement security.

Prudential’s iconic Rock symbol has stood for strength, stability, expertise and innovation for 150 years.

For more information please visit news.prudential.com.

Our Commitment to an Inclusive Workplace Prudential Financial, Inc. serves its customers in more than 40 countries and territories, and we seek talented, creative individuals from a variety of backgrounds, worldviews, and life circumstances to work with us.

We are focused on creating a fully inclusive culture, where all employees feel comfortable bringing their authentic selves to work.

We don’t just accept difference—we celebrate it, support it, and thrive on it.

At Prudential, employees have a unique opportunity to build their career path by owning their development, their career, and their future.

We encourage employees to hone their skills and explore continued opportunities within Prudential.

PGIM, the global asset management business of Prudential Financial, Inc. (NYSE: PRU), is a global investment manager with US $1.3 trillion in assets under management as of Dec. 31, 2023.

With offices in 18 countries, PGIM’s businesses offer a range of investment solutions for retail and institutional investors around the world across a broad range of asset classes, including public fixed income, private fixed income, fundamental equity, quantitative equity, real estate and alternatives.

For more information about PGIM, visit pgim.com.

Prudential Financial, Inc. (PFI) of the United States is not affiliated in any manner with Prudential plc, incorporated in the United Kingdom, or with Prudential Assurance Company, a subsidiary of M&G plc, incorporated in the United Kingdom.

For more information please visit news.prudential.com.

PGIM Inc. (PGIM) is the principal asset management business of Prudential Financial, Inc. (PFI), a company incorporated and with its principal place of business in the United States.

PFI of the United States is not affiliated in any manner with Prudential plc, incorporated in the United Kingdom or with Prudential Assurance Company, a subsidiary of M&G plc, incorporated in the United Kingdom.

Our Commitment to an Inclusive Workplace Prudential Financial, Inc. serves its customers in more than 40 countries and territories, and we seek talented, creative individuals from a variety of backgrounds, worldviews, and life circumstances to work with us.

We are focused on creating a fully inclusive culture, where all employees feel comfortable bringing their authentic selves to work.

We don’t just accept difference—we celebrate it, support it, and thrive on it.

At Prudential, employees have a unique opportunity to build their career path by owning their development, their career, and their future.

We encourage employees to hone their skills and explore continued opportunities within Prudential.