Data Warehouse Engineer-Boulder CO
Posted by: "Ashley Inglis" ashley.inglis@wallst.com
Date: Fri Aug 15, 2008 3:23 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!
What you Offer:
This position will be involved in all aspects of enhancing, maintaining,
operating, and providing information from and access to the company's
SQL and OLAP data warehouse.
Essential Job Duties:
Design, implement, and maintain SQL and OLAP data schema. Design,
implement, enhance, and maintain ETL system written with DTS, SSIS, SQL
scripts, and VB.Net. Design, implement, enhance, and maintain reports
written with Reporting Services and, to a lesser extent, Excel and
Access. Design, implement, enhance, and support internal tools for
user-facing reporting and data delivery tasks. Manage the ETL and
reporting infrastructure to ensure the smooth and timely processing of
data and delivery of reports. Participate in the management of the SQL
and OLAP databases and related systems. Assist with other team projects
and activities, as required. On a rotating basis, provide on-call
support and off-hours operations for data warehousing and reporting
systems.
Experience:
A Bachelor's degree is required. A variety of skills will be required
for this position. We do not expect candidates to be experienced in all
of the areas listed below, but please provide specific information on
your experience with the following:
* Microsoft SQL 2005, including schema design, query design, and
stored procedure development.
* Microsoft Analysis Services 2005, include cube design and MDX
query design.
* Microsoft .NET languages, specifically VB.Net, C#, or ASP.Net.
* Microsoft DTS, SSIS, or other ETL software.
* Report writing with Microsoft Reporting Services, Crystal
Reports, or equivalent.
Skills: Can work effectively with other team members, other departments,
and external clients to define and implement SQL and OLAP data stores,
ETL processes, reports, data warehouse tools, and other systems, as
required. Detail-oriented; works to ensure that collected data and
reports are complete and accurate. Forward thinking and innovative;
looks for innovative, scalable solutions to business needs, processes,
and systems. Self-motivated; can work with minimal direction and
supervision. Strong interpersonal skills; works collaboratively with
team members, members of other teams, and external clients. Able to
multi-task, retaining appropriate priorities and able to troubleshoot
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. Please Note: Local candidates preferred;
no relocation packages are available at this time.
Salary: Based on Experience
