Job Directory Project Lead

Project Lead
Chicago, IL

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.


Job Description

Job Description


Open to any Aetna location

Come join a team where you can leverage your passion for data and Business Intelligence to seek out and structure HR information, propelling reporting and analytics capabilities forward. If you have a passion for data, thrive in a positive work environment with focus on career development and growth, then let Aetna join you in your journey.

As the HR Reporting Project Lead, you will work closely with peers, other business areas in and outside of HR, senior leaders and AIS resources to understand information needs and build solutions to deliver the key metrics to business decision. You will act as an acknowledged expert on HR reporting, extracting and manipulating data from appropriate systems to meet customer reporting needs. You will be responsible for leading the full testing cycle of a vendors reporting application, from creation of test scripts to final signoff.

Fundamental Components:

The ideal candidate will have a strong understanding of HR data, SQL, and Business Objects reporting platform to leverage data in order to create solutions that present data through reports, dashboards, scorecards, or KPI's. The candidate will serve as the key business resource to work with customers and Vendors to expand and improve the reporting content within our HR application(s).

Your essential duties will include:

* Supporting customers by turning business requirements into functional specifications and then executing delivery.
* Work directly with the customer to translate a business need into report requirements.
* Leading the technical lifecycle of data presentation from data sourcing to transforming into user-facing metrics/information.
* Lead/perform user acceptance/regression testing for a vendor reporting application (includes developing scripts, testing, logging defects and final signoff).
* Driving the collection of new data and the refinement of existing data sources to continually improve data quality.
* Designing structured multi-source data solutions to deliver reports or dashboards that make data actionable for our customers.


Bachelors or higher

3-5 years of report writing experience required (data warehouse experience a plus).

Proficient at independently writing SQL statements, including joins

Ability to work in a fast-paced environment where deadlines are essential.

Must have advanced Access and Excel experience.

Must have strong experience with report testing including dat validation and defect identification.

Must be able to work effectively across multiple databases with wide range of reporting tools

Excellent communication skills as well as the ability to use good judgment, problem-solving and decision-making skills.

Ability to work effectively with management on high level direction/decision-making as well as with IT/peers on very detailed, technical level.


The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.


Functional - Information Management/Query and Database Access Tools/4-6 Years

Functional - Information Management/Business information analysis/4-6 Years

Functional - Information Technology/Testing/4-6 Years


Technical - Reporting Tools/Oracle Reports/4-6 Years/Power User

Technical - Reporting Tools/Crystal Reports / Crystal Enterprise/4-6 Years/Power User


General Business/Consulting for Solutions/ADVANCED

Technology/Leveraging Technology/ADVANCED

Technology/Selecting and Applying Technology Solutions/MASTERY


General Business/Applying Reasoned Judgment/MASTERY

General Business/Communicating for Impact/MASTERY

General Business/Turning Data into Information/MASTERY



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.

Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Aetna takes our candidates's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.