Phase 1 Enterprise Data Setup
22 hours ago
Job description
ObjectiveProvision a secure scalable Azure foundation that can
1 Run required virtual machines and automation services
2 Store consumer and market research questionnaire data in an extensible schema
3 Ingest data from Framer and embedded iframe questionnaires
4 Expose an API first data layer for future products and partners
5 Run automation workflows n8n and Airtable when required
1 Infrastructure to Provision Azure
Core Azure Components
Azure Virtual Network with segmented subnets
subnet app
subnet data
subnet automation
subnet private endpoints
Private endpoints for all databases no public database access
Azure Key Vault for secrets and encryption keys
Azure Monitor and Log Analytics enabled from day one
Compute Options
Preferred managed services
Azure App Service for API and webhooks
Azure Container Apps for n8n container runtime
If virtual machines are required
VM 01 Automation Host
Ubuntu LTS
Docker and docker compose
Runs n8n
Private subnet only
VM 02 Operations Bastion Host
Controlled administrative access
Azure Bastion preferred
No services exposed directly to the public internet except via API gateway or App Service
2 Database Structure Extensible and API First
Database Choice Phase 1
Azure SQL Managed Instance or Flexible Server
Reason structured relational model scalability strong access control
Two Database Separation Model
DB1 Identity PII
Stores user account details
Stores consent logs
Stores email and contact data
DB2 Survey and Product Data No PII
Stores questionnaire responses
Stores product feedback
Stores behavioural events
Link via Pseudonymous ID UUID No email or name stored in DB2
Extensible Survey Schema
Survey Table
Survey ID
Name
Version
Status
Created At
Question Table
Question ID
Survey ID
Question Key
Answer Type
Options JSON nullable
Sort Order
Response Table
Response ID
Survey ID
Pseudonymous ID
Timestamp
Completion Status
Source Framer iframe or API
Answer Table
Response ID
Question ID
Answer Value Text nullable
Answer Value Number nullable
Answer Value JSON nullable
3 API First Ingestion Layer
Provision Azure API Management
API service App Service or container
Endpoints
POST v1 users
POST v1 consents
POST v1 surveys id responses
POST v1 events
All inbound payloads must validate schema log securely and return deterministic success or fail responses
4 External Data Import Framer and Iframe
Framer Integration
Framer form to webhook to Ranvier API preferred
Framer to n8n to Ranvier API acceptable
Iframe Questionnaire
Submits to secure webhook endpoint
Maps survey version and question keys
Writes to Survey DB only no PII
If iframe captures email route to Identity DB only
5 Automation Workflows n8n and Airtable
n8n Hosting
Azure Container Apps preferred or VM based Docker
n8n Responsibilities
Listen for webhook events
Run transformations and segmentation
Push operational views to Airtable
Trigger outbound actions if consented
Airtable Role
Workflow and operational visibility only
Not system of record
No raw PII unless explicitly approved
Example Automations
On new survey completion score tag and update dashboard
On early access request create operations record and notify team
6 Deliverables Required
1 Azure deployment plan
2 VM configuration and hardening plan
3 Database schema version 1
4 API specification OpenAPI
5 Ingestion mapping for Framer and iframe
6 n8n deployment and baseline workflows
7 Security baseline configuration
8 Extensibility plan for Phase 2 clinical upgrade
7 Guardrails
Database is source of truth
Airtable is a view layer only
No public SQL endpoints
Strict PII separation
Version all surveys and questions
API first architecture
Contract duration of less than 1 month. with 30 hours per week.
Mandatory skills:
Azure DevOps, Azure AI Vision, SQL, Python, PHP, JavaScript, Microsoft SQL Server, Database Design, Database Optimization, Database Administration
Similar jobs
We are looking for a skilled freelancer to assist us with our initial data import into The ideal candidate will help clean and organize our data to ensure it is ready for effective use within the platform. This is a crucial step in our setup, and we need someone with experience ...
21 hours ago
Set up an ODBC data connection from Accura MIS software to extract data regularly automatically. Data to then be pulled into a spreadsheet or Google Sheet. · ...
1 month ago
+I'm looking for an experienced NocoDB user to set up a clean, production-ready data model for leads CRM in self-hosted local NocoDB instance. · + · +NocoDB userLead GenerationNocoDBRelational DatabasesData Modeling ...
1 month ago
BBX Advisors seeks freelancer to enhance data security for client communications with contractors in Philippines. · ...
1 month ago
This position involves CRM setup and data migration specialist role requiring knowledge of Microsoft Dynamics CRM and other CRMs. The contract duration is less than a month with 30 hours per week. · ...
1 month ago
We are seeking a skilled freelancer to help us set up our Notion workspace and transfer existing data from Trello. Trello · Data Migration · Administrative Support · ...
1 month ago
I'm seeking a freelancer to set up and run a consumer survey for my master's thesis. The task involves programming the survey exactly as written and collecting responses. · ...
1 month ago
We are looking for an experienced Shopify tracking and analytics expert to enable, fix, and optimize the Shopify Data Layer for accurate event tracking and conversion measurement. · Enable and configure Shopify Data Layer · Audit existing tracking setup (Theme + Checkout) · Fix b ...
1 month ago
I am a public health professional building an MVP for a Medicaid Maternity Reimbursement Index. I need a technical partner to build a streamlined data pipeline that extracts pricing data from state-level PDFs and displays it in a professional filterable B2B dashboard. · ...
4 weeks ago
Seeking an experienced freelancer to set up a new Coda account and organize customer data into tables and sheets. · ...
1 month ago
+ Job summary: We are seeking an experienced individual with hands-on knowledge of and Certinia to assist in setting up reports.Your expertise will help us streamline our data management processes and enhance our reporting capabilities. · ...
4 weeks ago
We are looking for a detail-oriented freelancer to set up data on randomized bingo sheets. · A key requirement of this role will involve creating bingo sheets with unique name song combinations ensuring fair game experienceMicrosoft ExcelData EntryGoogle Sheets(li)Python ...
2 weeks ago
We are seeking a detail-oriented freelancer to assist with setting up a product CSV file. · This task involves straightforward data entry, ensuring accurate and organized input of product information. · ...
2 weeks ago
I am looking for an experienced HubSpot freelancer to help us properly set up HubSpot from scratch using our existing Excel data. · ...
3 weeks ago
We have email addresses and linkedin info in a supabase database. We want to setup a N8N work flow to do a data append. · Ideal we get name, job title, company and other info about them. ...
1 month ago
I'm looking for someone to build a small n8n workflow that syncs data from an external API into Google Sheets. · ...
3 weeks ago
++We're looking for an experienced Azure freelancer to set up a Data Lake with a focus on cost savings and documentation.+ · +++Assess and implement a data platform,+Deliver a working, secure, well-structured Data Lake,+Minimize costs and reduce manual work.+ · ++Provide clear, r ...
2 weeks ago
I'm looking for an experienced cold email specialist to help me launch and test high-performing outbound campaigns for a client. · Lead Sourcing & List Building: Source high-quality, verified B2B leads Segment by niche for structured testing Ensure deliverability-safe data practi ...
1 week ago
Odoo Account Setup and Data Import Specialist
Only for registered members
We are looking for an experienced Odoo specialist to help us configure our existing Odoo account and get us invoicing as quickly as possible. · This project is Phase 1, intended to assess a working fit and establish good collaboration before expanding into additional modules. · I ...
1 month ago
KPI Spreadsheet Setup for Business Data Tracking
Only for registered members
I am seeking a detail-oriented freelancer to assist with setting up KPI spreadsheets for my business. · ...
1 month ago