Data Science Consultant II

Key Skills

Java Programming, Python Programming, C++, SQL, Scala Programming, Data science techniques, Business Intelligence, Shell Scripting language, Lean Six Sigma, Data pipelines, ETL frameworks, Data Architecture

Job Description

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

Competencies

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