Nov 16, 2019
Aetna 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 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 expand and improve the reporting content within our HR application(s). 66244 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.
Professional Diversity Network Hartford, CT, USA Full-Time