Datawarehouse Manager

Datawarehouse Manager

Reports to: Director of Software Development

JOB SUMMARY:
The Datawarehouse Manager plans, schedules, and manages development of software applications to process data and solve problems.

DESCRIPTION
Program Management
Consult with managerial and systems personnel to clarify program intent, identify problems, suggest changes, and determine extent of programming and coding required. Prescribe standards for terms and symbols used to simplify development and interpretation of programs. Prepare software project status reports and project plans. Provide technical assistance by responding to inquiries regarding errors, problems, or questions with program. Train end users or technical support staff to use programs. Monitor performance of programs after implementation.

Program Development
Develop programs from specifications, workflow charts or diagrams, considering factors such as computer storage capacity and speed, extent of peripheral equipment, and intended use of output data. Develop and maintain plans outlining steps and time tables for developing, testing, and installing applications. Design and code screen layouts, graphical user interfaces, printed outputs, and interfaces with other systems. Demonstrate expertise in one or many of the company's programming languages.

Revision and Documentation
Revise or direct revision of existing programs to increase operating efficiency or adapt to new requirements. Compile documentation of program development and subsequent revisions. Write and maintain functional and technical specifications. Create test scenarios and run tests to find errors and confirm program meets specifications.
Consult with client to prototype, refine, test, and debug programs to attain client approval. Write and maintain documentation to describe program development, logic coding, testing, changes, and corrections. Write documentation or review documentation written by others that describes installation and operation procedures.

Staff Development and Management
Train staff in programming, company programming standards and Software Development Life Cycle. Assign, coordinate, and review work of programming staff.

Analysis
Analyze, define, and document system requirements for data, workflow, logical processes, hardware and operating system environment, interface with other systems, internal and external checks and controls, and outputs. Analyze and estimate feasibility, time, compatibility with other systems, and computer capabilities. Research and evaluate software and hardware to assist in programming or to use as program platforms. Analyze codes to find causes of errors and revise programs. Analyze, assist installs, and test upgrades of internally/externally developed application programs.

Supervisory Responsibilities
Directly supervise employees in the Data Warehousing Development Team. Carry out supervisory responsibilities in accordance with the organization's policies and applicable laws. Responsibilities include interviewing, hiring, and training employees; planning, assigning, and directing work; appraising performance; rewarding and disciplining employees; addressing complaints and resolving problems.

REQUIREMENTS

SKILL SETS:

• Ability to read, analyze, and interpret common business and technical journals, financial reports, and legal documents
• Ability to respond to common inquiries or complaints from customers, regulatory agencies, or members of the business community
• Must be able to monitor and evaluate staff performance
  Ability to effectively present information to top management, client groups, and/or company user community
• Must be motivated training staff
• Ability to calculate figures and amounts such as discounts, incentives, surcharge, interest, commissions, proportions, and percentages
• Ability to interview and select the most qualified individual to fill vacant positions
• Ability to use concepts of basic mathematics to resolve business issues
• Demonstrated knowledge in one or more of the company's programming languages
• Ability to define problems, collect data, establish facts, and draw valid conclusions
• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables
• Must be able to perform each essential duty satisfactorily

EXPERIENCE:

• At least 5 years related experience and/or training
• At least 2 years supervisory or management experience
• At least 2 years Datawarehouse experience
• Minimum of 2 years experience as Senior Programmer Analyst or Senior Systems Analyst
• Managed Care or Healthcare experience required
• Minimum of 5 years experience with SAS
• Financial experience a plus.

OTHER REQUIREMENTS:

• Bachelor's degree (B.S.) in Computer Science or MIS from four-year College or University is a must. Equivalent combination of education and experience acceptable

Required Skills:
SAS, DATA WAREHOUSE, DATA WAREHOUSING, HEALTH, HEALTHCARE, MANAGED CARE, HEALTHCARE COMPANIES