See The Original Here

IT - Application Development

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. Youll 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, youll 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.

DentaQuest manages dental and vision benefits for more than 33 million Americans. Our outcomes-based, cost-effective solutions are designed for Medicaid and CHIP, Medicare Advantage, small and large businesses, and individuals. With a focus on prevention and value, we aim to make quality care accessible to improve the oral health of all.

Job Description

We support US flexible working arrangements in the contiguous 48 states.

Location

At Sun Life, we look for optimistic people who want to make life brighter for

ourClients.We

challengedbyworking

The opportunity

DentaQuest Business Intelligence Services team effectively and sustainably provides data solutions and tools across the organization. We integrate, transform, and improve volumes of data for the enterprise level reporting and analytic processes.

How you will contribute

  • The BI Developer plays a critical role in the partnering with clients across the enterprise in analyzing, creating complex ETL solutions and analytic process for supporting internal and external reporting.
  • Develops databases SQL queries for data analysis and data extracts/loads.
  • Utilizes experience with Informatica and/or SSIS and/or equivalent ETL (Extract, Transform, Load) to load and optimize solutions from multiple data sources.
  • Analyze, debug and tune SQL databases queries for performance improvements.
  • Develops and executes database queries and performs and documents data analysis, data validation, data mapping, design, produce data samples, prototypes and produce ad-hoc reports. Obtain and analyze data by accessing multiple sources and data warehouses. Demonstrate strong SQL skills to enable agile data analysis and data preparation for front end BI implementation.
  • Maintains business intelligence models to design, develop and generate both standard, ad-hoc reports, and automated reports.
  • Looks for ways to streamline report generation and provide business leaders with resources to enable informed decision making, including self-service tools that enable users to analyze data through many business dimensions with visibility to granular and historical data.
  • Identifies and resolves data reporting issues in a timely fashion, while looking for continuous improvement opportunities. Troubleshoots and performs root cause analysis on systems issues, across platforms and systems to ensure quick service restoration of problems.
  • Coordinates with Business Analysts and customers to develop and define business requirements and specifications documents for defined problems coordinates business plan for achieving desired outcomes, while understanding department objectives
  • Analyze and resolve problems and provides technical assistance as is necessary.
  • Implements corrective actions to legacy issues.
  • Conduct performance analysis and optimize ETL jobs, custom SQL and T-SQL jobs.
  • Working closely with multiple teams to design, develop and maintain SQL Stored procedures and Informatica and/or SSIS ETL scripts to implement Business Intelligence Solutions.
  • Other duties as needed or required.

What you will bring with you

Required

  • B.S. or MS degree in Computer Science, business or related discipline, or equivalent experience.
  • 4 year experience T-SQL Stored Procedures, Views and T-SQL design and development using Visual Studio and SQL Management Studio (or equivalent tools).
  • 4 Years' experience using SQL Server 2008, 2012 or equivalent tools.
  • 4 Years' exp. with ETL tools like Informatica and/or SSIS or equivalent tools.
  • 4 Years' experience using SQL Server Reporting Services or PowerBI equivalent tools.
  • 2 years exp. in design of appropriate data structures for the development of a database system.
  • 2 year Business Intelligence Architecture and Design experience.
  • Proven experience as a Power BI Developer or similar role.
  • Strong proficiency in Microsoft Power BI, including Power Query, DAX, and Power BI Desktop.
  • Advanced knowledge of data visualization principles and best practices.
  • Must have a high level of initiative and sound independent judgment.
  • Must be able to collaborate and take a team-based approach.
  • Required to attend additional training as requested/deemed necessary.

Preferred

  • 3 year's exp. with of report development (using reporting solutions like SSRS, Tableau, Cognos) preferred.
  • Experience with Healthcare data domain is strongly preferred.

PHYSICAL DEMANDS

  • Incumbent must be able to communicate effectively.
  • Requires overall light physical effort (up to 25lbs.)
  • Manual dexterity and sitting is required in carrying out position own position responsibilities (i.e. use of personal computer).
  • Ability to travel or move about within and outside serviced facilities required.
  • Incumbent works primarily in either a private or shared office environment.

Do you see yourself in this role even if you haven't checked all the boxes above? We welcome all talented candidates and are committed to a culture that represents diversity in all forms. If you think you might thrive in this setting, we would love to hear from you.

Not ready to apply yet but want to stay in touch?

Join our talent community

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 Globes 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 region $80,000 - $120,000 annually
  • Central region $84,300 - $126,500 annually
  • Northern region $90,200 - $135, 300 annually

If you are a Colorado resident, the salary range for this position is $76,300 - $114,500 annually.

If you are a New York resident, the salary range for this position is $90,200 - $135, 300 annually.

If you are Washington resident, the salary range for this position is $84,300 - $126,500 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

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 employeeCalifornia Privacy Policy and Notice.Job CategoryPosting End Date

n

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 vetera