Data Modeling Jobs

I have an existing analytics initiative that now needs a dedicated Redshift-based warehouse. The core objective is to design and implement a robust schema in Amazon Redshift, then ingest data coming from three different sources—our operational SQL databases, a set of RESTful APIs, and periodic flat-file drops in CSV or JSON. Here is what I’m aiming for: • A well-structured Redshift warehouse (star or snowflake schema, whichever is most appropriate) built to scale and documented clearly. • Reliable, automated ingestion pipelines for each source type. For SQL we currently use PostgreSQL and MySQL; for APIs the payloads are mostly JSON; the flat files live in S3. • Transformations that standardise data types, handle slowly changing dimensions, and enforce dat...

Our organisation’s data assets sit in multiple platforms and formats, and the absence of a common language is starting to hinder everything from analytics to audit response times. I want to put in place a unified metadata management framework that improves governance across the board, with a special emphasis on meeting strict Compliance requirements. The scope covers information architecture, controlled vocabularies, and an enterprise-wide taxonomy that standardises terminology between systems. The work will culminate in a reusable model that makes stewardship activities—classification, retention, lineage tracking—far easier and more defensible. Key deliverables • A logical and physical data taxonomy covering all major subject areas • Controlled vocabu...

I need a Google Cloud / BigQuery specialist to stand up an end-to-end, webhook-driven data ingestion pipeline running in our production environment. When our external form system fires a webhook, your Cloud Function (or equivalent service) should capture the JSON payload, write the untouched record to a raw BigQuery table, then immediately process it. The processing step must • parse any nested JSON, • flatten and clean each answer field, • split the results into two purpose-built reporting tables, and • guarantee idempotency through a hashing technique that blocks duplicates. All components have to be secure, version-controlled, and able to scale with traffic spikes. This is strictly a backend/data-engineering job—no UI work is involved.

We are seeking an experienced Workday Adaptive Planning Consultant to support a post-go-live environment focused on enhancements, reporting, forecasting, and user support. This is a hands-on consulting engagement, not a greenfield implementation. The right consultant has already worked inside Adaptive Planning environments and can operate independently with minimal ramp-up. The initial engagement is 2–3 months, with a strong possibility of extension based on performance and project needs. What You’ll Be Doing Support and enhance existing Workday Adaptive Planning models Build and refine reports, dashboards, and forecasting models Assist with budget-to-actuals reporting and scenario planning Partner with finance and FP&A stakeholders to gather requirements and deliver...

We are seeking an experienced Workday Adaptive Planning Consultant to support a post-go-live environment focused on enhancements, reporting, forecasting, and user support. This is a hands-on consulting engagement, not a greenfield implementation. The right consultant has already worked inside Adaptive Planning environments and can operate independently with minimal ramp-up. The initial engagement is 2–3 months, with a strong possibility of extension based on performance and project needs. What You’ll Be Doing Support and enhance existing Workday Adaptive Planning models Build and refine reports, dashboards, and forecasting models Assist with budget-to-actuals reporting and scenario planning Partner with finance and FP&A stakeholders to gather requirements and deliver...

Role: Software Developer / Technical Partner (Equity Opportunity) I am looking for an experienced software developer to join me as a technical partner on the development of an AI-integrated desktop application, from MVP through to initial launch. This is not a contract-only role. For the right person, there is an opportunity to take on a meaningful equity stake, reflecting long-term involvement in architecture, implementation, and product evolution. The product is a stateful, non-trivial application that integrates AI as an interactive system component. It requires careful data modelling consistency management, and thoughtful UX for extended use. This is not a marketing website or a thin wrapper around an API. Core requirements: Experience building desktop applications (Electron, Tauri, ....

We are hiring an experienced professional to build Excel-based strategy and planning tools. These tools will be used for business planning, analysis, and decision-making. What You Will Develop You will build Excel tools and frameworks, such as: Planning and evaluation tools Scoring and comparison models Tracking and analysis templates Structured decision-support frameworks

I’m ready to turn a brand-new Zoho account into a fully functioning CRM that streamlines our entire sales cycle. My only goal for Zoho at this stage is CRM management, so every task revolves around perfecting lead management, sales tracking, and customer support inside Zoho CRM. What I need you to do • Design the data model: build the custom fields and tailored layouts that match the way we collect and view information. • Automate the routine: create custom workflows that capture leads, route them to the right owner, trigger follow-ups, update deal stages, and open support tickets when required. • Connect the stack: integrate Zoho CRM with the other tools we already rely on (I’ll share the list and API keys), ensuring data flows cleanly in both directions....

Project Title MS Access CRM + Quoting + Line-Level Costing + Production Workflow (multi-user ready, split DB planned) Goal Build a complete Microsoft Access application from zero that manages: Leads → Customers → Projects → Quotes → QuoteLines (each line can have its own version v1/v2…) Line-level costing and part-level breakdown Approvals, revisions, release to production Production machine lists and phase tracking Task management for all roles Document/file linking with a standardized folder structure Reports (Quote PDF, Production Pack PDF, KPIs) Role-based login + menu + permissions Designed to be split (FE/BE) for multiple concurrent users. 1) Data Model (developer must create all tables + relationships) 1.1 Master tables Users UserID (PK, Aut...

I’m ready to commission a custom PostgreSQL-based system that brings four critical workflows into one place: • Inventory control with real-time stock level monitoring and fast barcode scanning for check-in / check-out. • Employee schedule management so I can see who is assigned to each job at a glance. • Job costing and progress tracking that ties labor, materials, and overhead together for accurate profitability insights. • A secure API endpoint that pushes material usage from each job directly into QuickBooks, eliminating double entry. You will design the data model, build the web interface (any modern stack you’re comfortable with), and implement the QuickBooks integration. Clean, well-documented code and straightforward deployment instructions ...

I need a Power BI specialist to connect directly to my Xero tenant and turn the raw accounting data into a single-page dashboard that supports interactive drill-downs. The goal is to give senior management an at-a-glance view of our Profit & Loss along with the following KPIs: • Admin Wages : Total Revenue % • Revenue Growth Rate • Net Profit Margin • Total Available Cash - Subcontractor Exp : Total Revenue % Etc The visual must open with a clean overview, then allow users to click into any metric to see underlying transactions or monthly trends without leaving the page. Please set the data model up for scheduled refreshes daily and keep the file portable (no custom visuals that need additional licenses). Deliver the finished .pbix file plus a short note ou...

I want a clean, automated bridge between our Salesforce org and Power BI so I can see the story behind our numbers at a glance. The job starts with pulling three data groups—sales figures, customer records, and performance metrics—directly from Salesforce. Those sets feed a single data model in Power BI that refreshes on a schedule I can control. From that model I need three visual workspaces: a sales performance view that tracks revenue against targets, a customer-demographics snapshot that breaks down who is buying, and an employee-performance view that compares reps by key KPIs. On top of the dashboards I also need competitive leaderboards: one that ranks reps by sales volume and another that highlights overall employee performance. Each board should update automatically, d...

Job Title: Workday Extend (Support Role) Duration: 2 Hours per day Budget: ₹26,000 monthly Role Overview We are looking for an experienced Workday Extend Consultant to provide short-term, session-based technical support. The consultant will work on building, enhancing, and troubleshooting custom applications developed on the Workday Extend platform. Key Responsibilities Develop and support custom applications using Workday Extend Configure business logic, data models, and security frameworks Troubleshoot Extend applications and resolve functional/technical issues Support integrations and REST-based services where applicable Provide live, screen-sharing based guidance and best-practice recommendations Required Skills Strong hands-on experience with Workday Extend Knowledge of Workday ob...

I am looking to develop a decision-support algorithm that identifies and ranks the best production options across locations, varieties and time windows, based on a large set of variables. The model should evaluate each option using economic factors (costs, prices, margins), agronomic performance (yield, quality, timing reliability), logistics (distance to market, transit time, reliability), and risk (climate, water, regulatory, operational). The algorithm must first eliminate non-viable options using hard constraints (e.g. feasibility, minimum thresholds), and then score and rank the remaining options using a weighted, configurable logic that produces a single comparable score per option. The goal is not pure prediction, but a transparent and scalable optimization engine that supports bett...

I want to turn the raw figures sitting in my Google Sheets into a clean, interactive Looker Studio dashboard focused entirely on sales performance. All the numbers you’ll need—orders, revenue, units, discounts, and anything else relevant—are already structured in Sheets, updated daily. The job is to connect that sheet to Looker Studio, build the data model, and design a dashboard that lets me drill down by product, channel, region, and date range without ever touching the underlying spreadsheet. Core objectives • Seamless, automatic connection to Google Sheets (no manual refreshes). • Visuals that instantly answer: What are today’s sales? Which products are driving growth? Where are we missing targets? • Filters for date, product category, geog...

Power BI Dashboard Connected to Google Sheets – Stock Trading Analytics Project Overview I am looking for an experienced Power BI developer to build a dynamic trading analytics dashboard connected to Google Sheets. The solution must follow Power BI best practices, use proper data modeling, and support automatic refresh without manual intervention. ⸻ Data Source (Google Sheets) The dashboard will connect to Google Sheets containing the following tables: 1. Clients Master Columns: • Client Code (unique) • Client Name • Opening Cash Balance 2. Trades Table Columns: • Trade Date • Client Code • Stock Symbol • Buy / Sell Indicator • Quantity • Trade Price • Brokerage Amount 3. Live Price Table Columns: • Stock Sy...

Project Title Database Design & SQL Implementation – Content Management System for Movies and Series (Access Control & User Groups) Project Description I am looking for a database developer or DBMS expert to help design and implement a Content Management Database System for managing movies, series, and episodic content with hierarchical user groups and multi-level access control. This project simulates a real-world digital content platform (similar to a streaming service backend) and focuses on ER modeling, relational schema design, and SQL implementation. Scope of Work 1. Database Design Create a complete ER Diagram including: Content (Movies & Series) Series and Episodes Users User Groups (with nested group hierarchy) Access Levels Reviews and Ratings Con...

I’m looking for a senior systems architect to design the technical foundation for a payment-gated booking network that controls access to real-time, high-demand service slots. From the user’s perspective, the flow is simple: select a slot → pay → receive instant confirmation. Behind the scenes, the platform must reliably handle concurrency spikes, subscription validation, atomic booking, and fast payment settlement, while guaranteeing zero double-booking. This is an architecture-first engagement. No UI or app build is required at this stage. Core Objectives Model the end-to-end flow for payment-gated real-time bookings for high-demand services. Design a subscription layer that wraps booking access. At launch we will offer a single monthly plan; the architecture m...

Busco a quien diseñe y ponga en marcha nuestros tableros de control en Power BI para una pyme. Alcance inicial • Crear dashboards interactivos que resuman las áreas de Ventas y Finanzas. • Priorizar visualizaciones con gráficos de líneas; si algún indicador lo exige, puedo aceptar otras vistas complementarias siempre que la narrativa principal se mantenga clara. • Conectar los tableros a mis datos ya organizados y dejar programada la actualización automática. • Documentar brevemente las medidas DAX clave y la lógica de cada página para que el equipo interno entienda los cálculos. Soporte continuo Acordemos un paquete de hasta 10 horas mensuales para mantenimiento: ajustes menores, incorpo...

Preciso de um dashboard em Power BI focado exclusivamente em dados de vendas. Quero que a principal métrica em destaque seja a receita gerada e que, sempre que fizer sentido, essa informação apareça em gráficos de pizza. Escopo básico: • Conectar-se à minha base de dados de vendas (posso fornecer arquivo Excel, CSV ou link SQL). • Modelar as tabelas para garantir atualização automática. • Criar páginas limpas e responsivas, usando principalmente gráficos de pizza para distribuir a receita por produto, região e período. Outros tipos de visualização podem ser incluídos se ajudarem a contar a história, mas o gráfico de pizza deve permanec...

Título: Power App Model-Driven — Gestión de Pedidos de Libros Presupuesto: $200 - $250 USD (Precio Fijo) Descripción: Busco un desarrollador con experiencia en Power Apps (Model-Driven) y Dataverse para crear una aplicación sencilla de gestión de pedidos de libros. ¿Qué necesito? Tengo un negocio de venta y distribución de libros. Hasta ahora vengo manejando todo con un archivo Excel, pero ya me quedó chico. Necesito una Power App (preferiblemente model-driven) que me permita llevar el registro de mis clientes y sus pedidos, preparar las órdenes de compra a mis proveedores, y registrar los envíos que hago a los clientes (shipping log). Voy a compartir mi archivo Excel para que veas los datos que manejo actua...