Senior Data Support Engineer
Kansas City, MO Office
You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.
Job Description:
This role involves the support of our data organization. The role will cover ETL support, report support and data lake support. There are numerous technologies used by the team (SQL, Oracle, Crystal Reports, SSRS, LOGI, Tableau Informatica, SSIS etc..) so the candidate will have the opportunity to learn or strengthen a wide range of skills. In addition to supporting these processes the role will involve creation of new ETL processes, reports etc from time to time. The role will involve on call off hours support as part of a regular scheduled rotation.
Preferred Skills
- Technically minded problem solver
- Basic engineering, system administration and software development (programming) foundation
- Ability to apply basic testing skills, tools/frameworks, techniques, processes and principles to software solutions in support of defect management and reporting
- Basic knowledge of performance testing coding best practices, and load and performance testing
- Familiarity with and ability to utilize multiple software development methodologies, processes, development best practices and DevOps principles
Qualifications
Education
- Bachelor’s degree in Computer Science, Information Systems, or equivalent work experience.
Competencies
- Ability to Communicate effectively with business partners
- Technical knowledge of ETL processes , reporting tools, etc.
- Ability to solve technical problems
Previous Experience
Minimum of 4+ years post qualification experience in a software engineering role with exposure to the full SDLC (Software and product Development Life Cycle), preferably on enterprise scale systems
All or a combination of the below skillsets
- Strong Microsoft BI skills (Microsoft stack experience as a very basic minimum).
- Experience with Business Intelligence and reporting tools such as Business Objects, Crystal or LOGIXML.
- Experience with ETL tools such as PowerCenter Informatica.
- Job scheduling experience (Autosys)
- Experience of working in the financial services sector (particularly insurance, ideally group benefits)
- AWS Cloud experience desirable but not essential (EC2, EMR, S3, Kinesis, Dynamo, API (Application Programming Interface) Gateway & LAMDA)
Responsibilities
- Monitoring of our ETL processes and reports where necessary
- Troubleshooting failures in our production environment
- Resolving issues and restarting production processes in a timely fashion
- Updating code and ETL processes where necessary to resolve issues
- Dealing directly with our internal business partners to help get to the root of a reported problem.
- Providing detailed updates on work assignments to managers
Not ready to apply yet but want to stay in touch? Join our talent community to stay connected until the time is right for you!
Life is brighter when you work at Sun Life
-
Excellent benefits and wellness programs to support the three pillars of your well-being – mental, physical and financial – including generous vacation and sick time, market-leading paid family, parental and adoption leave, a partially-paid sabbatical program, medical plans, company paid life and AD&D insurance as well as disability programs and more
-
Retirement and Stock Purchase programs to help build and enhance your future financial security including a 401(k) plan with an employer-paid match as well as an employer-funded retirement account
-
A flexible work environment with a friendly, caring, collaborative and inclusive culture
-
Great Place to Work® Certified in Canada and the U.S.
-
Named as a “Top 10” employer by the Boston Globe's “Top Places to Work” two years running
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
If you are a California resident, the salary range for this position is:
-
Southern California region: $86,000 - $129,000 annually
-
Central California region: $90,600 - $135,900 annually
-
Northern California region: $96,900 - $145,400 annually
If you are a Colorado or Nevada resident, the salary range for this position is $ 102,600 - $123,200 annually
If you are a Connecticut or Maryland resident, the salary range for this position $86,000 - $129,000 annually
If you are Washington or Rhode Island resident, the salary range for this position is $90,600 - $135,900 annually
If you are a New York resident, the salary range for this position is $96,900 - $145,400 annually
We consider various factors in determining actual pay including your skills, qualifications, and experience. In addition to salary, this position is eligible for incentive awards based on individual and business performance as well as a broad range of competitive benefits.
Sun Life Financial is a leading provider of group insurance benefits in the U.S., helping people protect what they love about their lives. More than just a name, Sun Life symbolizes our brand promise of making life brighter -for our customers, partners, and communities. Join our talented, diverse workforce and launch a rewarding career. Visit us at www.sunlife.com/us to learn more.
At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.
#LI-remote
Our Affirmative Action Program affirms our commitment to make reasonable accommodation to the known physical or mental limitation of otherwise-qualified individuals with disabilities or special disabled veterans, unless the accommodation would impose an undue hardship on the operation of our business. Please email recruitingUS@sunlife.com to request an accommodation.
At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.
For applicants residing in California, please read our employee California Privacy Policy and Notice.
Job Category:
IT - Application DevelopmentPosting End Date:
20/12/2024All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
ApplyJob Profile
Adoption leave Company Paid Life and AD&D Insurance Disability Programs Dynamic colleagues Excellent benefits Flexible work environment Generous vacation Generous vacation and sick time Inclusive culture Life and AD&D insurance Life Insurance Medical plans Paid Family Leave Parental leave Retirement account Sabbatical Program Sick time Stock purchase programs Wellness programs
Tasks- Communicate with business partners
- Monitor ETL processes
- Scheduling
- Support data organization
- Troubleshoot production issues
- Update code and ETL processes
API Autosys AWS AWS Cloud Business Intelligence Crystal Reports Defect management DevOps ETL Informatica Logi Microsoft BI Monitoring Oracle Organization Performance Testing Reporting Scheduling SDLC Software Development SQL SSIS SSRS Tableau Troubleshooting
Experience4 years
EducationBachelor's degree in Computer Science Bachelor's degree in information systems Business Computer Science Degree Equivalent Equivalent work experience
TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9