Data Science Consultant II

Salary Range: $70,000 – $160,000

We’ve Got You Under Our Wing

We are the duck. We develop and empower our people, cultivate relationships, give back to our community, and celebrate every success along the way. We do it all…The Aflac Way.

Aflac, a Fortune 500 company, is an industry leader in voluntary insurance products that pay cash directly to policyholders and one of America's best-known brands. Aflac has been recognized as Fortune’s 50 Best Workplaces for Diversity and as one of World’s Most Ethical Companies by Ethisphere.com.

Our business is about being there for people in need. So, ask yourself, are you the duck? If so, there’s a home, and a flourishing career for you at Aflac.

Work Designation. This role is remote. This means you will be expected to work from your home, within the continental US. There may be occasions that you are requested to come to the office based on business need. Any requests to come to the office would be communicated with you in advance.

What does it take to be successful at Aflac?

• Acting with Integrity
• Communicating Effectively
• Pursuing Self-Development
• Serving Customers
• Supporting Change
• Supporting Organizational Goals
• Working with Diverse Populations

What does it take to be successful in this role?

• SQL & Relational Databases Advanced
• Experience with object-oriented function scripting languages: Python, Java, C++, Scala, etc
• Experience with data pipeline and workflow management tools
• Business Intelligence and Data Science Analyses

Education & Experience Required

• Bachelor’s Degree in programming/systems or computer science, Statistics, Mathematics or related field preferred
• Four to six years of job related experience or an equivalent combination of education and experience
• Requires experience and understanding of multiple programming languages and applicable applications including SQL and ETL.

Or an equivalent combination of education and experience

Principal Duties & Responsibilities

• Leads, develops, maintains and integrates processes which extract data from standardizes or varied data sources.
• Creates and maintains ideal data pipeline architecture.
• Build infrastructure for data extraction, transformation, and loading of data from a variety of data sources using various scripting languages
• Builds analytics tools that utilize the data pipeline to provide actionable insights into key business performance metrics.
• Creates data tools for data science team(s) utilization
• Develops, maintains, and test infrastructures for data generation
• Designs solutions for Data Science Analyst/Consultant enabling them to perform their task
• Transforms data for storing in proper formats and structures for querying and analysis
• Creates data validation rule on source data to confirm the data has correct and/or expected values; Writes alternate workflow steps or reports back to the source for further analysis and correction of incorrect record(s) when validation rules are not passed
• Develops processes to be applied to extracted source data to move to target state; Writes data cleansing functions to get data to proper prunes data set to include only fields needed; translates source code values to target value; Standardizes free form values to codes; Derives new values through calculations on existing fields; Merges data from multiple in order to generate on consolidated source for the target
• Develops processes which load the transformed data into end target systems (database, file, application, etc.); may apply different techniques based on business needs including inserting new data into target; Over write existing data with cumulative information; Updates existing data at some frequency; Creates data validation steps in this layer to ensure loaded data

Total Rewards

This compensation range is specific to the job level and takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to: education, experience, licensure, certifications, geographic location, and internal equity. The range has been created in good faith based on information known to Aflac at the time of the posting. Compensation decisions are dependent on the circumstances of each case. This salary range does not include any potential incentive pay or benefits, however, such information will be provided separately when appropriate. The salary range for this position is $70,000 to $160,000.

In addition to the base salary, we offer an array of benefits to meet your needs including medical, dental, and vision coverage, prescription drug coverage, health care flexible spending, dependent care flexible spending, Aflac supplemental policies (Accident, Cancer, Critical Illness and Hospital Indemnity offered at no costs to employee), 401(k) plans, annual bonuses, and an opportunity to purchase company stock. On an annual basis, you’ll also be offered 11 paid holidays, up to 20 days PTO to be used for any reason, and, if eligible, state mandated sick leave (Washington employees accrue 1 hour sick leave for every 40 hours worked) and other leaves of absence, if eligible, when needed to support your physical, financial, and emotional well-being. Aflac complies with all applicable leave laws, including, but not limited to sick and safe leave, and adoption and parental leave, in all states and localities.