Aetna Program Business Analyst in Hartford, Connecticut
Req ID: 55142BR
This position is accountable for the business analysis functions for Commercial Sales Effectiveness team - from leading requirements gathering/ brainstorming sessions to providing the technical data warehousing/ reporting specs to the core technical team/s. Sales effectiveness team is growing and developing new applications for Producer and Sales reporting. These applications will have internal and external users and have a heavy impact on the strategy directions. Person, in this role, will be responsible for creation of process workflow documents, lead requirements sessions with business leaders, create Data warehouse Source to Target mapping rules, coordinate across business and IT teams for integrated capability. Position would often require pulling analytical insights from the data and presenting to IT/ Non-IT leads and get their buy-in. The ability to work in a fast-paced environment and a passion for exceeding users expectations are key qualities to be successful in this role.
Consistently performs analysis and translates business needs to create high-quality Business Requirements and Functional Specifications documentation to solve most complex problems (multiple interfaces with other systems across multiple business units) considering all impacted components from an end-to-end perspective.
Ensure that the current & proposed business Process Flows are complete and accurate as needed to support the Requirements Specification documentation
Competent to work at the highest technical level of all phases of business systems, process and application analysis across multiple applications aligned to a domain or programs.
Ensures creation of the appropriate User Guides/ documentation
Consult or facilitate sessions to identify opportunities/ propose technical solutions to business problems (advanced level).
Proactively monitors, identifies, and communicates risks and issues that may impact any aspect of the project to the appropriate leadership.
Completes project activities on time, and proactively identifies and communicates issues that may jeopardize milestones.
Ensures regular updates of the Product Overviews, FAQs, Tool Glossaries, system training materials, and system user documentation
Creates high level technical specification documents (Data warehouse source to target mapping documents) for all translations rules and reports
Create test scripts for testing the functionality created by the project and help setup the test data
Performs Quality testing and User acceptance testing
Performs data analysis to identify analytical insights and prepare material/s (powerpoint or Tableau) to present the outcome with senior leaders
Maintain data models and ensure data integrity, avoid data redundancy, recommend solutions to support business requirements
Evaluate external products vs. the internal build out and provide insights for the decision making/ propose new solutions in existing or new applications
Mentors other team members
10+ years of Technical Business Analyst experience (Data warehouse)
3+ years supervisory/management experience or leading enterprise wide complex project requirements/ data warehouse projects
Ability to recognize complex problems vs. objectives and apply creativity to analyze situations, develop solutions and procedures.
Preference to someone with Sales, Producer/ Broker experience
The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.
LICENSES AND CERTIFICATIONS
Information Technology/Business Systems Analyst is desired
Functional - Information Management/Business information analysis/More Than 10 Years
Functional - Information Technology/Testing/7-10 Years
Functional - Information Management/Solutions consulting and decision support/7-10 Years
Functional - Information Management/Query and Database Access Tools/More Than 10 Years
Functional - Information Management/Decision trees and classification rules/4-6 Years
Technical - Database/DB2/More Than 10 Years/Power User
Technical - Database/SQL Server/7-10 Years/Power User
General Business/Applying Reasoned Judgment/ADVANCED
General Business/Communicating for Impact/FOUNDATION
General Business/Consulting for Solutions/ADVANCED
General Business/Turning Data into Information/ADVANCED
General Business/Demonstrating Business and Industry Acumen/ADVANCED
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.
Job Function: Information Technology
Aetna is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected Veterans status.