Data Architect / Backend Data Engineer

Posted 5 days ago

Worldwide

Summary

Data Architect / Backend Data Engineer We are looking for a multidisciplinary data professional who can help us design and implement the target data architecture for a growing health technology product. This is not a pure data analyst role and not a pure software engineering role. We need someone who can work across data organization, architecture design, backend implementation, and analytics to help us turn fragmented information into a reliable and scalable data foundation. The right person will help us move from scattered sources and manual workarounds toward a structured system that supports metrics, traceability, reporting, and product decisions, and can actually be implemented inside our existing backend. About the Product We are building Be Healthy and the broader IKI Brain vision as a technology layer for health programs, clinics, and future strategic partners. Our current challenge is not only collecting data, but turning that data into something usable. We need a practical architecture that can support: user and patient behavior tracking, structured metrics and reporting, digital profiles, product credibility, and a clear foundation for version 2 of the platform. What We Need Help With We are looking for someone who can: review current data sources and identify inconsistencies, define a practical target architecture, implement the first usable version of that architecture inside our backend, create a relational analytical structure, support a star schema or comparable multidimensional design, build traceability into the data flow, and help define key metrics for product and business visibility. The stack direction includes SQL Server for the analytical core, with MongoDB remaining available for operational or unstructured use cases where appropriate. The current backend is Node.js / Express and uses MongoDB, Mongoose, Firebase Admin, and middleware-based auth/RBAC. Your work may include: auditing existing data sources and structures, defining data models and relationships, translating business requirements into technical data logic, reading and modifying existing Node.js / Express backend code, updating routes, controllers, middlewares, and model definitions where needed, building or supporting the implementation of the architecture, defining atomic and aggregated metrics, documenting assumptions and limitations, improving data extraction and reporting readiness, and helping create a system that is scalable and maintainable. Ideal Candidate We are looking for someone who is multidisciplinary and can bridge analysis, architecture, backend implementation, and data modeling. Ideal experience includes: strong Node.js and Express experience, strong SQL Server experience, relational modeling and dimensional modeling, star schema design, MongoDB and Mongoose experience, experience working inside an existing production backend, auth and RBAC middleware familiarity, Firebase Admin or token-based backend auth integration, data architecture implementation, analytics and reporting design, data traceability and event tracking, and the ability to work with incomplete or fragmented data. Experience in health tech, clinical data, or product analytics is a strong plus. We will consider this engagement successful if you help us: clarify our data structure, make backend changes that align with the target architecture, create a usable analytical foundation, improve visibility into product usage and behavior, support a more credible product narrative, and leave us with a system that can grow into version 2. Working Style We prefer someone who is proactive, structured, and comfortable working with a team that is still defining parts of the system. The ideal freelancer can think strategically, but also execute practically. We expect the person to be comfortable reading an existing codebase and making safe, targeted changes rather than starting from scratch. Our goal is to find a professional who can help us design and implement the right data foundation quickly, without waiting for a perfect long-term system before delivering value. If you can work with a live backend that already has auth, routes, and data access patterns in place, and you can adapt that system toward a cleaner analytical architecture, that is exactly what we need. If you are comfortable working with product-minded teams and can help shape a real-world architecture that balances structure, analytics, and implementation, we would like to hear from you.

  • Less than 30 hrs/week
    Hourly
  • 3-6 months
    Duration
  • Intermediate
    Experience Level
  • $10.00

    -

    $20.00

    Hourly
  • Remote Job
  • Complex project
    Project Type
Skills and Expertise
Mandatory skills
SAS
Machine Learning
Nice-to-have skills
Python
Data Modeling
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:yesterday
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Mar 18, 2023
  • Spain
    Artà11:03 PM
  • $2.9K total spent
    5 hires, 3 active
  • 120 hours

Explore similar jobs on Upwork

Database University AssignmentsHourly‐ Posted 9 months ago
SQL
Database
Microsoft Excel
Database Design
Database Management
SQL Server Integration Services
Excel Macros
Excel Formula
Microsoft Power BI
Microsoft Excel PowerPivot
Power Query
Data Entry
Data Cleaning
Data Analytics
Data Extraction
AWS Glue
Apache Kafka
Python
HubSpot
Salesforce CRM
REST API
Node.js

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo