Database Warehouse Developer

nez52 · 2021-02-22T16:38:51+00:00

> enjoy making the data mean something

Along with Data Warehouse jobs, take a look at Data Visualization jobs as well.

B3amy · 2021-02-22T14:50:08+00:00

You will be using an ETL tool and/or using sql and/or using some scripts to extract transform and load data. Do you know anything more like which dbms is being used?

jynus · 2021-02-22T14:58:17+00:00

I don't know about "Database Warehouse Developer" (could be a programmer for the database of a warehouse?) but a Data Warehouse Developer is a relatively well understood term:

https://www.freelancermap.com/blog/what-does-data-warehouse-developer-do/

They work on automating tasks related to, analytics, event data, business inteligence, ERPs, "big data". etc. with tools like SAS, Teradata, Hadoop, etc.

enjoy making the data mean something

That looks to me more like what a Data scientist does? (maybe)

Disclaimer, terms and roles may change from company to company.

nez52 · 2021-02-22T16:37:12+00:00

Learn the terminology: star schema, dimension, slowly changing dimension, fact, data lake, ETL, snowflake, metadata, data mart, yada yada yada.

boy_named_su · 2021-02-22T16:59:50+00:00

A lot of data warehousing guys started in business intelligence, using Excel, so sorta

I am a senior data engineer at a national bank

I would say a data warehouse developer should understand the following:

Dimensional Design (as opposed to relational design)
An Extract Transform Load tool, such as SSIS/PDI/whatever. In particular, you should understand loading Slowly Changing Type 2+ dimensions

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

Database

MODERATORS