Senior Integration Analyst

| Chicago

POSITION SUMMARY
The Senior Integration Analyst will be responsible for executing & delivering on data work for Implementation & Ongoing clients. The Senior Integration Analyst is a subject matter expert in bswift data needs including initial data conversion, ongoing data import processes, automated data execution processes to verify and maintain data integrity. They will be responsible to for data execution for testing and production rounds and consult with business colleagues on solutions.

Fundamental Components:
- Consistently reflect our core values of higher standards, greater accountability, and more fun to bswift associates, clients, and partners
- Work with the Integration Leader to manage the data integration project for our clients by developing a repeatable process for a project's life cycle through Microsoft SQL Server Management Studio and provide status updates to the Integration Leader on conversion progress and/or issues
- Manage data project timelines, project status, open items log and relevant project documents with the Integration Leader and for our bswift Implementation team
- Manage client and carrier/vendor expectations, anticipating possible issues and communicating turnaround times with reasonable delivery dates to the Integration Leader
- Responsible for understanding all details of ongoing demographic, and data conversion for our client implementations
- Verifying ongoing data integrity through the development of automated data audit processes
- Perform analysis and coordinate the conversion development by developing the process using SQL-based scripts to meet client deliverables
- Develop ongoing demographic full/change & payroll full/change test plans by working with the Integration Leader
- Proactively identifying and mitigating project risks
- Responsible for consulting clients on best practices, industry standards, and process changes to achieve client goals. Maintain upkeep on internal best practices documentation with joint effort from the team
- Act as a coach and mentor for data/payroll solutions
- Overall accountability for success of projects

BACKGROUND/EXPERIENCE desired:
- 1-3 years of demonstrated SQL knowledge
- 1-3 years of project/program/process management experience
- 1-3 years of data interpretation and analysis experience
- Excellent verbal and written communication skills
- Demonstrated ability to effectively coordinate multiple projects simultaneously in a fast paced environment

EDUCATION
The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.

FUNCTIONAL EXPERIENCES
Functional - Information Management/Query and Database Access Tools/1-3 Years
Functional - Information Technology/Testing/1-3 Years
Functional - Information Technology/Project management/1-3 Years
Functional - Information Management/Data acquisition, data management, programming and documentation/1-3 Years
Functional - Information Management/Database Structures/1-3 Years

TECHNOLOGY EXPERIENCES
- Technical - Database/SQL Server/1-3 Years/

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.

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.
 

Read Full Job Description

Location

10 S Riverside Plaza, Suite 1100, Chicago, IL 60606
10 S Riverside Plaza, Suite 1100, Chicago, IL 60606

What are bswift Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
A flexible spending account lets you set aside pretax dollars to help pay for certain types of health care and/or dependent care expenses.
Dental Benefits
Choose between a dental maintenance organization plan and preferred provider organization plan. Both cover certain preventive care services at 100%. They also offer coverage for basic services.
Vision Benefits
You can enroll in a separate vision plan. It covers eyeglasses and contact lenses. Preventive vision exams are covered through the Aetna medical plan.
Health Insurance Benefits
You can choose from three types of medical plans: a health savings account, a health reimbursement arrangement or a hybrid health plan. Certain preventive care services are covered at 100 percent when
Life Insurance
All employees get term life insurance and business travel accident insurance at no added cost. You have the option to buy: Supplemental term life insurance Accidental death and personal loss insura
Wellness Programs
Our employee wellness program offers services such as wellness campaigns, weight-management programs and educational seminars.
Onsite Gym
Retirement & Stock Options Benefits
401(K)
You can save a percentage of your pay in the 401(k) plan, on a pretax and/or Roth after-tax basis. You may participate in the 401(k) plan immediately following your hire.
401(K) Matching
We match a portion of your contribution. You can invest your contributions among various options offered in the plan.
Company Equity
You can purchase Aetna stock at a discount through a payroll deduction. In order to participate, eligible employees must enroll during the enrollment period announced by Aetna.
Vacation & Time Off Benefits
Generous PTO
During your first 3 years at Aetna, you receive the equivalent of 18 days off per year. The longer you work at Aetna, the more time you accrue per month.
Paid Volunteer Time
One of our values is to improve the quality of life in communities through employee volunteerism.
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Stocked Kitchen
Happy Hours
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
We encourage professional development. That's why we provide financial support for continuing education. This program covers a portion of tuition and registration fees for a college course.

Additional Perks + Benefits

The following programs, activities, and amenities are available to employees at bswift: complimentary fresh fruit, on-site flu shots, massages during open enrollment season, walking treadmill desk, foosball and ping-pong tables, casual attire, zen room for relaxation and nursing mothers, full week of employee appreciation, and proximity to public transportation • Healthy lifestyle incentive programs - This incentive program is offered to all eligible employees. You can earn up to $500 for healthy eating, physical activity and other healthy behaviors. Family members can also earn incentives • During your first 3 years at bswift, you receive the equivalent of 18 days off per year. The longer you work at bswift, the more time you accrue per month. Company holidays, jury duty, military leave, bereavement and community service time are in addition to your paid time off • You can purchase company stock at a discount through a payroll deduction.

More Jobs at bswift23 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Operations
Project Mgmt
Operations
new
bswift
Project Mgmt
new
bswift
Operations
new
bswift
Operations
new
bswift
Project Mgmt
new
bswift
Operations
new
bswift
Operations
new
bswift
Developer
new
bswift
Developer
new
bswift
Design + UX
new
bswift
Design + UX
new
bswift
Project Mgmt
new
bswift
Developer
new
bswift
Data + Analytics
new
bswift