I really enjoy working at Retail Solutions. The company has provided me with a variety of opportunities to advance my career path and technical skills, establishing a strong foundation for my future success.
-David Sun, Engineering, Retail Solutions
Mountain View, CA
Senior OLAP Software Engineer
Location: Mountain View, CA
The software engineer's role is to understand the requirements for creating multi dimensional cubes using Microsoft's SQL server BI stack - SSIS and SSAS, as well as work on the application interface to the cube using proprietary BI analysis tools and reporting capabilities.
Responsibilities:
- Work with business users to design multi dimensional OLAP cubes addressing business requirements
- Develop Database Applications using the latest techniques in ETL, Data Warehousing, and Data Mining using Microsoft SQL server 2008 based tools
- Independently design, code and test major features, as well as work jointly with other members of the core development team.
- Develop high quality applications following standard software lifecycle development process
- Administer databases
Position Requirements:
Formal Education, Certification
- Bachelors Degree in CS/Mathematics/Statistics/Engineering with 7+ years in industry, or Masters Degree in CS/Mathematics/Statistics/Engineering with 5+ years in industry
- Willing to consider less experienced developers who are very bright and motivated to learn fast
Knowledge & Experience
- Several years of practical experience working with and creating multi dimensional OLAP cubes using SQL Server in the areas of OLAP schema design, cube development, data warehousing design, MDX optimization
- SQL database programming experience with JDBC on top of Microsoft SQL server.
- Complex database schema design experience with index creation, physical data layout, dimension definition.
- Query tuning experience; familiarity with execution plan tuning, I/O tuning, cache tuning, data clustering.
- Programming experience in C# , Java etc. is a plus
- Experience with either WebLogic/JBoss application servers is a plus
- Proven track record of delivering high quality products on time.
- Strong analytical and technical skills and demonstrated ability to creatively solve complex problems
Personal Attributes
- Good written and oral communication skills.
- Strong technical documentation skills.
- Good interpersonal skills.
- Ability to conduct research into database issues, standards, and products as required.
- Ability to present ideas in user-friendly language.
- Highly self-motivated and directed.
- Keen attention to detail.
- Proven analytical and problem-solving abilities.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Strong customer service orientation.
- Experience working in a team-oriented, collaborative environment.