Senior Data Engineer

[CONTRACT] Senior Data Engineer (Power BI & On-Premises BI)

Company: NLPC PFA

Location: Headquarters (Lagos, Nigeria) — On-Site (Flexible Hybrid Plan)

Job Type: Contract (Short-Term / Deliverable-Driven)

Department: Information Technology

Application Deadline: Friday, 19 June 2026, at 11:59 p.m.

About Us

NLPC Pension Fund Administrators Limited (NLPC PFA) is a leading pension fund administrator in Nigeria, licensed by the National Pension Commission since 2006. Dedicated to administering pension funds in accordance with the Pension Reform Act of 2004, NLPC PFA goes beyond traditional pension services by fostering client satisfaction and promoting financial security for a brighter future. Established in 2005, NLPC PFA incorporates its mission and vision into every aspect of its operations to serve its clients with excellence and trust.

Role Description

We are seeking an experienced, hands-on Senior Data Engineer for an on-site, contract-based role at our Lagos office. The Senior Data Engineer will be responsible for designing, building, and maintaining data pipelines and frameworks to process and analyse large datasets.

In this role, you will join an established technical squad, working closely alongside our Lead Data Engineer and Lead Solution Architect to fast-track the delivery of scheduled reporting milestones. This is a practical execution and delivery role, ideal for an engineer who excels at getting under the hood of enterprise data models and optimising analytical performance. While the immediate focus is entirely on-premises, a baseline understanding of cloud architecture will be highly valuable for our mid-term infrastructure roadmap.

Key Responsibilities

• 
  
• Pipeline Support: Support the team in managing Medallion data architectures (Bronze, Silver, Gold) and star schemas using SSIS to ensure clean, reliable data ingestion.
• 
  
• Semantic Modelling: Configure and manage enterprise semantic models in SSAS Tabular utilising power-user utilities such as Tabular Editor and DAX Studio.
• 
  
• BI Delivery: Deploy and maintain interactive dashboards and high-fidelity paginated reports using Power BI Report Server (PBIRS) and SSRS.
• 
  
• Data Security: Apply robust, dynamic Row-Level Security (RLS) and Object-Level Security (OLS) patterns alongside standard engine-level data masking policies.
• 
  
• Data Governance: Assist with enterprise master data stewardship workflows using Master Data Services (MDS) and maintain local data dictionaries.
• 
  
• Deployment Tasks: Help automate environment changes across Dev, Test, and Prod environments using PowerShell scripts and platform REST APIs.

Qualifications

• Experience: Minimum of 5 years of continuous, practical experience in a Data Engineering, BI Development, or heavy SQL-focused developer role.
• 
  
• Technical Competency: Deep working knowledge of the core Microsoft on-premises enterprise data stack, specifically SSAS Tabular, SSIS, and SSRS.
• 
  
• Code Fluency: Strong command of writing advanced T-SQL (stored procedures, views, performance tuning), complex DAX scripting, Power Query, and basic PowerShell for routine automation.
• Cloud Readiness: Familiarity with cloud data migration concepts (specifically moving Microsoft workloads to AWS) is a strong advantage, ensuring today's builds remain future-proof.
• Teamwork: Proven ability to integrate quickly into an active technical team to accelerate project deliverables under tight timelines, while helping to mentor junior team members where required.
• Education: Bachelor’s or Master’s degree in Computer Science, Data Science, Engineering, or a related field.
• Certifications (Advantageous): Microsoft PL-300 (Power BI Data Analyst), DP-600 (Fabric Analytics Engineer), AWS Certified Data Analytics, or professional SQL Server database development credentials.

📋 Mandatory Technical Screening Assessment

To ensure proper screening of practical technical competency at the start of this exercise, all candidates must complete the following mini-challenge. Your solution must be uploaded to a public GitHub repository, and the repository link must be included in your application email.

Task 1: Advanced DAX (Dynamic RLS)

Given an on-premises organisational hierarchy table dim_employee with the columns EmployeeKey, EmployeeEmail, ManagerKey, and ParentPath (generated via the PATH() function):

• Write the exact DAX filter expression required to enforce dynamic Row-Level Security so that a logged-in manager can see their own data and all data for employees falling under them in the hierarchy. Ensure it resolves correctly on-premises via USERPRINCIPALNAME().

Task 2: T-SQL Pipeline Logic (SCD Type 2)

• Provide a clean T-SQL script or structural outline showing how you handle data ingestion from a raw staging table into a slowly changing dimension table (SCD Type 2) for an asset register. The script must handle new inserts, check for changes in existing records, record the effective dates (EffectiveFrom, EffectiveTo), and flag the IsCurrent status.

Task 3: Automation Script Snippet

• Write a brief PowerShell snippet or pseudo-script demonstrating how you would invoke a deployment command using a BI Platform's REST API to programmatically copy an artifact or refresh a configuration setting from a /Dev directory root to a /Test directory root.

💼 How to Apply

Interested and qualified candidates should send their applications directly to Jobs@nlpcpfa.com.

Your application must include:

1. Your updated CV strictly in PDF format.
2. The public GitHub repository URL containing your code/text answers to Tasks 1, 2, and 3.

• Subject Line Format: Application: Senior Data Engineer (Power BI Contract)
• Application Deadline: Friday, 19 June 2026, at 11:59 p.m.

Late submissions or applications without a valid GitHub assessment link will not be reviewed.

#DataEngineering #PowerBI #SQLServer #SSAS #SSIS #SSRS #BusinessIntelligence #ITContractor #TechJobsNigeria

<