Wall Street On Demand - Data Warehouse Engineer

[rmiug-jobs] Digest Number 4692

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

Trust America - QA Analyst

[rmiug-jobs] Digest Number 4688

QA Analyst - Join a GREAT team (Centennial, CO)
Posted by: "ihireyou07" jgoss@trustamerica.com ihireyou07
Date: Thu Aug 14, 2008 8:08 am ((PDT))

Trust Company of America, founded in 1972 and located in Centennial,
Colorado, has an immediate opening for a Quality Assurance Analyst.
Trust Company provides high quality custodial and back office
services to the financial services industry.

Our employees receive a comprehensive package of benefits. Some of
the highlights include:
o Paid vacation
o Eight paid holidays and six paid time off days annually
o Comprehensive medical and dental insurance plans
o Company-paid life insurance
o Company-paid long-term and short-term disability insurance
o 401(k) Plan with 25% match
o 125(k) Plan
o Education assistance
o Business casual dress
The Quality Assurance Analyst assists in the creation and maintenance
of an automated testing environment for a financial services web-
based client application. The Analyst interfaces with product
managers, project managers, software developers and other testers to
support the development process. This position analyzes functional
requirements and designs documents in order to write test plans and
test scripts, to trouble-shoot failed tests and to report and track
software defects and issues. The Analyst supports business during
user acceptance testing including responding to questions, training
needs and reviewing found defects. The QA analyst mentors the
Quality Analyst on test documents, software testing principles and
product support, and also:

• Provides support of all products related to the software used
to support our client systems
• Tests new development/defects and coordinates user testing
with the business units to ensure quality and project requirements
are being met
• Reviews system data and product quality to ensure integrity
• Prepares and conducts appropriate automated test scripts on
the most critical client-facing applications
• Works with testing lead to effectively prioritize test
scripts to ensure the most critical 80% of the application is being
tested
• Presents found project defects/potential improvements to
project team participants for review prior to user acceptance
beginning
• Reviews and recommends revisions to client
(External/Internal) documentation
• Mentors other staff members on product demonstrations,
recommendations on test documents and training
• Prepares and conducts automated test scripts on the most
critical client facing applications


Minimum Requirements: A college degree is required along with 2-3
years' experience in Quality Assurance and /or Business Operations.
Must have an intermediate knowledge of the software development life
cycle. A fundamental knowledge of Mercury Functional Testing Tools
including QuicktestPro and WinRunner is required. Knowledge of
financial services industry is preferred.

Must have the ability to communicate the state of a product to
stakeholders in order to analyze risk prior to production. Must be
able to juggle tasks and priorities to meet rapidly changing
deadlines. Must be self-motivated to actively push forth learning
using multiple tactics. Must possess the ability to work relatively
independently once assignments are given.

Must possess a fundamental aptitude for the use of automated testing
tools. Must be able to write test scripts from user requirements and
communicate results to team participants. Must be able to design
basic Excel spreadsheets and Word documents. Familiarity with
Software Query Language (SQL) is a plus.

EOE
Trust Company of America promotes a drug free working environment
Candidates must be authorized to work in the United States
Relocation assistance is not provided

Kaiser Permanente - Clarity Technical Lead

Job ID 71265
Company Name Kaiser Permanente
Job Category Technology
Location Aurora, CO
Position Type Full-Time, Employee
Experience 5-10 Years Experience
Date Posted July 8, 2008 (Reposted Aug 13)

Kaiser Permanente is seeking a highly-motivated, results oriented candidate with Project Management, reporting and technical skills to support, coordinate, and execute activities in a complex reporting environment. The Regional Technical Clarity Lead acts as the primary Clarity support and primary point of contact for the Region. The lead is the first point of contact for the region on any issues or questions related to Clarity and act as the Clarity Consultant to the Region. This candidate must possess the demonstrated ability to:

Oversee and drive efforts, in addition to providing consultancy and direction to the region on KPHC Business Intelligence (BI) solutions, such as reporting, views, data extracts, etc.
Provide Clarity Production Support to ensure daily ETL meets SLA.
Provide Clarity Environment management support and coordination.
Coordinate installation and testing of Clarity Releases and Upgrades, which includes review of Release notes.
Work with various KPHC teams to research and resolve Clarity data quality issues and mitigate overall regional risk on issues raised by the region, which includes tracking issues, helping to drive root cause analysis, coordinating with regional and national teams and Epic, attending various meetings, championing the regions needs and testing technical changes.
Serve as the liaison between the local (regional) business reporting team and the National IT reporting team.
Analyze/review solutions with a focus toward leveraging the solutions across regions/groups.
Create, track and resolve issues using the Remedy tracking system.
Coordinate Regional Reporting/database training and brown bag sessions.
Participate in regional forums.
Perform Clarity audit checks and validate daily/monthly TDL stats, etc. which includes analyzing data from Teradata access logs to determine use of group IDs and reviewing defined audit steps and validating record counts.
Involve in regional IT Clarity SOX, HIPAA, MPII, etc. regulatory compliance efforts.

Required Education & Skills:

Minimum of 2-5 years of experience in a reporting environment or department.
Minimum of 5-7 years of lead or project management experience.
Relational database experience, ie: Teradata, Oracle, SQL Server, and Sybase.
Ability to use SQL to develop queries and reports and scripting.
Experience in project management and coordination of complex reporting system release activities.
Strong analytical and problem-solving skills. Ability to think outside of the box and meet goals and objectives to provide business value.
Excellent oral and written communication as well as demonstrated ability to work with end users to communicate changes, thoroughness is closing out issues, an understanding of potential impacts and the ability to bring to managements attention, and require minimal supervision.
Ability to participate as a team member and team leader, along with innovative thinking.
Knowledge and experience in EPIC, ie: Epic (OLTP) System Applications, Epic Clarity and/or Healthcare.
Ability to work with multiple distributed teams and leadership.
Ability to document requirements, analysis, design and user guides.

Skills helpful to have:

Knowledge of multiple reporting tools and software ie: SAS, Cognos, Business Objects, Crystal Reports/Enterprise.
Knowledge of Microsoft Office Suite (Word, Excel, Powerpoint, Access, Visio).
Knowledge and experience in hardware and software in multiple computing platforms (IBM AIX, UNIX, MVS).
Knowledge of Healthcare systems for Clinical Care, Practice Management
Experience with developing web content.
Experience working in large corporations.
This position consistently supports compliance and the Principles of Responsibility (Kaiser Permanentes Code of Conduct) by maintaining the privacy and confidentiality of information, protecting the assets of the organization, acting with ethics and integrity, reporting non-compliance, and adhering to applicable federal, state and local laws and regulations, accreditation and licensure requirements (if applicable), and Kaiser Permanentes policies and procedures.
Kaiser Permanente is proud to be an equal opportunity/affirmative action employer.

Wall Street On Demand - WEB DEVELOPERS

WEB DEVELOPERS Posted Aug 13
Wall Street On Demand, Boulder, CO

Do you want an innovative environment, technical challenges and 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.

Wall Street on Demand, Inc. is a dynamic 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.

WHAT YOU OFFER
Intermediate to advanced knowledge of Javascript, ASP.NET, ASP, C#, Ajax, D/X/HTML, CSS, Web standards, Browser compatibility issues. A crush on xmlHTTPRequest, JSON and purely semantic markup language, reverence for Crockford and Hewitt, dreams in #000 and #fff, a loathing of Redmond's rendering engine (but the skills to bend it to your every whim). Experience with object-oriented programming, the prototype inheritance pattern, and understanding of systems like DWR, Dojo, Prototype, RoR, jQuery, YUI. Technical and user experience contributions to site design, site architecture, and site production. Ability to work in a collaborative environment.

WHAT WE OFFER
The opportunity to work on projects for almost every top-tier financial institution in the world. Training in the necessary knowledge in developing for financial information. Ramp-up time to gain comfort in our environment. Learning from some of the best developers this side of the Mississippi.

Benefits: medical, dental, vision, flexible spending account, 401K, 3 weeks vacation, unlimited chocolate and more.

Linux Unix System Administrator Lead

Jeffrey P Susel is recruiting for a "lead" technical person at up to $40/hour. Maybe a junior person would apply for that rate.


Location: Louisville, CO
Area Code: 303
Tax Term: CON_W2
Pay Rate: $35 to $40 Hour
Length: Contract
Position ID: 1707243
Dice ID: teksyst
Travel Required: unspecified
Telecommute: no
Title: Linux / Unix System Administrator Lead
Skills: LINUX/UNIX
Date: 8-13-2008

Description:
The systems administrator and team lead for this engagement will be
responsible for working with client management and customers to
initiate, complete, and present the results of our client?s
application and hardware assessments for their hospitals and clinics.
They will be handling multiple assessments at one time, and will also
be responsible for the other system administrators within the team and
their assessments

This will be a contract position which is scheduled to run through
December and potentially through the first part of 2009.

A Senior Systems Administrator and Team Lead has the following
qualifications:

Ability to work with Client representative to establish project
strategy and efficiency

Extensive experience in gathering, understanding and using appropriate
information regarding business processes related to customer needs
Systems Administration/Engineering knowledge of HP-UX, AIX and Linux
Red Hat; a strong understanding of application servers such as Apache,
JBoss, and WebLogic, as well as an understanding of how Oracle
databases interact with client server applications

Ability to work with network and systems design teams implementing
large LAN network design products

Advanced level of skill in one or more key technology areas, such as:
systems management, network management, router configuration, basic
WAN implementations, host connectivity, TCP/IP and Internet

Ability to present structured ideas and procedures with a broad
business knowledge

Extensive experience with customer relations
Thorough understanding of and experience with system assessments and
reviews

In-depth product, technology, industry or services-related specialized
skills
Leadership skills and ability to perform in a leadership role

Join TEKsystems() and get your career on the fast track. As the
leading technology staffing and services firm, we are passionate about
deploying high-caliber IT and communications expertise. To satisfy our
constant need for expertise, we actively seek talented Technical
Professionals with all levels of information technology and
communications skills. TEKsystems knows that every professional has
different needs, so we'll work together to determine a suitable
benefits package. We offer options to our Technical Professionals that
could include: a health plan, 401k, provisions for vacation and
holiday pay, and technical and professional training. With a
foundation as the nation's largest IT staffing firm, we've become a
billion-dollar services company by blending superior client service
with an unrivaled ability to source and manage talent to precise
specifications, resulting in successful technology executions. Allegis
Group and its subsidiaries are equal opportunity employers. M/F/D/V

Susel,Jeffrey P
TEKsystems
8700 Turnpike Drive, Suite 400
Westminster, CO 80031
Phone: (303) 412-2753
Fax: (303) 412-2219
Web: http://www.teksystems.com

Kaiser Permanente - Programmer Analyst

Job ID DE.0800336
Company Name Kaiser Permanente
Job Category Healthcare
Location Denver, CO
Position Type Part-Time, Employee
Experience 5-10 Years Experience
Date Posted July 8, 2008 (Reposted Aug 13)

Kaiser Permanente
View Kaiser Permanente profile and job listings

INTERNAL POSTING PERIOD: 7/1/08-7/3/08

IF YOU ARE A COLORADO INTERNAL EMPLOYEE, YOU MUST PLACE YOUR BID ON THE BID LINE 303-614-1510, NOT ONLINE.

PREFERRED SKILLS: Experience using other analytic and access tools such as Focus, Easy Reporter, EasyTrieve, and Business Objects helpful.

Experience with Data Warehouses helpful.

Knowledge of DB2/Oracle, and MS Access helpful.

POSITION SUMMARY: Provides expertise in data extraction and data delivery specific to HEDIS, NCQA, Quality improvement and other regulatory requirements. Works with the IQTS (Integrated Quality Tools and Systems) team to produce quarterly and annual reports based on regulatory specifications. Maintain and support a culture of compliance, ethics and integrity. Responsible for ensuring ongoing compliance within PPS/IQTS. Maintains and supports a culture of compliance, ethics and integrity. Maintains knowledge of policies and procedures and performs in accordance with the Principles of Responsibilities and applicable regulatory requirements, external laws and accreditation standards. Appropriately reports observed fraud or abuse.


POSITION REQUIREMENTS: Bachelor’s degree in business, statistics, information technology, or related area. Equivalent experience will be considered. High level of SAS programming skills (5+ years experience). Experience using other analytical and data access tools such as Focus, and EasyTrieve helpful. Experience with Data Warehouses and Business Objects helpful.
Extensive knowledge of IBM mainframe MVS, JCL, and TSO, as well as SQL and PC/SAS. Extensive knowledge of MS Excel and MS Word. Knowledge of DB2/Oracle and MS Access database management systems helpful.
Strong analytical skills and strong skills in report programming/automation. Excellent customer service skills, and strong verbal and written communication skills a must. A self-starter, who is able to work in a team environment, and yet work independently, and work with initiative


ESSENTIAL RESPONSIBILITES: Provides expertise to the PPS/IQTS team in accessing data from interdepartmental systems as required by regulatory agency specifications. Creates and interprets ad hoc, quarterly and annual reports for regulatory requirements including NCQA, HEDIS, CMI, and CMS. Problem solves, consults on and resolves data quality issues.
Creates, tests, and maintains programming code to extract data and create reports based on complex HEDIS-specific requirements, as well as other regulatory requirements.
Develops quality control procedures to ensure the accuracy of data and reports.
Maintains a programming code library for regulatory-specific program code and maintains security. Establishes programming procedures for regulatory requirements such as NCQA and HEDIS.
Provides support and expertise in the consolidation and automation of regulatory data.
Tracks and documents changes to regulatory data and programming coding.
Supervises temporary programmers, contracted for regulatory reporting.


Functional and Environmental Factors available upon request.

SCHEDULE: Variable hours Mon-Fri.

STARTING SALARY RANGE : $2834 - $3615 (Monthly)

Mortgage Cadence - Web Solutions Architect

[rmiug-jobs] Digest Number 4686

Web Solutions Architect, Greenwood Village, CO
Posted by: "Nathan Hall" Nathan.Hall@3tsystems.com
Date: Wed Aug 13, 2008 9:34 am ((PDT))

Web Solutions Architect



Position Overview:

Mortgage Cadence is looking for an experienced Web Solutions Architect
with strong object-oriented, C#/.NET development skills. Position is
located in the Denver Tech Center area. We are a Microsoft Gold
Certified Partner and makers of Mortgage Cadence Orchestrator -- a
leading mortgage lending (LOS) product. The candidate should have 5+
years of experience with architecture, analysis and development of
scalable, secure, high-performance enterprise web solutions. This
position requires a thorough understanding of multi-tier architectures,
and the ability to design and develop software components across all
tiers of a distributed enterprise application, including front end
components (both Web and Windows), business objects, and database stored
procedures. Microsoft SQL Server programming experience is required.
Ideal candidate should possess strong technical, analytical and
communication skills, and be well versed in prioritizing, multi-tasking
and managing workload to meet critical timelines without compromising
overall product quality. Experience in the mortgage lending industry is
desirable, but not required.


Responsibilities:

* Establish repeatable processes to analyze performance and
scalability of existing web solutions during their development. Use the
empirical data to enhance existing frameworks and/or develop best
practices in order to ensure performance objectives are achieved.

* Ensure that security objectives are achieved by evaluating
existing frameworks for potential vulnerabilities, and establishing a
set of processes and/or best practices to ensure ongoing commitment to
secure code initiative.

* Design high quality application architectures that meet
customer requirements and are consistent with enterprise architectural
standards

* Review and approve system architectures, including logical
and physical application designs, and ensure that all designs and code
meet scalability, performance and security requirements.

* Ensure compliance with established architectural direction
and standards through cross organization consulting and direct
involvement in development efforts

* On-site expert in web application design and development

Qualifications:



* Bachelors degree in Computer Science or related field

* 5+ years C# .NET experience (.NET 2.0+ required)

* 3+ years ASP.NET experience.

* 3+ years database programming experience (MS SQL Server
required)

* 5+ years of experience building scalable, secure,
high-performance web applications.

* Comprehensive knowledge of core web technologies, including
HTML, CSS, JavaScript and AJAX, as well as thorough understanding of
Windows Server / IIS infrastructure.

* Demonstrable web UI and information architecture design skills
with ability to show relevant work in a high-availability environment

* Demonstrable architectures providing scalable solutions

* Demonstrated application of architecture strategies,
standards, processes, and tools in their solution designs

* Understanding of N-Tier architecture and related best
practices

* Understanding of OOD, UML and Entity Relation Diagrams;
modeling experience is a plus

* Team player, strong communication skills, dependable, must be
a self-starter

* Experience leading development teams a plus

* Understanding of emerging technologies a plus