Data Warehousing Jobs

I need a Snowflake-savvy analyst to put a rock-solid data-validation layer in place. The immediate task is to design and implement validation routines that run inside our Snowflake environment, check incoming tables against business rules, and surface any accuracy issues before the data is consumed downstream. Here’s the flow I have in mind: raw data lands in Snowflake, your scripted tests execute, exceptions are logged to an audit table, and a concise accuracy dashboard or CSV summary is generated so the business team can act quickly. Everything must be fully documented so future analysts can extend or modify the checks without hunting for logic buried in code. Key points • Scope: data validation only—no transformation or reporting build-out at this stage. • Go...

Real-Time Data Pipeline Project Overview This term project involves building an end-to-end data pipeline using big-data tools and streaming technologies. The system will ingest data, process it in real-time with machine learning algorithms, and store analysis results for visualization. Key components proposed include Apache Kafka for data streaming, Apache Spark (Streaming) for real-time processing, Apache Hive (or Hadoop HDFS) for data warehousing, and MongoDB for storing processed results. All code will likely be written in a high-level language (such as Python via PySpark) to integrate these components. Below, we break down the project requirements and plan into specific sections. Big Data Tools and Frameworks: The pipeline will leverage the following technologies: • Apache Kafka: ...

I need a hands-on mentor who can take me from absolute beginner to confident BigQuery user in just seven days. My priority is to get comfortable writing efficient SQL queries inside BigQuery, understanding how the underlying storage works, and seeing how those queries translate into real business insights on live data. Here’s the rhythm I have in mind: daily one-on-one video calls (60-90 min each) where you walk me through practical scenarios drawn from your own production experience. After every call I’ll work through the same dataset on my side, then we review the results at the start of the next session. By the end of the week I should be able to design a schema, load data, build and test complex queries, and explain the cost implications of each step. What I value most is...

I need a Tableau dashboard to visualize key sales metrics. The dashboard will be used by analysts. The metrics to include are: - Total Revenue - Sales by Region - Product Performance Ideal Skills and Experience: - Proficiency in Tableau - Experience with sales data visualization - Ability to create interactive and insightful dashboards for analytical purposes Please provide samples of previous Tableau dashboards.

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’m looking for an experienced data-engineering professional who can design and deliver a structured training program tailored to a single learner. The focus will be on practical, job-ready skills—think data warehousing concepts, modern ETL tooling, and big-data best practices—yet I’m open to refining the syllabus together so it precisely matches the learner’s current level and career goals. Schedule and delivery format are flexible; online sessions are perfectly fine, but if you have other ideas for maximizing engagement, let’s discuss them. I’ll handle logistics such as access to labs or demo environments as needed, while you concentrate on crafting clear explanations, hands-on exercises, and real-world case studies that illustrate how today&rsq...