Orchesys, Inc. is a data management and storage services company that specializes in using cutting-edge technology to provide the best storage solutions to our clients. Our clients rely on us, as industry experts, to help them architect, design, deploy, and optimize storage solutions to solve their data management challenges.
Job Summary
To support our rapid growth, we are seeking experienced database design and reporting engineers. A successful candidate will be able to work with and take direction from senior members of our engineering team to develop a high performance support automation tool set. This position will touch many aspects of our product design but will primarily focus on database schema design, data warehousing, OLAP database design, reporting and report infrastructure development.
Responsibilities
Responsible for all aspects of data warehousing reporting including definition of initial functional requirements, maintaining project plans, detailed design, implementation, validation, post release sustaining engineering and product evolution activities.
- Recommend strategy and tools for building a world class data analysis and reporting infrastructure.
- Analyze and design OLAP cubes on complex data warehouse schemas.
- Design/Author reports on data warehouse OLAP cubes using various commercial tools.
- Administer and own reporting solutions.
- Comply with team standards through participation in design and code reviews.
- Develop and manage detailed production and ad-hoc reports, dashboards and reporting systems.
Qualifications
Mandatory qualifications include:
- Expert-level data modeling and schema design.
- Expert-level OLAP design experience.
- Strong practical knowledge of SQL and scripting such as PERL
- Strong practical knowledge of analytics and reporting tools
- Strong practical knowledge of developing advanced reports using commercial tools such as MS-Access, Cognos (api), MS-Excel, Crystal Reports, etc.
- Ability to create innovative reports using a variety of compelling data representation techniques.
- Excellent verbal and written communication skills.
- Previous experience working on a fast-paced development project touching all areas of design, development, testing and customer deployment.
- Ability to take direction from senior engineers and turn that into high quality development deliverables while adhering to an aggressive product delivery schedule.
Portfolio
Please be prepared with a portfolio for your interview. The portfolio may comprise *either* source code snippets AND screenshots *or* live websites showing reports, database views, etc.
Education
- Bachelor’s degree, foreign equivalent, or any combination of education and experience that equates to a Bachelor’s degree in computer science, engineering, or a related technical field.
Related Experience
3-7 years
Job Location
Orchesys Headquarters, Sunnyvale, CA