Senior Product & Data Solutions Architect

VentureDive Private Limited; Pakistan; On-site; PKR 4,200,000 - 7,500,000; Full time

Job summary

VentureDive Private Limited is seeking a Senior Product Development & Data Solutions Specialist to design, build, and maintain enterprise software and data solutions for the SMART product suite. You will develop backend services, APIs, and data layers, collaborating with product owners, QA, and stakeholders to deliver robust systems.

The role emphasizes scalable architecture, data integration, and SDLC best practices, with opportunities to lead and mentor within a product-focused team.

Qualifications

• 7+ years of professional software development experience.
• 5+ years hands-on experience with C#, .NET Core / .NET, ASP.NET Core, and SQL Server.
• Strong experience developing scalable enterprise applications.
• Strong experience designing and optimizing SQL Server databases.
• Experience building REST APIs and backend services.
• Experience with data integration, data migration, or ETL processes.
• Experience working in Agile/Scrum or structured SDLC environments.
• Proven track record of delivering production systems.
• Experience working with product owners, business analysts, QA teams, and stakeholders.

Responsibilities

• Design, develop, test, and maintain enterprise applications using C#, .NET Core / .NET 6+, ASP.NET Core, and REST APIs.
• Enhance existing Company products and internal platforms.
• Build backend services, APIs, batch processes, integration services, and data-processing components.
• Refactor and improve existing product components.
• Participate in product roadmap delivery and sprint execution.
• Convert business and product requirements into technical tasks and working software.
• Apply SOLID principles, design patterns, clean architecture, and maintainable coding practices.
• Follow internal change control, coding standards, release management, and documentation processes.
• Conduct unit testing, code reviews, technical walkthroughs, and troubleshooting.
• Design and maintain SQL Server databases for product and analytical use cases.
• Create and optimize tables, views, stored procedures, functions, indexes, and database scripts.
• Design scalable data models for transactional, configuration, historical, and reporting purposes.
• Develop database structures that support auditability, versioning, traceability, and data quality.
• Design and support data integration processes between internal and external systems.
• Build staging, transformation, and reporting-ready data layers.
• Design fact tables, dimension tables, historical snapshots, and reporting marts.
• Support ETL/ELT processes for structured data ingestion and transformation.
• Implement data validation, deduplication, cleansing, and reconciliation logic.
• Analyze execution plans and resolve SQL performance bottlenecks.
• Index tuning, query optimization, and transaction management.
• Design ERDs and maintain technical database documentation.
• Support data migration, transformation, cleansing, validation, and reconciliation.
• Build and maintain RESTful APIs and backend services.
• Integrate with internal systems, third-party services, and external data providers.
• Work with JSON, XML, XSD, XSLT, SOAP, and REST-based services.
• Implement authentication, authorization, logging, validation, and exception handling.

Skills

C#

ASP.NET Core

.NET Core

.NET 6+

REST API

Dependency Injection

Middleware

Async/await

LINQ

Error handling

SQL Server

REST APIs

Docker

Kubernetes

Education

Grade 12 with relevant work experience

BSc Information Systems

B.Tech (Information Technology) or equivalent

NQF level 4–6 qualification

Tools

SQL Server

Job description

VentureDive Private Limited is seeking a Senior Product Development & Data Solutions Specialist to design, build, and maintain enterprise software and data solutions for the SMART product suite. You will develop backend services, APIs, and data layers, collaborating with product owners, QA, and stakeholders to deliver robust systems.

The role emphasizes scalable architecture, data integration, and SDLC best practices, with opportunities to lead and mentor within a product-focused team.