Ir à oferta completa

DATA WAREHOUSE & MODELING EXPERT NEEDED

Descrição da oferta de emprego

Data Engineering.
Design Data Warehouse, Data Model, ELT / ETL Data pipeline.
1.
Click above RawDataSet link and download 3 datasets.
AUS_SubCityDistrictState_Data,NSW_PropertyMedainValue, and NSW-Public-Schools-Master-Dataset.
2.
Use Visual Studio and create SSIS package, design dataflows to extract data from AUS_SubCityDistrictState_Data, NSW_PropertyMedainValue and NSW-Public-Schools-Master-Dataset (csv), and load data into tables into your Data Warehouse, use “load_” as prefix to name all your data load tables in your Data Warehouse.
3.
Follow Kimball dimensional modeling methodology, Design Snowflake Schema Model, or Star Schema Model including dimension and fact tables in Data Warehouse, use Bus Matrix and think about what dimension and fact tables you need to create.
If you use the Star Schema Model you might need to consider using the factless fact table, do some research about the factless fact table.
4.
Create another SSIS package and design dataflows to get Data extracted from load tables, then transformed and loaded into Snowflake Schema Model or Star Schema Model.
5.
You need a “Category” as a dimension table (or degenerate dimension in fact table), in SSIS categorize Median Value into Category k, $750k-$1.
M, $1.
M-$2.
M, $2.
M+ and load the “Category” values into dimension table (or degenerate dimension in fact table), this is a transformation of business requirements for Property Analysis.
Armazenamento de Dados Extração de Dados Administração de Bancos de Dados Geoespacial Ciência de Dados ID do Projeto.
# Sobre o projeto 9 propostas Aberto para ofertas Projeto remoto Ativo em 1 hora atrás
Ir à oferta completa

Detalhes da oferta

Empresa
  • Indeterminado
Localidade
  • Em todo Portugal
Endereço
  • Indeterminado - Indeterminado
Data de publicação
  • 06/11/2024
Data de expiração
  • 04/02/2025
Senior Data Engineer
FÓRUM SELECCAO

Fórum selecção is looking for a senior data engineer (m/f) for a corporate bank main activities: - design high-performance data pipelines (etl) to feed a dwh using state of the art data engineering techniques according to business specifications; - implement flow automation through ci/cd pipelines and......

Operations Expert
Newin

Skills: amazon web services (aws), esp... scrum independent, structured way of working and strong quality awareness high level of commitment and unrestricted ability to work in a team (work in self-organizing teams) eu based 100% remote optional, but appreciated skills: adobe experience manager (aem)......

Human Resources Payroll Consultant (HRIS)
Uniksystem -sistemas de informação,lda

As a candidate you’ve decided to provide us your personal data... who we are: unikystem is a low-code bpm automation platform boosted by cognitive data capture with 100% accuracy, that turns any unstructured text data into business-critical information... required skills and experience: being a big......

Junior Phyton NME and numpy developer
TEMPOSUSSURRANTE LTA

@confidentialnote: mne library of python will be used to explore, visualise and analysehuman neurophysiological data... ● clinic needs to click on “stop data stream” to stop the recording, after thesession is completed... ● once the board is set up, the clinic needs to click on “start data stream” tostart......

Bi consultant (m/f) – lisboa
Fórmula do talento

Responsabilidades: levar a cabo projetos no âmbito do desenvolvimento da oferta para os clientes, através de soluções de business intelligence / data analytics; propor e implementar melhorias nas plataformas e processos existentes; envolvimento direto em projetos estratégicos que visam desenvolver soluções......

Bi consultant (m/f) – lisboa
Fórmula do talento

Responsabilidades: levar a cabo projetos no âmbito do desenvolvimento da oferta para os clientes, através de soluções de business intelligence / data analytics; propor e implementar melhorias nas plataformas e processos existentes; envolvimento direto em projetos estratégicos que visam desenvolver soluções......

MAINTENANCE / TECHNICAL DEPARTMENT
Rainsteal Oil & Gas

Administrative department business analyst, payroll manager, marketing specialist, administration supervisor, human resources officer, financial analyst, senior marketing analyst, logistics coordinator / expert, procurement officer, secretary / office assistants / office clerks / front desk clerks, account......

.Net & React.js SW Developer
Uniksystem -sistemas de informação,lda

We also inform you that your data will be kept in the company for a period of 5 years... js (3+ years) experience with web applications (backend), distributed systems and apis preferred additional skills and experience: experienced in devops and promoter of automation mvc, jsf, jsp, j2ee, oo, distributed......

Senior QA Engineer
Equação it

Equação it is a company focused on boosting technology and solid solutions through our expert consultants leading a high perspective and adding value to our customers with the purpose of providing optimization and business growth to our partners... );• user acceptance testing knowledge;• cypress;• browserstack......

Junior Payroll Specialist
Cluster OSL

Responsibilities: manage and oversee all payroll functions for the company process payroll on a timely and accurate basis, including tracking hours worked, calculating pay, and deducting taxes and other withholdings ensure compliance with state and federal payroll regulations and reporting requirements......