Skip to main content

Lead Business Consultant

Primary Location: Hartford, CT
Additional Locations: CT-Hartford
Lead Business Consultant

Fundamental Components:
Working with Aetna commercial sales unit, responsible for the Sales Effectiveness programs which includes projects related to enterprise, enabling consistent process across the segments and markets. Ensure the stability of the application and cross department projects (i.e. with internal Sales, Underwriting, Case Installation, Marketing and Finance teams). Ensure system capabilities are deployed in alignment with desired business processes. Analyze science, engineering, business and other data processing problems to implement and improve computer systems. Perform advanced SQL programming in data warehouse environment including use of different analysis techniques or business intelligence application development. Explore, examine and interpret large volumes of data in various forms. Perform analysis of structured and unstructured data to solve moderately complex business problems. Responsible for end to end testing of the Sales effectiveness reporting suite and implementing appropriate validation controls to control data quality. Develop requirements to automate data quality scripts to ensure the data integrity and completeness of the data. Conduct analysis and outcome studies using sales data, employing appropriate research designs to identify insights. Develop, validate and execute algorithms, data models and reporting tools that answer applied research and business questions for internal and external clients. Define and deliver analytical solutions in support of sales business initiatives that drive short and long term objectives.

Background Experience:
Bachelor’s degree in Computer Science, Information Technology or related field. Minimum five years of experience working in multiple Data projects required, either in job offered or as an Computer Developer/Programmer/Analyst. Must have at least 5 years of experience working with the following: SQL; IBM DB2; Excel, PowerPoint;. Must have experience creating UAT scenarios; management reporting; programming in data warehouse or big data analytics environments; statistical analysis techniques; and analytic programming tools and reporting tools including SAS; SQL; and MS Office

Potential Telework Position:

Percent of Travel Required:

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

Benefit Eligibility:
Benefit eligibility may vary by 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.


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, a CVS Health Company, 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, a CVS Health Company.

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, a CVS Health Company.