Data Warehouse Developer
Data Warehouse Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Data Warehouse Developer
Location: 100% Remote
Contract Duration: 36 months to start
Fully remote (Core EST hours)
MUST have very strong SQL skills and Data Modeling experience please make sure they match all technical qualifications.
Data Vault experience is a huge plus but not required
Looking for a Sr. Level resource and work their way up to an architect level
Job Description:
- We are looking for a Data Warehouse Developer. This position will be a fulltime and remote contract opportunity.
- This project involves conversion of legacy data warehouse to a new architecture which includes Data Vault 2.0 and traditional Data Mart.
What Youll Do:
- Connect to new data sources
- Explore data model in the data vault and data mart
- Configure and/or code data vault and data mart structures
- Code complex stored procedures which implement business rules and load Fact tables
- Convert complex existing report stored procedures from the legacy warehouse to the new one
- Validate results using TSQL; document all the differences
- Troubleshoot code at all levels
- Work with the report developers as they adapt to using the new warehouse
- Individual will be on a very small team (23 people) and needs to be a selfstarter who can quickly get up to speed
What Youll Need Required:
- 6 years of TSQL development. Very strong TSQL skills needed
- 4 years SSIS experience required
- Strong database and data warehouse modeling experience
- Experience with Microsoft database projects (dacpac)
- Experience with DevOps
- Experience with Microsoft Access as a front end for SQL Server
Preferred:
- Experience with advanced TSQL such as dynamic code generation recursion Gaps & Islands desirable
- SSAS experience desired
- Exposure to Data Vault
Physical Demands:
- Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal state and local standards
- Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings etc.
- Ability to conduct repetitive tasks on a computer utilizing a mouse keyboard and monitor
t-sql,Data Modeling,Data Vault
Employment Type
Full Time
