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.
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/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
ADDITIONAL JOB INFORMATION
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.