Senior DW/BI Architect
Working At Aetna -- the Value To You
What does it mean to work at Aetna? A lot. From programs and benefits that support your financial, physical and emotional health to opportunities to build your knowledge and expand your career, the company makes working here a valuable experience in many ways.
American Health Holding, Inc., an Aetna company, is a national medical management firm covering more than 3 million lives. Founded in 1993, American Health believes that the combination of building partnerships with clients and delivering innovative and cutting-edge methods of containing health care costs are vital to continued growth and development. American Health provides comprehensive services through a professional staff of physicians and registered nurses who are highly qualified in cost management issues including quality assurance standards. Learn more at www.americanhealthholding.com.
This position is supporting the American Health Holding organization.
Recognized as an expert and a leader throughout the IT community. Utilizes in-depth knowledge of the organizations tactical and strategic business objectives, the enterprise technological environment, the organization structure, strategic technological opportunities and requirements. As an individual contributor, this position has no direct line management responsibilities but is a major contributor to the success of mission critical, complex, typically large, often enterprise-wide major architecture projects and innovations. Participates with and provides expert technical consultation to senior IT management strategic planning groups.
Specifically, the Senior Data Architect / Modeler will work to manage data from multiple sources (claims data, lab data, etc.) and gather it in a way so it can be used functionally. This role will also work hands-on in transforming the data for use in long-term analysis.
The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.
? Extensive database modeling, design, development, and maintenance experience (including developing dimensional databases and data cubes, schema design and development)
? Ability to design unit and system test plans, and execute testing
? Excellent communicator both verbally and written with coordination and facilitation skills.
? Ability to multi-task and complete in a timely manner multiple assignments.
? 5+ years in database development experience including SQL Server 2008/2012
? Experience developing SSIS ETL packages supporting database to database activities
? Proven experience with SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
? Skilled in both Data Warehouse and Transactional databases
? Extensive Stored Procedure development
? Strong T-SQL programming skills
? Extensive database administration experience
? Experience with UML (Universal Modeling Language)
? Experience in Medicaid or the Health Insurance industry is a plus
? Experience with Databases used in a Data Warehouse / Data Mart environment
? Knowledge of Web programming preferably with C#.Net and .Net Frameworks 4.0 and higher
How to apply
Please use the "Apply" link to apply to this position. If you cannot view this link, you can find this position on our website by visiting: www.aetna.com/working, click on apply online, search openings, and enter 10636BR in the keyword field. Additional information on what it?s like to work for Aetna and more can also be found on our website.
We value leadership, creativity and initiative. If you share those values and a commitment to excellence and innovation, consider a career with Aetna.
We conduct pre-employment drug and background testing.
Aetna does not permit the use of tobacco related products or drugs in the workplace.
Aetna is an Equal Opportunity/Affirmative Action Employer. M/F/D/V
Aetna is committed to maintaining an environment in which all employees are treated equitably and given the opportunity within the context of the business to achieve their potential. Aetna's Affirmative Action responsibilities extend to women, minorities, persons with disabilities and veterans. Company policy also provides for equal opportunity for qualified individuals regardless of race, color, sex, national origin, religion, age, disability, veteran status, sexual orientation, gender identity or marital status.
No search firms please.
You will not be asked for personal information until you have been fully evaluated through Aetna's screening processes. Aetna will never ask applicants for money. If you want to verify the identity of someone who contacts you from Aetna, call 1-800-AETNAHR (1-800-238-6247).
Click Here To Apply
• Post ID: 12737886 columbus