DATA WAREHOUSE & MODELING EXPERT NEEDED
Descrição da oferta de emprego
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
Detalhes da oferta
- Indeterminado
- Em todo Portugal
- Indeterminado - Indeterminado
- 06/11/2024
- 04/02/2025
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......
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)......
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......
@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......
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......
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......
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......
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......
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......
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......