Aetna Data Warehouse Developer (Team Lead) in Amherst, New York
Req ID: 37937BR
Has full technical knowledge of all phases of applications systems analysis and programming. Under general direction, has duties of instructing, directing, and checking the work of other systems analysis and programming personnel. Formulates and defines system scope and objectives for assigned projects. Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. Responsible for program and system design, coding, testing, debugging, and documentation. Acts as expert in business applications and/or cross functional areas. Responsible for directing and monitoring the work of team members. May be responsible for project completion and user satisfaction. Provides focus on cross-application integration & solution design as needed to ensure release success.
May have quality assurance review responsibilities for design and use of cost effective application program solutions. May be called upon to code when need & opportunity arises. Leads or acts as chief technical contributor to translation of business requirements to technical specifications. Leads or acts as the chief technical contributor in the design of new applications or enhancements including integration of purchased solutions in accordance with Enterprise wide strategy. Works closely with technical partners to coordinate and plan ongoing and scheduled system maintenance activities and assists other team members who perform ongoing system maintenance, research, problem resolution and support tasks for existing systems. Efficiently utilizes the prescribed methodology in a disciplined manner, which may include the execution of key technical reviews at projects gates and/or milestones. Anticipates, analyzes, and reacts to the potential impact changes to technology and/or products may have on the business and the computing environment. Oversees/Coordinates the completion of unit testing, integration and system testing, according to detailed test plans to ensure high-quality systems. Assists business partners with User Acceptance Testing. Independently supports the implementation of systems into production, including integration of purchased solutions. May set direction for Code Asset Management for an application or set of applications. Supports and ensures the reuse of assets across the organization. Leads or acts as a key subject matter expert for all or portions of the set of applications aligned with a sub-domain or domain. Serves as team leader to direct technical activities (including analysis, planning, architecture, design, development, testing, installation, and maintenance of support systems for business areas). Acts as a knowledge source for identifying Aetna and individual application development standards. Interacts and receives general direction from the Business, Project Managers or Application architects. Apply industry wide understanding of technology, tools and methodologies to assist in developing solutions on projects of strategic significance. Evaluate and identify issues and constraints pertaining to technology approach; coordinate evaluation of solutions to insure adherence to Aetna technology standards (such as security, database, etc.)
Eight or more years in database/data warehouse development experience. Involvement in all phases of the systems development life cycle. 6-8+ years systems analysis and program development experience with some task or team leadership, or an equivalent combination of education and experience. Experience with MS SQL Server 2008 and higher, SSIS, NoSQL, MarkLogic a plus. Healthcare or Medical industry experience a plus
The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.
Functional - Information Technology/Data / info management & architecture/4-6 Years
Technical - Database/Microsoft SQL Server/4-6 Years/System Support
ADDITIONAL JOB INFORMATION
Opportunity to work with a variety of consumers such as system analysts, application developers, informatics, operational staff.
Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.
We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.
Together we will empower people to live healthier lives.
Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.
We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.
Job Function: Information Technology