Job Details

Email to Friend Save Back

Data Scientist

ATLANTA-30312, GA, US
11/05/2018

-

Required Skills

Oracle Application

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

DATA SCIENTIST

Seeking an experienced Data Scientist to join a recently formed Strategic Analytics team within a global financial organization.

The Data Scientist will be responsible for identifying and developing comprehensive data sets for new and existing projects. The successful candidate will work in close collaboration with teams that include Data Warehouse, Sales, Finance and other stakeholders.

The Data Scientist must be results-oriented, self-motivated and have the ability to thrive in small teams and very fast-pace environments.

Excellent verbal and written communication skills and organizational skills are required.

Responsibilities

Design and develop tools to enhance current and future data requirements from multiple data sources

Interact with project stakeholders to provide solutions addressing business data analytic requirements

Ensure that development requirements are clearly understood and that work is consistent with requirements

Provide accurate completion deadlines

Work with SQL and other database access tools and methods to address business or technical requirements

Design, implement and support data movement solutions across multiple platforms and data sources (Database tables/views and external files) using custom code and ETL tools and frameworks

Contribute to UI modernization actively developing functionalities and participating in design discussions Conduct PL/SQL, shell scripting and advanced SQL developments

Ability to generate, modify and version database object scripts (DML/DDL)

Become proficient in the data model and data structures to be able to efficiently respond to business queries and requests

Provide ongoing maintenance and support of database schemas and views

Conduct root cause analysis and resolve production problems and data issues

Work within the defined software development lifecycle, following rigorous change control policies

Create and maintain up to date documentation of the data model, data flow and field level mappings

Requirements

Bachelor degree

3+ years of experience as a Data Scientist in a professional setting working on database developments for various transactional and/or analytical database systems

Significant experience in the development process with hands on experience of basic design, structured programming, work reviews, testing cycles from unit to acceptance testing, release build, implementation and post release bug/issue fixes

Excellent information management skills (architecture, design, development and support) in ETL, Database, Reporting & Big Data

Extensive experience programming analytic models using R, Python, Java, MATLAB, SAS, or other programming language

Experience in modeling behavior of financial instruments by either statistical and/or machine learning methods

Strong background with Oracle SQL (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, materialized views, distributed transactions) and Oracle SQL Performance/Tuning

Advanced proficiency with PL/SQL Packages/Functions/Procedures programming and debugging, Oracle Collection and Object Types

Experience with Oracle Data Pump, SQL*Loader and external tables framework

Experience working with large volumes of data and relational / dimensional data models

Good understanding of Oracle Database Architecture

Experience with Oracle development tools (TOAD, Oracle SQL Developer…) and Source Control Software Advanced knowledge in scripting in Unix/Linux environment

Experience with business intelligence reporting tools (SQL query, Business Objects), data integration tools (Informatica, etc.), and metadata repository processes and tools

Experience with financial reporting is a plus

Experience with Oracle Application Express is a plus

Experience with Snaplogic and/or Talend ETL is a plus

Must be resourceful, self-motivated, and comfortable working under pressure in an unstructured environment with little supervision

Strong written and oral communications skills

Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly

Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills

Ability to work in a team-oriented, collaborative environment