Share this Job

Data Science Consultant II

The Company:  Aflac Columbus
The Location: 

Columbus, GA, US, 31999

The Division:  Individual Benefits
Job Id:  1858


Job Summary

Responsible for building data pipelines and optimizing data flow and collection. Supports developers, architects, analyst and data science analyst/consultants on data initiatives, ensuring data delivery is consistent throughout ongoing projects.


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


Education & Experience Required


  • Bachelor's Degree 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


Job Knowledge & Skills


• 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




  • Acting with Integrity - Clearly states goals and beliefs; lets people know his/her true intentions; does what he she said they would do; follows through on commitments
  • Communicating Effectively - Expresses ideas and information in a clear and concise manner; tailors message to fit the interests and needs of the audience; delivers information in a manner that is interesting and compelling to the listener
  • Pursuing Self-Development - Demonstrates ambition and desire to move forward in his/her career; engages others in discussions about career development; seeks feedback on ways to increase his/her performance; takes advantage of opportunities to build new skills and capabilities
  • Serving Customers - Builds strong relationships with customers; stays aware of customer needs, concerns and satisfaction; responds promptly to customer questions and requests; effectively manages
  • Supporting Change - Enthusiastically participates in new change initiatives and programs; focuses on reasons why changes will work and how they will be beneficial
  • Supporting Organizational Goals - Actively supports organizational goals and values; demonstrates enthusiasm toward the company's goals and mission; aligns actions around organizational goals
  • Working with Diverse Populations - Shows respect for the beliefs and traditions of others; encourages and promotes practices that support cultural diversity; discourages behaviors or practices that may be perceived as unfair, biased, or critical toward people with certain backgrounds



Nearest Major Market: Columbus GA