Senior Data Engineer - Microsoft Fabric

PGIM Ireland; Letterkenny; On-site; EUR 90,000 - 120,000; Full time

Job summary

PGIM Ireland is seeking a Senior Data Engineer to design, develop, test and maintain high quality data pipelines that support platform delivery. You will code against MS Fabric, Spark and modern storage systems, while ensuring data reliability and governance across sources.

You will collaborate with data analysts, scientists and architects to enable prescriptive and predictive insights, while adhering to Prudential standards and DevOps practices.

Qualifications

• BS/BE in computer science or engineering, or related field.
• Proficient in Python, SQL, Scala and Spark stack.
• Experience with data pipelines and SDLC practices.

Responsibilities

• Build and optimize data pipelines using modern frameworks.
• Write tests and ensure code quality and reliability.
• Collaborate with analysts, scientists and architects on data projects.
• Leverage emerging technologies and coach teammates as needed.

Skills

Python

SQL

Scala

Pyspark/Apache Spark

Shell scripting

DevOps practices

SDLC knowledge

Problem solving

Communication

Team collaboration

Education

Bachelor of Computer Science or Engineering

Tools

Microsoft Fabric

Kinesis Data Streams

Kafka

Airflow

AppFlow

CloudWatch

Splunk

Tableau

Power BI

MS Excel

AWS CloudFormation

Ansible

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 & RoleAs 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.Here is What You Can Expect on a Typical DayBuild 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 roadmapDevelop high quality, well documented and efficient code adhering to all applicable Prudential standardsConduct complex data analysis and report on results, prepare data for prescriptive and predictive modeling, combine raw information from different sourcesCollaborate with data analysts, scientists, and architects on data projects to enhance data acquisition, transformation, organization processes, data reliability, efficiency, and qualityWrite unit, integration tests and functional automation, researching problems discovered by quality assurance or product support, developing solutions to address the problemsBring 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-dayWork on complex problems in which analysis of situations or data requires an in-depth evaluation of various factorsUse programming languages including but not limited to Python, SQL, Scala, Pyspark/Apache Spark, Shell scriptingThe Skills & Expertise You BringBachelor of Computer Science or Engineering or experience in related fieldsExperience 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 organizationKnowledge of business concepts tools and processes that are needed for making sound decisions in the context of the company's businessAbility to learn new skills and knowledge on an on-going basis through self-initiative and tackling challengesExcellent 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 scriptingMicrosoft Fabric - proven experience building and optimizing data pipelines in MS FabricData 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 StreamsData Buffering: Kinesis, KafkaWorkflow Orchesration: Airflow, AppFlow, Austosys, Cloudwatch, SplunkData Visualization: Tableau, Power BI, MS ExcelData Lakes & Warehousing: Building Data Models, Data Lakes and Data WarehousingData 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 servicesCommon Infrastructure as Code (IaC) Frameworks: Ansible, CloudFormationCloud Computing: Knowledge of fundamentals of AWS architectural principles and services; Strong ability on cloud formation and to write code; Knowledge of AWS core servicesTesting/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 awarenessPreferred qualifications:Serverless data pipeline development using AWS Glue, Lambda and Step functionsOther Certifications?You’ll Love Working Here Because You CanJoin 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.