Modelagem de Dados Jobs

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...

SAP HANA / SAP Analytics Role-Based Dashboard Development (Finance, Procurement, Production) Project Overview We are looking for an experienced SAP HANA / SAP Analytics consultant to design and implement a set of role-based executive dashboards that will allow us to monitor our company operations in a clear, fast, and strategic way. The dashboards must cover three core business areas: • Finance • Procurement • Production We require dashboards for 5 different user roles, each with customized access and KPI visibility: 1. Chairman of the Board 2. CEO 3. CFO 4. CPO (Chief Procurement Officer) 5. Production Manager The system must be clean, highly visual, drill-down enabled, and performance optimized. ⸻ Scope of Work 1. Role-Based Dashboard Architecture • D...

I am assembling a full-stack solution that ingests live financial databases, open-source macroeconomic feeds, and user-submitted figures, then turns all of it into forward-looking insights. The core of the product is an AI layer that delivers predictive analytics and runs configurable scenario simulations; the results need to surface instantly inside an intuitive web dashboard where users create and save their own reports and visual layouts. What I need from you is an end-to-end build: • Data layer – connectors that automatically pull structured and unstructured data from the three source categories above, plus a storage design that can scale as historical records grow. • ML & simulation engine – time-series forecasting models, Monte Carlo or agent-based simula...

I need a comprehensive costing model created. This model should be automated and take into account various pricing factors for procurement and IT services. Essential Requirements: - Pricing factors: Supplier prices, Logistics costs, Tax implications, FTE, - Input data: Excel spreadsheets - Automation is key - Must be delivered ASAP Ideal Skills and Experience: - Expertise in Excel and data modeling - Experience with procurement costing models - Strong background in logistics and tax implications

Proposal using CRISP-DM (not coding): •Describe problem, data, prep, modeling, evaluation •When doing Data analysis, add before and after measurement per company •Use this survey to extract the data structures and the data lookup: •Generate random dataset with 1000 records for the form shown at open-dma link above. Strictly from what the form offers!!! Generate Before and then a After dataset (a separate one with improved results). Save it to excel as and •Process the data in python •Create a function in python that will generate individual reports (word or PDF format) – sample 5 reports (for delivery), not 1000 and produce them as files. •Create visuals for the web report or individual reports as needed. •Elaborate any correlation between ...

Proposal using CRISP-DM (not coding): •Describe problem, data, prep, modeling, evaluation •When doing Data analysis, add before and after measurement per company •Use this survey to extract the data structures and the data lookup: •Generate random dataset with 1000 records for the form shown at open-dma link above. Strictly from what the form offers!!! Generate Before and then a After dataset (a separate one with improved results). Save it to excel as and •Process the data in python •Create a function in python that will generate individual reports (word or PDF format) – sample 5 reports (for delivery), not 1000 and produce them as files. •Create visuals for the web report or individual reports as needed. •Elaborate any correlation between ...

I’m refreshing my GitHub profile for upcoming university applications and I need a concise, well-architected Django backend that illustrates how I approach data modelling, API design and clean code. Tech stack is fixed: Python 3.x with Django (latest LTS). Because this is a portfolio piece, clarity, documentation and sensible project structure matter more than production-grade scaling or DevOps extras. Scope of the system The app should let authenticated users track items in and out of stock and generate simple reports. I expect models for items, categories and basic stock movements, JWT or session-based authentication, and a small reporting module summarising current inventory levels and movement history. Deliverables • Django project and apps organised with reusable, ...

Overview We are looking for a Senior Data Engineer to join the team that owns our core data product, the platforms and infrastructure that support it, and the data services consumed by our customers. You will work closely with other engineers, product stakeholders, and customers to design, build, and operate production-grade data systems, focusing on reliable ingestion, transformation, and exposure of data through APIs and product integrations. As a senior member of the team, you will be expected to help set technical standards, improve data quality and operational reliability, and contribute to shared ownership of systems from design through to reliable operation in production environments. What you’ll do • Design, build, and maintain data ingestion pipelines • Develop and...

I need a single, self-refreshing Excel solution that pulls every lawyer’s daily timesheet from our shared folder and rolls them into one master file. Power Query should pick up any new or updated workbook the moment I hit Refresh, clean the data, and store it in a structured table. From there I want totals by lawyer, by case, and by date, all available at a click. The management dashboard must offer both a quick high-level snapshot for partners and a drill-down view for finance, presented through pivot tables alongside clear charts and graphs. Think slicers that let us slice by matter number, lawyer, week, or month without waiting. Key items I expect: • Automated data import via Power Query • Data model that supports views by lawyer, case, and date simultaneously &bul...

I have a Computer Science systems-design assignment due in three days that focuses specifically on database design. I need a clear, well-structured submission that demonstrates solid theoretical understanding and practical application. Scope – Analyse the problem statement I will share and extract data requirements. – Produce an ER diagram, explain entity choices, relationships, cardinalities, and constraints. – Normalise the model up to 3NF, documenting each step and the rationale. – Provide the final relational schema with primary and foreign keys clearly indicated. – Supply brief written explanations (2–3 pages) that justify design decisions and reference best practices. Acceptance Criteria • Diagram delivered in a common format (PDF or...

I need my operational data—currently stored across several Excel workbooks—turned into interactive Power BI reports that make trend-spotting and drill-downs effortless. The focus is on robust reporting and analytics rather than a one-off dashboard, so the solution should be scalable and easy for me to refresh whenever new spreadsheets arrive. If you’re interested, send a detailed project proposal outlining the steps you would take to: • connect and clean multiple Excel sources • model the data for accurate relationships and DAX measures • design intuitive visuals that highlight KPIs, variances, and historical trends • deliver a ready-to-share .pbix file plus a short hand-off guide Everything will be built on Excel inputs for now, though I...

Project Overview Project Name: School Student Attendance System Goal: Build a system that allows teachers/staff to mark student attendance (possibly with location/time), notifies parents via push notifications when the student is ready for pickup or has been picked up, enables parents to confirm/view status, and handles basic student/parent/teacher data. Architecture: • Mobile App (Teachers / Parents) • Oracle APEX Backend (Admin / Reports / APIs) • Oracle Database Duration: 2 Months (8 Weeks) System Architecture 1) Mobile Application Users: • Teachers → mark attendance and deliver students • Parents → Students receive and students tracking. • Security → deliver students (optional) Features: • Login • Class & student list •...

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...

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...

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 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...