Data Modeling Jobs

I have a clean historical-weather spreadsheet and I want to turn it into a set of engaging dashboards and interactive 3d models. I am trying to prove a thesis that wind direction during winter months contributes to snow blocking a road. The key stories I need to see are: • Predominant wind direction, average wind speed, and peak gusts broken down month-by-month. These should be sliders on a model. • Daily snow-depth trends across the winter, with an overlay or clear link to the prevailing wind direction on each day or month. Focus is on Dec-March Please build whatever pivot tables, Power Query steps, or helper columns you feel are necessary and then surface the insights in a mix of 2D and 3D models—I’d like to be able to switch between the two for presentations. ...

Database Migration Specialist: MySQL to Supabase/PostgreSQL We're looking for a data migration expert who doesn't just move data — you ensure it arrives clean, complete, and production-ready. You have deep experience migrating large-scale databases and understand the nuances of moving from MySQL to PostgreSQL in Supabase environments. What You'll Do: - Plan and execute end-to-end migration of large MySQL databases to PostgreSQL on Supabase - Audit source data for inconsistencies, duplicates, and schema incompatibilities before migration - Design and implement migration scripts, transformation logic, and validation checks - Handle data type mapping, constraint differences, and stored procedure conversions between MySQL and PostgreSQL - Perform dry runs, staged migrati...

The task is to build an interactive Power BI dashboard that visualises my organisation’s consumption volume. All data sits in a set of Excel spreadsheets and must stay synced automatically, so the model should refresh cleanly whenever new files overwrite the existing ones. Key focus • Showcase yearly comparisons of total consumption, with clear visuals that allow users to spot growth, decline, and outliers at a glance. • Simple slicers or filters for year, product line, and region (the columns are already present in the source files). • A clean layout that can be shared through the Power BI service without additional configuration on my side. Data • Excel workbooks reside in a OneDrive folder; Power BI should connect directly to that location to preserve the...

My existing Power BI report pulls several large tables from Microsoft Dynamics 365 Business Central through the standard API. The model works, but the scheduled refresh now fails with frequent time-outs; reliability is my biggest concern. So far I have: • enabled incremental refresh on the largest tables • tuned a handful of queries • experimented with splitting data into smaller API calls None of these measures has eliminated the failure. I need an expert who can: 1. pinpoint the exact bottleneck within the current data model, gateway settings, or API calls 2. redesign the retrieval strategy so the report finishes every refresh window without timing out 3. leave me with a clean, documented PBIX (or dataflow) that follows best practice for query folding, pa...

I have a CSV file containing several thousand input-output pairs and I’m looking for a fresh analytical perspective on whether any meaningful statistical pattern exists in the data. The dataset is purely numerical and abstract, so it can be approached using any appropriate mathematical or statistical techniques such as correlation analysis, transformations, dimensionality reduction, information-theoretic measures, or other exploratory methods. What matters most is evidence. I would like to determine first whether the outputs can be reliably modelled from the inputs, and second, what kind of mathematical structure might explain any observed relationship. If a reproducible pattern emerges, the goal would be to characterize it and assess how well it generalizes to unseen rows. If the d...

I need an interactive Power BI dashboard that turns the raw data coming from our project-management tool into clear, actionable employee-performance insights. The goal is to track operational metrics such as task throughput, on-time delivery rate, average cycle time, and workload balance so team leads can spot bottlenecks and coach in real time. You will connect directly to the project-management platform’s API or flat-file exports, build a clean data model, and write the DAX needed for accurate calculations and time-intelligent trends. Visuals should follow good UX practices—consistent colour palette, dynamic tooltips, and intuitive slicers—so non-technical managers can explore the numbers without guidance. Deliverables: • A fully functional .pbix file with data m...

I'm seeking an expert to help normalize my SQL database to the 2nd Normal Form (2NF). The primary goal is to reduce redundancy. Key Requirements: - Expertise in SQL databases - Strong understanding of 2NF principles - Experience in database normalization Ideal Skills: - SQL proficiency - Database design and architecture - Problem-solving skills for redundancy issues Please provide relevant experience with your bids.

Here are some important exam details: Logistics: You will have the full 90 minutes to complete the exam. No Cheat Sheet/Calculators: The exam is closed-book, and no sheets are allowed. You will not need a calculator for the exam, as most questions are conceptual or will not require much calculation. As such, calculators are not allowed. Format: The exam will consist of multiple-choice (with no partial credit), short answer, and long form answer questions. Content: Modules 1-9 (see below for module names) from the beginning of the semester up to and including this Thursday's lecture (2/19) will be included on the exam (each module will be represented approximately evenly, and we will mainly focus on the content in the HWs and lectures). Module 1: Intro to Big Data Analytics Modu...

I am building a backend service that acts as a decision layer between an internal platform and multiple external service providers. This is not a simple integration bridge. The goal is to design a scalable, extensible decision engine that: • Normalises heterogeneous API responses into a canonical internal schema • Applies configurable business rules to determine optimal outcomes • Abstracts external providers behind adapter contracts • Allows new providers to be added without modifying core logic The first external provider integration will serve as a reference implementation. However, the architecture must support rapid onboarding of additional providers via a pluggable adapter model. ⸻ Core Requirements 1️⃣ Canonical Data Model Design a clean internal schema...

End-to-End Petroleum Logistics Visibility Dashboard (Excel + Power Query, Power BI-ready) 1. Background & Objective We operate a bulk petroleum logistics and distribution business involving: • Import of petroleum products at Dar es Salaam • Storage of petroleum at depot in Dar es Salaam • Dispatch through petroleum tanker fleet (owned and 3PL) • Cross-border transportation through Tanzania → Zambia → DRC • Delivery into owned depots and client depots in DRC • After offloading, trucks return empty from DRC → Zambia → Tanzania • In Dar es Salaam, trucks go to workshop for maintenance, and then go to depot for loading • In DRC, Last-mile distribution from our owned DRC depot to end customers in owned-local truck fleet Currently, ...

Overview We are hiring 3 experienced Data Scientists to participate in a structured data challenge as part of a paid engagement. This is not a generic Kaggle-style competition. You will be exploring an AI-native data platform, analyzing real-world event data, and submitting a structured, reproducible project. If selected, you’ll be compensated for your participation and submission. What You’ll Be Doing Explore a new AI-powered data workspace Analyze user behavior/event data Define your own success metrics Build insights using statistical/ML techniques Submit: A complete reproducible data project A written summary explaining methodology and findings A public project link You will be working individually. Ideal Candidate We’re looking for someone who: Has basic under...

I’m ready to turn an idea I’ve been sketching for months into a fully-functional AI meal-planning application. The core of the product is clear: it must serve truly personalized meal recommendations for every user, factoring in tastes, caloric goals, schedule constraints and available ingredients. From there the app should instantly convert those suggestions into a clear, shareable shopping list so users can head to the store (or an online cart) without extra clicks. Dietary coverage starts simple—vegetarian and non-vegetarian options both need first-class support. I’m open to adding further filters such as vegan or gluten-free once the foundation is solid, so structuring the data model with extensibility in mind is important. I picture an intuitive mobile experi...

Job Title: Data Architect — Azure & Databricks Key Responsibilities Design and govern scalable data platforms using Azure and Databricks. Define end-to-end data architecture (ingestion, storage, processing, modeling, serving) based on Lakehouse and governance principles. Establish data modeling standards and architecture best practices. Architect and optimize data pipelines using Databricks, Delta Lake, and Azure Data Factory. Implement CI/CD and environment management using Databricks Asset Bundles and automation tools. Drive performance optimization across Spark, SQL, and Python workloads. Apply software engineering best practices (modular design, testing, CI/CD) to data solutions. Partner with business and analytics teams to translate requirements into scalable archit...

Our Laravel application relies on a straight-forward relational model, yet the most common complaint from users (and my dev team) is slow performance, CORS errors and out of memory problems... Too much processing lives in PHP memory; too little happens inside MySQL where it belongs. Over the next week—roughly fifteen hours of your time—I want to sit down with someone who immediately asks: • “What’s the data model?” • “What’s the cardinality?” • “What’s the growth curve?” • “Can we aggregate this in SQL?” • “What are the indexes?” You’ll review our existing schema, study out of memory issues, walk the team through moving processing from laravel/memory to t...