Data Warehouse Analyst Sr or Consultant - 133147SK
Location:
Washington , District of Columbia
Posted:
October 19, 2017
Reference:
672092509
Your Talent. Our Vision.At Anthem, Inc.,it's a powerful combination, and the foundation upon which we're creating greater care for our members, greater value for our customers, and greater health for our communities. Join us and
together we will drive the future of health care.

This is an exceptional opportunity to do innovative work that means more to you and those we serve at one of America's leading health benefits companies and a Fortune Top 50 Company.

Location:

Thousand Oaks or Woodland Hills, CA
Denver, CO
Mason, OH
Minnetonka, MN
Chicago, IL
Richmond, Virginia Beach or Norfolk, VA
New York City, NY
Columbia, MD
Wallingford, CT
Atlanta, GA

DATA WAREHOUSE ANALYST SR

Responsible for partnering with internal and external business clients and IT to fulfill information needs and support business decisions.

Primary duties may include, but are not limited to:

1. Guides and advises less experienced data warehouse analysts.

2. Maintains information policies and procedures to support current and future data information needs and ensures proper data definitions, ownership, use and integrity of data.

3. Analyzes complex business user needs, documents information requirements.

4. Facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.

5. Collaborates with IT resources on the creation and maintenance of the content of the data warehouse, establishes and maintains strong knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues, completes metadata assessment and reviews feedback to determine changes, ensures that data definitions are clear and current, and communicates changes to data definitions to all users.

6. Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.

DATA WAREHOUSE CONSULTANT

Responsible for partnering with business owners and stakeholders to gather and document analytic requirements supporting the enterprise data warehouse.

Primary duties may include, but are not limited to:

1. Acts as lead business analyst by working across business and technical teams to support enhancement projects/
programs, lights-on activity, and issues/defects within the analytic environment.

2. Establishes and maintains excellent knowledge of data warehouse data structure design, definitions, capabilities, programming languages, and data integrity issues.

3. Analyzes more complex business user needs, documents information requirements, facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed.

4. Ensures proper data definitions, ownership, use and integrity of data.

5. Collaborates with IT resources and data owners to define business objectives and definitions for databases including business rules, sources, purge archive criteria, and reload schedule.

6. Supports the validation and testing of data structure design, definitions and mapping, including business rules.

7. Facilitates calls with business stakeholders to discuss data requirements.

8. Delivers quality results while working on multiple project assignments.

9. Instructs, directs and reviews work of less experience data warehouse analysts.

10. Maintains information policies and procedures to support current and future data information needs.

11. Completes metadata assessment and reviews feedback to determine changes needed.

12. Collaborates with IT resources on the creation and maintenance of the content of the data warehouse, establishes and maintains strong knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues, completes metadata assessment and reviews feedback to determine changes, ensures that data definitions are clear and current, and communicates changes to data definitions to all users.

DATA WAREHOUSE ANALYST SR

Requires Bachelor's degree in related field.

2-4 years experience in data analysis, data modeling, and working with automated data warehouse systems.

any combination of education and experience, which would provide an equivalent background.

Experience in Teradata SQL, GQL, SAS, Business Objects and OLAP preferred.

Strong analytical and problem-solving ability required.

Strong PC and communication skills required.

Demonstrated ability to lead and plan projects required.

Excellent analytical, communication, problem-solving, and planning and organizational skills required.

Healthcare data knowledge for all data types.

Prefer knowledge/background in the following subject areas

Medical and Specialty Claims

Finance and Revenue

Membership and Eligibility

Products, Broker

Chart of Accounts

Provider Capitation

Utilization Management

Case Management

Disease Management

Laboratory Results

Health and Wellness Data/Survey

Must have experience working in a Teradata environment.

Working in a virtual environment.

Detail-oriented with strong organizational and time management skills.

Ability to manage competing priorities in a fast-paced environment.

DATA WAREHOUSE CONSULTANT

Requires BA/BS in related field.

6-8 years experience in data analysis, data modeling, and working with automated data warehouse systems, or any combination of education and experience, which would provide an equivalent background.

Experience with programming languages and various statistical programs in addition to general knowledge of major components of managed care operations required.

Excellent analytical, problem-solving and PC skills required.

Excellent oral and written communication skills required.

Demonstrated ability to lead and plan large-scale projects required.

Experience in Teradata SQL, SQL, SAS, Business Objects, and OLAP preferred.

Excellent analytical, communication, problem-solving, and planning and organizational skills required.

Demonstrated ability to lead and plan complex, large-scale projects required.

Excellent oral and written communications skills.

Healthcare data knowledge for all data types.

Prefer knowledge/background in the following subject areas

Medical and Specialty Claims

Finance and Revenue

Membership and Eligibility

Products, Broker

Chart of Accounts

Provider Capitation

Utilization Management

Case Management

Disease Management

Laboratory Results

Health and Wellness Data/Survey

Must have experience working in a Teradata environment.

Working in a virtual environment.

Detail-oriented with strong organizational and time management skills.

Ability to manage competing priorities in a fast-paced environment.

/Anthem, Inc. is ranked as one of America's Most Admired Companies among health insurers by Fortune magazine and is a 2016 DiversityInc magazine Top 50 Company for Diversity. To learn more about our company and apply, please visit us at antheminc.com/careers. EOE. M/F/Disability/Veteran./

Job Reporting & Data Analysis

Equal Employment Opportunity Statement
Anthem, Inc. will recruit, hire, train and promote persons in all job titles without regard to age, color, disability, gender (including gender identity), marital status, national origin, race, religion, sex, sexual orientation, veteran status, or other status protected by applicable law. In addition, all personnel actions such as compensation, promotion, demotion, benefits, transfers, staff reductions, terminations, reinstatement and rehire, company-sponsored training, education and tuition assistance, and social and recreational programs will be administered in accordance with the principles of equal employment opportunity.

Title: Data Warehouse Analyst Sr or Consultant - 133147SK

Location: dc-Washington

Requisition ID: 133147

A little about us:
We have shared values and a similar mission.

Know someone who would be interested in this job? Share it with your network.