Data Wahrehousing Jobs

Project Objective We are building a complete reporting environment that connects our operational SQL database to a clean, intuitive Power BI reporting suite designed for two primary audiences: 1. Executive Leadership – high-level commercial insights and company performance 2. Operational Managers – actionable operational metrics and drill-downs The goal is to transform raw operational data into clear, reliable decision-making dashboards that update automatically and can be trusted across the organization. The final solution should deliver real-time business intelligence including revenue performance, operational activity, and commercial trends. ⸻ Data Environment Source System SQL Server operational database containing: • Sales transactions • Customers &bu...

I need an expert who can tap into our Lawson environment and pull the financial-side payroll information we keep there. The end goal is a clear, well-structured Excel workbook—no other format will do—containing every payroll field we agree on (earnings, deductions, taxes, cost center coding, and any other columns you know are standard for Lawson’s payroll tables). Here is what matters to me: • Source: Lawson (on-premise LSF, version 10) • Scope: Financial data tied specifically to payroll—nothing HR-only or attendance-related. • Delivery: A single Excel file, cleanly formatted and ready for pivoting or upload into Power BI. You may use whatever extraction method you are most comfortable with—Lawson SQL queries, the Lawson API, or an ETL...

I need a data engineer to implement liquid clustering with z-ordering to enhance performance. This project is critical for optimizing our data processing and retrieval speeds. Key Requirements: - Expertise in data engineering - Strong understanding of z-ordering and liquid clustering - Experience in performance optimization techniques Ideal Skills: - Proficiency in SQL and relevant data processing frameworks - Background in managing large datasets - Ability to work independently and meet deadlines Please provide examples of similar work and your approach to the task.

I’m kicking off a three-month, full-time engagement (with the option to extend) to move a sizeable customer data set from legacy sources into Salesforce while simultaneously wiring Salesforce into our wider application landscape through SnapLogic. The core objective is both migration and integration, so you’ll be hands-on across the entire data journey—from extracting millions of legacy records to building high-performance SnapLogic pipelines that keep Salesforce in sync with ERP, marketing, and other in-house systems. What the work looks like • Assess current data structures and map them cleanly to the Salesforce data model, respecting relationships, look-ups, and custom objects. • Build and optimise SnapLogic pipelines for bulk loads, transformations, and...

We are looking for a skilled professional with strong experience in healthcare data systems and data modeling concepts. The ideal candidate should have hands-on experience working with Electronic Health Records (EHR) data and a good understanding of clinical and Revenue Cycle Management (RCM) domains within hospital systems. Key Responsibilities •⁠ ⁠Work with healthcare data from leading EHR platforms such as EPIC, Oracle Cerner, MEDITECH, or other top-tier EHR systems. •⁠ ⁠Understand and model clinical and RCM entities, including relationships within hospital and healthcare ecosystems. •⁠ ⁠Apply Kimball modeling techniques and core data modeling concepts for analytics and reporting solutions. •⁠ ⁠Support data integration, transformation, and structuring for health...

I’m looking for someone who has already moved Microsoft SSIS workloads into Google Cloud and can guide me through a clean, production-ready rebuild of our existing pipelines. Right now the jobs pull from a mix of relational databases and nightly flat-file drops; the goal is to land everything in BigQuery with the same—or better—performance, data quality, and monitoring we have today. Here’s what I need from you: • Assess the current SSIS packages, map out every source table and file feed, and document the equivalent flow on GCP. • Design and build the new pipelines using native services (Dataflow, Cloud Data Fusion, Cloud Composer, or any combination you feel is best) with full error handling, logging, and retry logic. • Automate scheduling and...

I’m looking for a freelancer who can guide me in learning integration and configuration for Elite 3E, as well as Intapp, iManage, and Bhoomi along with database configuration and scheduling jobs/ task over databases. The ideal mentor can walk me through APIs in a live environment and help me understand how these applications work in practice, directly related to my day-to-day job responsibilities.