Database Guru - Report Writing
Closed - This job posting has been filled and work has been completed.
We are looking for an expert database teammate.
Below are the criteria - Speaking English and attention to detail are critical as you will be interfacing verbally with our team. You should also have a knack for financial information and understanding the impact of financial informationl
5+ Years Experience with...
Database Warehouse Design
Must understand the concept of dimensional vs. factual tables, ETLs and data transformations.
The ability to explore an existing database and use reverse engineering to discover formulas/algorithms used for business intelligence reports, trending analysis and anomaly detection.
SQL (Specifically T-SQL)
Must be comfortable Writing views, stored procedures, pivot tables and complex join statements.
The ability to use Excel in aiding your database programming is a must. Must be comfortable importing/exporting data to and from Excel, perform pivots and using macros to automate tasks and generate T-SQL code.
Applicant should have experience in writing classes connecting to a database and return a result set to a web based front end using WCF. Knowledge of MVC vs. MVVM is a plus along with WPF.
Must have a good understanding of XML, JSON and CSV data formats.
Skills: english, design, engineering, analysis, mvc, json