Posted by: "Ashley Inglis" ashley.inglis@wallst.com
Date: Thu Oct 1, 2009 3:42 pm ((PDT))
Data Warehouse Engineer
Do you want an innovative environment, technical challenges, brilliant colleagues in addition to business stability? Wall Street on Demand, Inc. has doubled in size the last two years and continues to look for exceptional people who want to solve hard problems and truly make a difference at work. Check out our website for all of our current opportunities - www.wallst.com
What We Offer:
Wall Street on Demand, Inc. is a dynamic, growing organization, headquartered at the base of the Rocky Mountains in Boulder, CO, focused on the design, development and hosting of financial web sites, reports, and tools. We deliver innovative, high quality products to help our clients and their customers visualize, manipulate and understand complex financial information. Our compelling, presentation-rich services for financial professionals and individual investors have won acclaim for our clients, many of whom rank at the top of the Gomez and Forbes awards. Our products are custom designed for each client, completely private-labeled, and fully integrated into the client's other offerings.
The opportunity to work on projects for almost every top-tier financial institution in the world. The ability to expand your skills in a team based environment.
Benefits:
Wall Street on Demand, Inc. offers a dynamic work environment that creates an abundance of opportunities for motivated individuals, a great benefits package including medical, dental, vision, 401K, flexible spending account, 3 weeks vacation, alternative transportation incentives, unlimited chocolate, and a fun, healthy environment!
Wall Street On Demand is an Equal Opportunity Employer.
What you Offer:
This position is responsible for the development, operation, and maintenance of data warehousing systems and related business intelligence functionality. Some systems design work will be expected. Our current data warehouse uses Microsoft SQL's Database Engine, Analysis Services, and Integration Services. Planned enhancement to the business intelligence functionality is includes analytics, data mining, benchmarking, and predictive analysis and will add MySQL to the suite of tools used to manage our data. The chosen individual will be directly involved in expanding our data mining capabilities and is also expected to assist with other team activities, including systems operations, client projects, and user support; and some on-call / off-hours work on a rotating basis is required. We are looking for an exceptional engineer who is passionate about data and the financial markets.
Essential Job Duties
* Develop, operate, and maintain data warehousing systems using Microsoft SQL Server (Database Engine, Analysis Services, and Integration Services) and MySQL.
* Design, operate, and maintain business intelligence functionality, based on the data warehouse, using tools to be determined.
* Assist with the management and operation of data collection, processing, and reporting systems to ensure the smooth and timely delivery of data and reports.
* Participate in client projects, as assigned.
* Assist with other team activities, as required.
* On a rotating basis, provide on-call support and off-hours operations for data warehousing and reporting systems.
Education and Experience -
* A Bachelor's degree is required.
* Microsoft SQL Server 2005 or later, Database Engine
* Must be able to create and tune complex queries
* Must be able to write complex stored procedures and stored functions
* Experience with large database systems is highly desirable
* Experience with partitioning is desirable
* Microsoft SQL Server 2005 or later, Integration Services
* Must have some familiarity and experience with Integration Services
* Experience with ETL package creation is highly desirable
* Experience with other ETL products is desirable
* Microsoft SQL Server 2005 or later, Analysis Services
* Experience with OLAP cube design, implementation, and operation is highly desirable
* Experience with Analysis Services data mining or other business intelligence functionality is highly desirable.
* Experience with large-database, high-volume MySQL database design and operation is highly desirable.
* Business intelligence: Experience with analytics, data mining, benchmarking, or predictive analysis, regardless of tool, is highly desirable.
* Experience developing or modifying .NET applications is a plus.
Skill / Ability
* Can work from general design specifications and standards to develop data warehousing systems incorporating SQL, OLAP, and Integration Services components.
* Documents work adequately to ensure supportability and operability by others on the team
* Self-motivated; can work with minimal direction and supervision
* Strong interpersonal skills: communicates effectively and works collaboratively with team members, members of other teams, and external clients.
* Able to multi-task, retaining appropriate priorities and meet project deadlines
* Excels at troubleshooting complex problems
Resume, cover letter and salary requirements are required for consideration. Please email jobs@wallst.com. You will be contacted if we are interested in an interview. Local candidates only; no relocation packages are available at this time.
Salary is based on experience
