Share this Job

Data Science Consultant II

The Company:  Aflac Columbus
The Location: 

Columbus, GA, US, 31999

The Division:  Sales Operations & Analytics
Job Id:  3014


Opportunity: Data Science Consultant II- Research & Development


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


  • Minimum Required Bachelor's Degree programming/systems or computer science, Statistics, Mathematics, or related field preferred
  • Minimum Required Four to six years of job-related experience or an equivalent combination of education and experience
  • Minimum Required 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 
  • Communicating Effectively 
  • Pursuing Self-Development 
  • Serving Customers 
  • Supporting Change 
  • Supporting Organizational Goals
  • Working with Diverse Populations 



Nearest Major Market: Columbus GA