SAS Data Modeler/Database Architect job at Cherokee Information Services

Job Description

Data Analysis and Entity Resolution

Develop an understanding of the customer’s data environment through data profiling and statistical analyses
Experience with developing predictive models for risk assessment arena using large data sets for high transactional volume environment
Experience with evaluating and measuring performance of models
Should have a basic understanding of common statistical modeling and techniques (e.g., linear regression, decision trees).
Execute complex SQL queries of large Oracle table(s) efficiently. (Note: Advanced command of SQL is important – beyond just simple PROC SQL commands in SAS to include perhaps something like Toad or Oracle SQL Developer.)
Conceptual understanding of – and/or prior experiences related to – data profiling, fuzzy matching, entity resolution, and signal detection theory (specifically with respect to SD theory: designing and improving upon systems that monitor, minimize, and balance false positive and false negative outcomes).
Perform the above tasks using Base SAS, SAS/ACCESS to Oracle, Enterprise Guide, DataFlux, and/or DI Studio.
Prior experience with DataFlux dfPower Studio required.
Experience with Enterprise Miner, and a specialized SAS enterprise solution (i.e., SAS Fraud Framework) helpful, but not required.

Experience in a Client-Facing Role

Attend daily meetings with the project team and additional technical sessions as needed.
Serve as a technical and analytical resource in efforts to integrate SAS technology into the production system—either indirectly or directly.
Perform any knowledge transfer related to SAS software required by the customer.

SAS 9.2 Platform Administration

Use Management Console to add users, register tables, and other basic administrative functions.
Install client SAS applications to other users as needed from a software depot.
Troubleshoot technical issues on a 3-tier Windows server environment and Windows desktops.
Document changes to system as needed.

The SAS Consultant will also:

Possess the ability to perform with little direct supervision as a self-starter.
Demonstrate excellent troubleshooting skills.
Be a self-motivated, creative, and inquisitive problem solver with a strong work ethic.
Be (or rapidly become) a thought-leader in the area of analytics/data science with respect to entity resolution as it pertains to the customer’s mission.
Be able to generate written documentation of all work performed.
Have a customer-focused demeanor.
Have effective oral and written communication skills.

Day to day responsibility

Ability to understand and analyze data models – how the data is stored in relational databases
Design and development of complex large scale OLTP system in Oracle environment
Manage a small team of data engineers responsible for performing various data analysis and on-going data base design and development
Obtain, scrub, explore, model and interpret data currently stored in Oracle databases – using SQL and other data mining tools like SAS or SPSS Modeler
Ability to understand system integration aspects of integrating model input and output in transactional systems to help real time decision making
Good understanding software application architecture and develop integration approaches for predictive models
Understand the data flow in ATS systems for targeting and incorporate models from both input and output perspective into these streams

Skills required

10-12 years of experience in data base programming, data modeling and design and development of large OLTP database using Oracle preferably running on Exadata.
3-5 years of leadership experience
Strong SQL programming skills
Experience in Oracle application design (e.g. Enterprise Manager, SQL Developer)
Experience in database/SQL performance tuning of large – multi-terabytes OLTP database
Hands-on experience creating and maintaining conceptual, logical and physical data models, preferably using ERwin 7.3 or later.
Hands-on experience developing fully normalized relational (3NF) data models
Candidate must be familiar modeling data structures to accommodate large scale (multi-terabytes) OLTP database systems
Experience in application/database documentation development, Database documentation: design/implementation recommendations, updated design specifications/database diagrams, data dictionaries, generate PDM DDLs, updated coding standards, performance tuning parameters.
Ability to support and assist the development and testing team in the design and implementation of database applications
Experience in performing data quality analysis and profiling tasks, including: Source/Client assessments, Data model integrity, Redundancy checks, Ranges and outliers Sparsity/density metrics.
Prior experience in working with Customs or ICE travel related data a plus
Experience with statistics, modeling and machine learning techniques a plus
Advanced – Master’s degree Computer Science or Applied Mathematics or Computational Statistics preferred
Strong organization and time management skills – prior experience in leading a small team is preferred
Excellent oral and written communication skills
Ability to work effectively within a team environment
Ability to work effectively in a high energy and a very rapid dynamic environment

Interested in this position?

Click here to learn how to get in touch