Database Analyst (Virtual)

This job is no longer active. View similar jobs.

POST DATE 9/3/2016
END DATE 11/22/2016

AON Lincolnshire, IL

Company
AON
Job Classification
Full Time
Company Ref #
2421006
AJE Ref #
576079554
Location
Lincolnshire, IL
Experience
Mid-Career (2 - 15 years)
Job Type
Regular
Education
Bachelors Degree

JOB DESCRIPTION

APPLY
JOB DESCRIPTION
AON IS LOOKING FOR A DATABASE ANALYST

As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions as part of our Active Health Exchange business group within Aon Hewitt. This is a virtual role and can be worked from anywhere in the U.S.

YOUR IMPACT AS A DATABASE ANALYST

JOB RESPONSIBILITIES:

Our Database Analysts are design and documentation oriented. In the role, you will be making changes to the data models - which affect the integrity of the data and SQL statements. You will be responsible for new database objects; index tuning; engineering new database objects; query construction and execution plans; and multiple table joins. Our Database Analysts perform all necessary testing to ensure completeness and accuracy of data files. You will also be working with ETL and writing procedural code.


You will use strong communication skills in order to work collaboratively, but also have a strong skill-set to be able to work independently. You will have a positive outlook on governance and be able to objectively participate in design review discussions.

QUALIFICATIONS:

YOU BRING KNOWLEDGE AND EXPERTISE

Required Experience:

* 3+ years of SQL Server.

* Ability to deconstruct problems.

* Knows how to properly use indexes.

* Understands how to write nested procedures that may also call user defined functions.

* Effectively manipulate and maintain code within procedural code.

* Uses SQL Server Profiler to troubleshoot issues around slowness and bugs.
* Quickly understands code that is/was written by someone else.

* Finds solutions to basic issues on the web or in SQL BOL, or other resources.

* Strong learning agility.

Preferred Experience:

* Familiarity with RedGate, Azure SQL Server are a plus (as is familiarity with cloud storage).

EDUCATION:

* Bachelor s degree in Computer Science or Business, or equivalent years of industry experience.

WE OFFER YOU
A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

OUR COLLEAGUE EXPERIENCE:
From helping clients gain access to capital after natural disasters, to creating access to health care and retirement for millions, Aon colleagues empower results for our clients, communities, and each other every day. They make a difference, work with the best, own their potential, and value one another. This is the Aon Colleague Experience, defining what it means to work at Aon and realizing our vision of empowering human and economic possibility. To learn more visit Aon Colleague Careers

ABOUT AON:
Aon plc (NYSE:AON) is the leading global provider of risk management, insurance and reinsurance brokerage, and human resources solutions and outsourcing services. Our more than 72,000 colleagues worldwide empower results for clients in over 120 countries with innovative and effective risk and people solutions and through industry-leading global resources and technical expertise. http://www.aon.com.

By applying for a position with Aon, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Aon's employment policies. Background checks may include some or all of the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, fingerprint verification, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position.

Aon provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, or domestic partner status. Aon is committed to a diverse workforce and is an affirmative action employer.

DISCLAIMER:

Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.

JOB NUMBER: 2421006
CATEGORY: Information Technology Group
LOCATION: United States, IL, Lincolnshire