2016-07-29

/Your Talent. Our Vision./*At Anthem, Inc.,*it’s a powerful combination, and the foundation upon which we’re creating greater access to 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 atone of America's leading health benefits companies and a Fortune Top 50 Company.

*Location*: Mason, OH, Thousand Oaks, CA, Virginia Beach, VA, or NJ is preferred but will consider other locations.

*/Job Overview/*

In this highly visible position, you will work with various team members from different business departments. In order to succeed, you will need to be comfortable juggling several assignments at once and handle the quick turnaround. You will assist in building and tuning queries, as well as end-user application development. The Bus Info Developer will be responsible for participating in all phases of the development and maintenance of an application, and ongoing communications with business customers, utilizing specific technology platforms and will assist in the design and development of complex departmental tools and systems.

*/Role:/*

Develop and maintain databases/applications across a department, while ensuring high levels of data availability. Responsibilities include: Design and deploy data table structures, reports, and queries. Coordinate and work with other technical staff to develop relational databases (i.e SQL Server DB) and secondary databases (i.e. Access). Identify inefficiencies in current databases and investigate solutions. Diagnose and resolve database access and performance issues. Plan and coordinate data migrations between systems. Development and maintenance of the database stored procedures, views and functions. Ensure alldatabase systems meet business and performance requirements. Produce ad-hoc queries and develop reports to support business needs.

*/ Responsibilities/*
* Create complex analytic queries on large data sets
* Create stored procedures, triggers, and functions
* Generate code to extract, transform and load data from production data sources to the data warehouse
* Performance tuning of key queries.
* Maintain uptime demands on the BI system
* Design & develop applications using various technologies
* Provide analytical and problem solving skills when addressing and resolving issues, assessing possible systems impacts, and recommending technical solutions.
* Conduct code walk-thru of systems solutions to ensure design quality and consistency, as well as cross-reference to the business requirements.
* Improve, automate, maintain and support existing batch processes.
* Perform other duties as assigned.

*Qualifications Required*
* Minimum 3 years of experience in a database development role
* Recent in-depth experience with SQL Server 2008/2012
* Extensive knowledge of T-SQL language
* Knowledge of principles of database design, data acquisition and data access analysis and design
* Knowledge of stored procedure writing, query optimization, and indexes
* Knowledge of database performance tuning techniques
* Strong communication skills a must
* Knowledge of Excel, Access, and integration with SQL Server back-end
* .NET and ETL experience is plus
* Experience in the Health Care industry is a plus.

*Knowledge and Abilities*

* Excellent verbal and written communication, presentation and authoring skills.
* Ability to work in a fast-paced business setting with minimum supervision.
* Ability to design and implement solutions from high level requirements.
* Strong analytical and problem solving skills.
* Solid interpersonal and relationship building skills that enable cross-functional partnerships.
* Knowledge of reporting tools and technologies.

*Professional Experience*
* 3 years of hands-on development experience, which includes SQL development with relational database (Sybase / Oracle / SQL Server)
* AA or BA/BS in Computer Science, Information Technology, or related discipline. BS is preferred.

*/Anthem, Inc. is ranked as one of America’s Most Admired Companies among health insurers by Fortune magazine and is a 2015 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*

**Title:** *Bus Info Developer Consultant / Sr 120787*

**Location:** *NV-Reno*

**Requisition ID:** *120787*

Show more