Data Warehousing Jobs

A data warehouse is a key component of business intelligence, and is the core of data reporting and analysis. Data is uploaded from systems such as marketing and sales, and is stored with recent data alongside historical. This allows for comparisons to be made, and trends to be observed in terms of a business’ success. A typical data warehouse uses an ‘ETL’ model, meaning that the data goes through a process of extraction, transforming and loading. The end result is an organized, retrievable set of data, often with extraneous data removed during the process through ‘data cleansing’.

Data is organized into hierarchical groups, and categorized as either facts or aggregate facts. Managers and business professionals are then able to use the data for market research and decision support.

Hire Data Warehouse Experts

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    3 jobs found, pricing in CAD

    - Strong Banking Domain (Commercial Lending & Mortgage) knowledge required (Black knight/Empower ) - Requirements gathering, documenting BRD & FRD, business process flow, workflow /swim lane diagrams using Visio - Knowledge of Jira, Confluence - Liaison with multiple stakeholders (business & technology & PMO office - Strong Datawarehouse knowledge (OLAP, OLTP, Star/ snowflake schema, 3NF Denormalization, Dimensional modeling) - Identify data elements for Loan Origination source systems to loan servicing & underwriting systems - Ability to create custom & canned reports - Data Analysis using SQL queries (strong) - Data mapping skills (source to target) - Data quality & metadata management - Data Governance & Data Management skills Environment: - Teradata

    $15 / hr (Avg Bid)
    $15 / hr Avg Bid
    6 bids

    1. Gather Biz & Data Requirements for Mortgage bank biz 2. Data Acquisition & transformation 3. Data mapping 4. Analyze different data sets by running complex SQL queries 5. Teradata database knowledge required 6. Jira reporting & project management 7. Strong datawarehousing knowledge, star, snowflake schema 8. Knowledge of OLAP, OLTP & Data Quality , Data Governance 9. Knowledge of Mortgage biz process flow (Loan origination, servicing & underwriting) & various data elements/schemas

    $9 / hr (Avg Bid)
    $9 / hr Avg Bid
    12 bids

    Hi, We need to import data from various data sources to Elasticsearch over AWS. We have observed the AWS Matillion data exchange service can be a good fit for our data warehouse(Elasticsearch) but we are open to hear more (AWS data exchange related automated solutions). Please share your proposal with small description of your suggested solution along with price. NOTE: The solution is required to be based on any of AWS data exchange service where data sources can be setup for import to Elasticsearch.

    $129 (Avg Bid)
    $129 Avg Bid
    16 bids