#1023 - Data Security Solution Engineer

Job brief - Opportunity only available for Latam Professionals

We're looking for a hands-on Data Security Solutions Engineer to design and validate database-level security for licensed third-party data: identity-based authentication, fine-grained authorization, auditing, and access revocation/deletion. The role includes running POCs and turning validated patterns into reusable, production-ready designs.

Responsibilities

Technical and Database Assessment

• Review Data In-Licensing requirements, workflow maps, data flows, data lineage, entitlement rules, and dependency records.
• Assess relational database platforms, schemas, connectivity methods, interfaces, drivers, service identities, query patterns, and downstream consumption.
• Identify where licensed data is stored, transformed, replicated, extracted, cached, archived, or backed up.
• Assess current database security capabilities and identify gaps, constraints, risks, and prerequisites.

 Data-Level Authentication and Identity Integration

• Assess authentication for named users, service identities, workloads, and analytical tools accessing databases.
• Evaluate OAuth/OIDC or other identity- and token-based authentication directly to the database where supported by the selected technology.
• Design integration between enterprise identities, security groups, project groups, database principals, roles, and policy engines.
• Reduce reliance on shared or long-lived credentials where feasible and define secure credential or token handling for unavoidable exceptions.
• Align with tools currently available and identify gaps if any

Fine-Grained Authorization and Data Firewalling

• Design database-level controls that restrict access to explicitly authorized users, groups, services, projects, or licensing populations.
• Design and implement row-level security, column-level security, dynamic masking, views, policy-based filtering, or equivalent controls as appropriate.
• Define isolation patterns for different licensed datasets and agreements while preserving permitted platform use for other users.
• Ensure controls are consistently enforced as close to the data layer as technically feasible and are not solely dependent on application logic.

Auditing, Monitoring, and Traceability

• Design database auditing to capture who accessed data, what was accessed, when access occurred, and which identity or service was used.
• Define logging for queries, exports, failed access attempts, permission changes, and privileged activity where supported and required.
• Integrate audit telemetry with appropriate monitoring and reporting capabilities and define retention and evidence requirements.
• Validate that audit records are searchable, attributable, protected from inappropriate modification, and useful for investigation.

Data Lifecycle, Revocation, and Deletion

• Design controls for access revocation when users change roles, leave a project, or when licensing rights expire.
• Design methods to identify and remove licensed data from primary stores and relevant downstream copies, extracts, caches, or derived stores.
• Address deletion implications for referential integrity, backups, archives, replication, recovery processes, and downstream consumers.
• Define validation, exception handling, and evidence mechanisms to demonstrate that required deletion activities were completed.

Solution Architecture and Engineering

• Translate requirements into current-state and target-state architectures, technical specifications, security patterns, and implementation plans.
• Compare solution options and document trade-offs across security, feasibility, performance, scalability, operability, cost, and technology constraints.
• Define database connectivity, policy-enforcement, identity, audit, monitoring, lifecycle, and integration components.
• Collaborate with database, IAM, security architecture, infrastructure, application, data platform, governance, and scientific teams.

POC Design and Execution

• Select suitable relational database and workflow candidates that represent Data In-Licensing scenarios and material technical risks.
• Define POC architecture, test data, test identities, success criteria, negative tests, performance considerations, and rollback approach.
• Implement and validate identity-based authentication, fine-grained authorization, data firewalling, auditing, access revocation, and deletion scenarios.
• Document outcomes, limitations, operational considerations, reusable patterns, and recommendations for broader adoption.

Requirements

• Strong hands-on experience with relational databases, SQL, database architecture, schemas, roles, privileges, and access paths.
• Practical experience implementing database-level authorization, including row-level and column-level controls or equivalent fine-grained mechanisms.
• Strong knowledge of database authentication, IAM, OAuth 2.0, OIDC, tokens, service identities, workload identities, and secrets management.
• Experience designing secure database connectivity and integrations for applications, analytical tools, APIs, ETL/ELT, and data pipelines.
• Experience with database auditing, query/activity monitoring, centralized logging, alerting, and investigation support.
• Understanding of data lineage, lifecycle, retention, revocation, deletion, backup, archive, and recovery implications.
• Ability to evaluate heterogeneous database technologies and design platform-appropriate controls.
• Strong architecture, engineering, troubleshooting, documentation, and stakeholder-collaboration skills.

Expected Deliverables

• Technical assessment of databases, integrations, identities, and data flows
• Current-state database security and capability assessment
• Target-state data security architecture and detailed technical design
• Database authentication and identity-integration design
• Row-level, column-level, masking, and policy-enforcement design
• Data firewalling and licensed-dataset isolation pattern
• Audit, monitoring, traceability, and reporting design
• Access revocation, retention, lifecycle, and deletion design
• Solution options, feasibility, gap, dependency, and risk assessment
• POC architecture, implementation, test results, and recommendations
• Reusable implementation patterns and operational handover documentation

Nice to have:

• Experience with enterprise data platforms, cloud or hybrid databases, data catalogs, access governance, and policy-enforcement technologies.
• Experience in pharmaceutical research, scientific data, intellectual property protection, data licensing, or another regulated environment.
• Experience designing and executing security POCs and converting validated patterns into production-ready designs.
• Knowledge of privacy, contractual-use restrictions, segregation, and evidence requirements affecting licensed data.

What we offer:

• Competitive salary in USD.
• 100% Remote Work.
• Contract type: Independent Contractor with Venon Solutions LLC.
• Holidays: from the North American calendar.
• Working hours: EST Time zone. Full-time, fully committed.