We are looking for a Data Architect/Lead Data for our Data Warehouse team. This data warehousing architect will build out and maintain the critical warehouse infrastructure that supports our team in making smart business decisions. If you’re passionate about database performance, dimensional modeling, multi terabyte data warehouses, and are interested in joining a world class engineering team you might well be the person we’re looking for. This hands-on role contributes to the organization's success through expertise in data modeling, advanced database programming, and database architecture and configuration. Qualified individuals will have a solid background in the fundamentals of data warehousing as well as mastery of SQL programming and relational database design. Experience in Microsoft Analysis Server programming, MDX programming is a plus.
Because we are a small team, your ability to communicate technical ideas effectively, in oral and written forms, and solve complex problems in a team environment will also be considered.
Responsibilities :
- Warehouse design – Work with the Engineering, Product Management and Sales teams to implement solid, extensible warehouse models that support new analytics requirements.
- Using analytical systems and applicable tools to implements the multiple layers of a warehousing environment - data warehouse, cubes, and the report generation infrastructure.
- Writing efficient and scalable Java code/stored SQL procedures to create ETL mapping procedures to move data from production to the data warehouse.
- On-going warehouse maintenance – Analyze and quickly assess the impact of production system changes to existing analytics and implement changes to the warehouse components to ensure consistent and accurate reporting.
- Database applications – Work with a group of engineers in designing and implementing business and consumer based database applications. This will support large-scale, online application infrastructure in a 24x7 environment.
- Business operations support – Troubleshoot all database related operational issues. Ability to tie together business processes with data and debug the data.
Qualifications:
- Must be hard working, team oriented, bright, creative, cooperative, and an exceptional problem solver
- Must be able to quickly understand business logic and be able to translate into technical implementation
- Experience with Microsoft SQL Server, Analysis Server, and MDX programming is a plus.
- Solid understanding and working knowledge of query optimization techniques. Ability to read through a query plan and optimize code and database structures accordingly. Proven skills in scalability analysis and performance monitoring and measuring techniques.
- Experience with Java is a must.
Please send your resume to naghi.prasad@turn.com
URL: www.datashaping.com/jobs15446x.shtml
Please mention datashaping.com when applying. Thank you.