Lead Data Platform Engineer - PGIM

Responsibilities

• Data Platform & Fabric Engineering
• Design and implement end-to-end data pipelines using Microsoft Fabric (Data Factory, Data Engineering, Lakehouse).
• Build and maintain Fabric Lakehouse architectures (Bronze/Silver/Gold) optimized for marketing and BI use cases.
• Implement incremental loads, CDC patterns, and data freshness strategies for large-scale analytical datasets.
• Optimize storage formats (Delta/Parquet), partitioning, and performance tuning in Fabric.
• Data Engineering & Transformation
• Develop robust data transformation logic using: PySpark / Spark SQL, SQL-based transformations
• Perform data cleansing, standardization, enrichment, and deduplication across multiple marketing and customer data sources.
• Implement data quality checks, validation rules, and anomaly detection within pipelines.
• Maintain reusable transformation frameworks and shared data assets.
• Marketing & Business Data Integration
• Ingest and model data from marketing and customer platforms such as: Digital analytics (web, app, events), Campaign platforms (email, paid media, CRM, CDPs), Internal business systems (sales, finance, operations)
• Create conformed dimensions and fact tables for marketing performance, attribution, funnel analysis, and customer insights.
• Enable cross-channel reporting and identity-aware analytics.
• Power BI & Semantic Modeling
• Design and optimize Power BI semantic models (datasets) for enterprise reporting.
• Build star schemas, calculation groups, and optimized DAX measures.
• Ensure report performance, scalability, and refresh reliability.
• Support self-service BI while enforcing enterprise data governance standards.
• Collaborate with analysts and business users on dashboard requirements and usability.
• Governance, Security & Operations
• Implement workspace strategies, environment separation (Dev/Test/Prod), and deployment pipelines in Fabric.
• Enforce data access controls, row-level security (RLS), and sensitivity labels.
• Establish monitoring, logging, and alerting for pipeline health and data reliability.
• Document data models, pipelines, and operational runbooks.
• Participate in on-call or production support rotations as needed.
• Collaboration & Leadership
• Act as a technical mentor for junior engineers and analysts.
• Influence data architecture decisions and analytics best practices.
• Work closely with product managers, marketing leaders, and BI teams to prioritize and deliver high-impact data products.
• Contribute to standards for data modeling, naming conventions, and pipeline design.

Requirements

• Core Technical Skills
• 8+ years of experience in data engineering / analytics engineering roles.
• Strong hands-on expertise with Microsoft Fabric: Lakehouse, Data Factory, Data Engineering (Spark), Workspaces and deployment pipelines
• Advanced SQL skills and experience with large analytical datasets.
• Strong experience with Power BI: Semantic models, DAX, Performance optimization
• Proficiency in PySpark or Spark SQL.
• Data Engineering Fundamentals
• Deep understanding of: Data modeling (star/snowflake schemas), ETL / ELT design patterns, Incremental processing and CDC, Data quality and validation frameworks
• Experience operating data platforms in production environments.
• Domain & Soft Skills
• Experience supporting marketing analytics, customer analytics, or growth analytics.
• Strong stakeholder communication skills-able to translate business questions into data solutions.
• Comfortable working in agile, fast-moving environments with evolving requirements.
• What would Set You Apart:
• Experience with enterprise marketing stacks (CDPs, CRM, campaign tools).
• Familiarity with data governance frameworks and privacy-aware data design.
• Experience migrating from legacy BI platforms to Microsoft Fabric.
• Exposure to CI/CD concepts for data platforms.
• Azure ecosystem experience beyond Fabric (Synapse, ADLS, etc.).
• What Success Looks Like:
• Reliable, well-governed Fabric lakehouses powering business-critical dashboards.
• High-performing Power BI reports used daily by marketing and leadership teams.
• Reduced data latency and improved trust in analytics.
• Clear documentation and reusable data assets.
• Strong collaboration between engineering, analytics, and business users.
• What We Offer You:
• Health Insurance: PGIM Ireland partner wi

Benefits

Additional Information

Location: Letterkenny - Hybrid 2-3 day p/week onsite What you can Expect We are seeking a hands-on Senior Data & Analytics Engineer to design, build, and operate scalable Microsoft Fabric-based analytics platforms that power enterprise marketing analytics, customer insights, and business intelligence. This role is not theoretical-you will be deeply involved in data ingestion, transformation, lakehouse modelling, semantic layer design, Power BI optimization, and production-grade pipeline orchestration. You will partner closely with marketing, growth, product, and business stakeholders to translate analytical requirements into governed, high-performance data products.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at pru? Share your experience