Data Warehousing Jobs

Operations Data in my last company Collaborate with business stakeholders to gather functional requirements and translate them into scalable BI reporting solutions. • Designed and implemented robust data integration workflows by consolidating data from Excel, SharePoint, Salesforce, and SQL Server into a centralized reporting model. • Performed comprehensive data profiling, cleansing, transformation, and modeling using Power Query (M) to deliver high-quality, analysis-ready datasets. • Designed and developed dynamic dashboards using custom visuals, hierarchical drill-down structures, geo-maps, and drill-through features to enhance analytical depth and improve strategic business decisions. • Proficient in advanced DAX (YTD, QTD, MTD, YoY, MoM), performance optimization ...

**AWS Data Engineer Needed — 1:1 Mentor/Tutor** I’m looking for an experienced **AWS Data Engineer** for ongoing 1:1 mentoring to help me develop practical, job-ready AWS Data Engineering skills. **Looking for someone who:** - Has **real-time/production experience as an AWS Data Engineer** - Has hands-on experience **building, deploying, and maintaining data pipelines on AWS** - Has worked with services such as **S3, Glue, Redshift, Athena, Lambda, Kinesis, EMR, and Step Functions** - Can teach **Python/PySpark, SQL, ETL/ELT, data lakes, and data warehouses** - Can explain **real-world production workflows, pipeline architecture, and best practices** - Can guide me through hands-on work and practical scenarios **Format:** 1:1 video sessions, weekly or biweekly **Duration:*...

I’m looking for hands-on help building and optimising data-engineering workflows inside Databricks. My immediate focus is on ingesting data that arrives in two ways—batch loads from relational databases and real-time streams—then transforming, testing and storing it so downstream analytics teams can trust the output. Here is what I need from you: • Design and implement robust ingestion pipelines that pull incremental data from the source databases and process the streaming feeds with minimal latency. • Develop scalable transformation logic inside notebooks (PySpark / SQL) and package reusable jobs so they can be scheduled and monitored through Databricks Workflows. • Advise on cluster configuration, performance tuning and cost-efficient autoscaling as...

I need a Power BI report that gives me a clear, interactive view of how our organisation is performing day-to-day and month-to-month. The focus is strictly on performance tracking, so the visuals should surface key KPIs, trend lines and drill-through details that let me spot bottlenecks quickly and take action. You will take the raw data I provide, model it cleanly, then design an engaging dashboard that updates automatically. Card visuals, custom tooltips, slicers and bookmarks are all welcome if they help users move from the high-level picture down to granular insights in just a few clicks. Deliverables • Finished .pbix file with all measures, relationships and visuals in place • A brief walkthrough or recording that explains how the report is structured and how to refres...

I need a hands-free SQL workflow that runs every 24 hours and reliably moves raw data all the way through extraction, transformation, and loading so it is analytics-ready each morning. I have not locked myself into a single platform yet, so whether you prefer MySQL, PostgreSQL, or Microsoft SQL Server, please build with portability in mind and note any engine-specific features you use. Robust logging, error handling, and clear configuration (no hard-coded secrets) are essential because I want to monitor runs without hovering over them. Deliverables • Code or stored procedures that handle: – Data extraction – Data transformation – Data loading • A scheduler setup (native DB agent, cron, Task Scheduler, or similar) that triggers the pipeline dai...