Skip to main content

HR Reporting Lead

Primary Location: Hartford, CT
Additional Locations: CT-Hartford
Apply
Description:
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. 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 from creation of test scripts to final signoff.
The ideal candidate must 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 expand and improve the reporting content within our HR application(s).

Fundamental Components:
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.
  • Perform impact analysis of HR Data Warehouse and existing reports as changes are proposed or implemented in source systems. Consult with other teams to help identify solutions to solve business needs while minimizing the impact to HR DW and other applications.
  • Driving the collection of new data and the refinement of existing data sources to continually improve data quality.
  • Expand the content of the HR Data Warehouse based on business needs – includes working close with HR/IT organization to identify specifically how changes should be implemented to ensure most reporting flexibility while minimizing impact to other data and reports.
  • Perform user acceptance/regression testing as new content is being added to HR Data Warehouse.
  • Evolving the HR Data Warehouse by working with HR Leaders to develop a strategic roadmap for Data Warehousing and BI
#LI-HH1


Background Experience:
To be considered for this role, you must have:
  • Bachelor’s degree or higher.
  • Must have experience working with a data warehouse and HR data.
  • 1-3 years of Report design and development.
  • Advanced knowledge of SQL
  • Ability to work in a fast-paced environment where deadlines are essential.
  • Must be able to work effectively across multiple databases with wide range of reporting tools and have strong troubleshooting skills to identify the source of an identified reporting issue.
  • Excellent communication skills as well as the ability to use good judgment, problem-solving and decision-making skills.
  • Must be able to manage multiple initiatives at the same time, ensure all deliverables are completed on time, and work effectively independently.


Required Skills:
General Business - Consulting for Solutions, General Business - Turning Data into Information, Technology - Selecting and Applying Technology Solutions

Desired Skills:
General Business - Applying Reasoned Judgment, General Business - Communicating for Impact, Technology - Leveraging Technology

Functional Skills:
Information Management - Business information analysis, Information Management - Query and Database Access Tools, Information Technology - Testing

Technology Experience:
Database - Microsoft SQL Server, Reporting Tool - Business Objects, Reporting Tool - Crystal Reports / Crystal Enterprise

Potential Telework Position:
Yes

Percent of Travel Required:
0 - 10%

EEO Statement:
Aetna is an Equal Opportunity, Affirmative Action Employer

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

Candidate Privacy Information:
Aetna takes our candidate'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.

Click To Review Our Benefits (PDF)

Apply

Jobs for you

Recently Viewed Jobs

You do not have any recently viewed jobs

Your Saved Jobs

You do not have any saved jobs

Sign up for Job Alerts

Join our Talent Community

At Aetna, we are pioneering a total approach to health and wellness and we need talented candidates like you to join our team. Become a member of our talent community to be the first to know about career initiatives that match your skills and interests as they become available, in addition to details on upcoming events, networking opportunities, and news about Aetna.

Join Our Talent Community

Sign up to receive information about job openings that are tailored to your skills and interests. Plus, get the latest career news from Aetna.