Data Modeling Jobs

I already have Google Analytics running for several client sites, but I need an expert who can take the implementation further and connect it seamlessly with Google Looker. The immediate goal is two-fold: first, ensure we are accurately tracking website traffic and on-site user behavior; second, turn that data into clear, actionable dashboards and custom reports inside Looker. At the moment only Google Analytics is live—Looker has not been configured. I want to capture and surface user demographics, behavior flows and traffic sources, then visualise those insights so clients can read them at a glance. If GTM, GA4 property adjustments or custom event tagging are required, factor that into your approach. Deliverables I need from you: • Audit the existing Google Analytics setup a...

I built a financial database in Microsoft Access and currently keep the tables on SharePoint so I can open the file from any workstation. It works, but it’s clunky and slow, and I have finally decided to turn it into a proper cloud-based application running on Microsoft Azure. Here is what I need: • Re-create the existing data model and logic from the Access file (forms, queries, reports, VBA where applicable) as a modern web app hosted on Azure—SQL Database or other native storage that makes the most sense is fine, as long as everything ends up fully managed in the Azure stack. • Migrate the current SharePoint-hosted tables and all live data with zero loss or corruption. • Build a straightforward email-and-password authentication flow and layer user access...

The goal is to sharpen the exact skills a senior-level data engineering interview will probe so that I walk in confident and ready. After twelve years on the job I already know the fundamentals; what I need now is a structured series of sessions that target two key areas: • Deep-dive technical mastery, specifically python, sql, Hadoop, Spark and Kafka • Rigorous case-study style problem solving, mirroring the whiteboard or live-coding format used by most FAANG-scale companies Each session should pair concise theory refreshers with hands-on exercises—think cluster configuration walk-throughs, optimisation scenarios, streaming pipeline design and end-to-end data-flow troubleshooting. I also want timed mock interviews where you fire real questions, then give immediate, ...

Project Title: Power BI Dashboard for Multi-Year Agricultural Location Tracking & Hybrid Performance Analysis Project Description: I need an experienced Power BI developer to build a complete analytical dashboard based on multiple Excel datasets organized year-wise and location-wise. The client’s data structure is as follows: - Data is divided by years (2023, 2024, 2025…) - Inside each year, data is split into multiple main locations - Each main location contains multiple sub-locations - Every year these locations/sub-locations shift or change - Each sub-location contains performance data, gender data (Male/Female), hybrid results, comments, and gene information Core Requirements: 1. Data Understanding & Integration - Import multiple year-wise Excel files into Power...

I want a Power BI dashboard that lets me monitor operational efficiency at a glance. The focus is on three metrics—employee productivity, process times, and resource utilization—pulled from a single existing system. You’ll connect directly to that source, clean and model the data, then design an intuitive report with interactive visuals (think slicers, drill-through, and dynamic tooltips) so managers can spot bottlenecks immediately. Deliverables • PBIX file with all queries, data model, measures, and visuals • Step-by-step connection notes so I can refresh the data myself • Brief recorded walk-through (screen capture is fine) highlighting how to use each page I’ll provide credentials and a sample export as soon as we start. If somethin...

I'm seeking an expert to create a price optimization model using Van Westendorp survey data and its extensions (Newton, Miller, Smith). Key Requirements: - Optimize for revenue - Work from existing Excel data Ideal Skills and Experience: - Strong background in pricing strategies - Proficiency in data analysis and Excel - Experience with Van Westendorp and NMS extensions

Database Design & Development Assignment Assistance I’m looking for an experienced Database Developer or Academic Expert to assist with my HND (Higher National Diploma) in Computing – Unit 4: Database Design and Development assignment. The goal is to design, implement, and document a relational database system as per Pearson BTEC HND standards. The work should be academic-quality, original, and well-structured to meet Pass, Merit, and Distinction (P/M/D) criteria. Key Deliverables: Database Design Document (LO1) Requirements analysis and design specification Entity Relationship Diagram (ERD) Normalization (up to 3NF) Data dictionary and relationship mapping Database Implementation (LO2) SQL scripts for database creation and table design Sample data population Qu...

We are a real estate development and property management group managing 26 properties and ~850 rental units, and we are looking to build a fully automated, centralized rental monitoring system using Google Sheets, Google Drive, Google Apps Script, and Looker Studio. We already have a Google Sheets template with consistent columns across tabs, and we recently created a new Master_Units tab structured for automation. Now we need a freelancer to connect the system together and build the automation layer. What We Need Built 1. Automated Data Import From UpperBee UpperBee (our property management software) can export unit data as XLSX/CSV. We need a script that: Reads the export file automatically from a Google Drive folder Extracts unit information (status, rent, tenants, dates, etc.) Ma...

"I WILL EXPLAIN WHOLE REQUIREMENT IN DETAIL ONCE WE CONNECT" Brief Summary of requirement is as under: I have a retail store. I have about 3000 products in the store. I have weekly sale summary of all the products for the last 24 months. Now based upon 24 months sales summary, I want to predict my future sales number for every product. Please note that my aim is that neither I should be out of stock ever nor should I have dead stock with me ever "I WILL EXPLAIN WHOLE REQUIREMENT IN DETAIL ONCE WE CONNECT"

I’m preparing for an upcoming interview where I need to speak confidently about SAP Analytics Cloud planning projects. My focus areas will be budgeting, forecasting, and profit-and-loss analysis, so I want to be able to demonstrate a clear end-to-end story that connects SAC Planning features with the most relevant S/4 HANA tables and CDS views. Here’s what I expect from you: • A concise knowledge-transfer session (or series of short calls) that walks me through how a real-world SAC Planning project tackles budgeting, forecasting, and P&L—from data acquisition to story creation and publishing. • A quick-reference sheet that maps the key S/4 HANA tables and commonly used CDS views to each planning scenario. I’m not sure which tables are best, so I&rs...

Job Title: Senior Data Engineer – Work Support (Multiple Projects) Location: Remote About the Role: Looking for highly experienced Data Engineers (10+ years) to provide work support and real-time technical guidance to professionals working on US-based data projects. The role involves mentoring, troubleshooting, task validation, and project assistance on a daily basis. Key Responsibilities: Provide end-to-end support for data engineering tasks handled by candidates. Help design, build, and optimize ETL pipelines and data workflows. Troubleshoot and resolve performance or integration issues in real-time. Guide candidates through daily deliverables and project requirements. Ensure quality, accuracy, and timely completion of all assigned tasks. Technical Expertise Required: Str...

I need a seasoned data engineer who can move key datasets out of Sage 300 Construction & Real Estate and land them cleanly in my Azure Data Lake. The scope starts with two data domains—financial data and project-management data—pulled through the Sage 300 API. Once the raw tables are in the lake, I want robust relationships built so that: • financial data can be joined directly to project data • those joins remain extensible enough to accommodate future links to external data sources (for example, CRM or scheduling tools) With that unified model in place, the final step is a set of Power BI dashboards. The first release should surface revenue-and-expense trends and highlight project completion and performance metrics. Visual clarity, fast refresh times, and cl...

I need a solid Power BI build that pulls together three separate data sources—our live MySQL database, several Excel workbooks, and a handful of CSV files—into one clean, refreshable tabular model. Once the data is shaped and related properly, the goal is to surface the key metrics in interactive bar and pie charts that tell the story at a glance. You’ll connect through Power Query (ODBC for MySQL), normalise the tables, create any necessary DAX measures, and lay out the initial report pages in the company colour palette. All work must live inside a single PBIX file that refreshes without errors and matches the control totals I supply. Deliverables • PBIX file with automated connections to MySQL, Excel, and CSV data • Star-schema/tabular model with documen...

Empormontt seeks to migrate seven years of financial and operational data from its existing Exact Globe and Exact Synergy platforms into ACES, the company’s new SQL Server–based Port Management System. The project covers the full data lifecycle—from analysis to final load—across multiple databases containing DEM/DRM port-service liquidations, invoicing records, general ledger transactions, and all supporting structures required for complete accounting traceability. Every source table must be accurately mapped, transformed, and loaded into the ACES relational model without loss of context or integrity. Data accuracy, field-level validation, format consistency, preserved timestamps, and full end-to-end auditability are mandatory. Since both environments run on SQL Ser...

I have a fully-functioning Tableau workbook that connects to an SQL database. I now need an exact replica of that model, but built so it also incorporates two additional existing worksheets I will provide. Beyond the straight copy, I already have a short checklist of improvements—layout refinements and one calculated field change—to be worked into the new version. You’ll get the current .twb file, credentials for the same SQL data source, and the two sheets I want merged. Once your updated workbook mirrors the original visuals, links flawlessly to the database, and reflects the requested tweaks, simply return the packaged file for review. When you reply, point me to past Tableau projects that show you can pick up an existing structure, duplicate it cleanly, and make foc...

Please Sign Up or Login to see details.

Experto en Bases de Datos para Implementación y Automatización con NocoDB & n8n Descripción breve: Busco un especialista en bases de datos y automatización que diseñe, construya y deje completamente funcional mi base de datos operando en NocoDB, integrada mediante n8n para automatizar flujos de trabajo y operaciones básicas (alta, baja, modificación, consultas y notificaciones). Requisitos mínimos: Experiencia demostrable con NocoDB y n8n. Diseño del modelo de datos a medida según mis necesidades (definirás tablas, relaciones, permisos y vistas). Configuración de n8n para automatización y enlace con NocoDB (ejemplo: CRUD de registros, disparadores automáticos, integración con o...

Tengo un informe en Power BI que funciona, pero quiero llevarlo al siguiente nivel. Necesito optimizar la integración de datos —actualmente llegan desde 1 a 5 hojas de cálculo de Excel— para que el modelo se refresque automáticamente cada vez que esos archivos cambien. Además, busco que el reporte luzca más profesional y resulte más intuitivo para el usuario final. En la práctica, esto implica: • Reestructurar el modelo en Power Query / DAX para que la conexión con los Excel sea limpia y escalable. • Configurar la actualización programada (o un gateway si hiciera falta) de modo que el panel se renueve sin intervención manual cuando los documentos fuente se modifiquen. • Pulir la parte visu...