Database Developer

Expert level T-SQL, DTS solid understanding of ETL process flow solid understanding of dimensional modeling and data warehouse principles able to write clear, well structured, well documented code, able to create documentation with Visio, able to clearly and effectively communicate orally and in writing able to mentor more junior team members able to receive honest, critical, constructive feedback


 

Responsibilities:
''Obtain clear requirements before commencing development''
ask questions of the Business Analyst/Subject Matter Expert (BA/SME) until the requirements are clear
identify alternatives to requirements that could reduce the development time
''Assess the data required''
available in existing data marts?
calculations and business rules clear?


* ''Design application data layer''
use relational design for interactive transactional applications
enforce integrity use dimensional design for reporting applications
application metric tables (implementing application specific business rules/filtering) process for loading application metric tables (stored procedures, DTS, etc.) API's for delivering resultsets to presentation layer performance is //critical// - report API's should return data in < 2 seconds API's for INSERT, UPDATE to relational application database
ensure designs conforms consistently to team standards (or propose new standard)evaluate prospective data sources:
When building data mart objects:
identify measures (distinguish appropriate grain for our fact tables)
identify dimensions assess data quality existing at the source
prepare a summary (diagram, Word document, etc.) for discussion with project team
design data mart and load processes
stage, work, fact and dimension tables
ETL (DTS, stored procedures, etc.)
source to stage stage to dimension
stage to fact fact to base metric (if appropriate) performance is critical - many concurrent processes run daily
ensure designs conforms consistently to team standards (or propose new standard) learn our team standards
no silos/lone wolf development communicate ideas for improving/enhancing/extending the standards discuss deviations with team lead before implementing prepare accurate and complete design documentation (during the development cycle - not as an afterthought at the end) keep team lead apprised of progress and issues on development projects break development tasks down into key steps and sequence those steps create database objects and write code to implement development projects unit test your own code review peers' code for correctness, performance, clarity, and technique - provide written feedback support production data marts respond to data loading issues implement enhancements learn the processes for those data marts not assigned to you so that you can cover support when other team members are unavailable provide honest, critical, constructive feedback to peers, team leads.