Job Description :

We have an immediate requirement , Please find the below job description and if you have any Suitable profile please share  to the  . kindly share your updated resume.

Role: Data Scientist/Data Analyst (Datawarehouse Development)

Location: Richmond, VA

Job type: Long term


Working knowledge on Click stream Analytics

Traffic Analysis,

Sales Funnel Analysis,

Personalization of High Net worth individuals,

Tracking Experiments,

Identity Stiching,

Discover New mediums

Datawarehouse principles, Data Analysis, Enrichment, Data definition, Transformation, Storage, Target Data Modeling. [Mandatory]


SQL Server [ Mandatory ]



Programming Language:

Python 3.x.x [ Mandatory ]

C# ( Optional )

ETL Tools



SQLServer SSIS, [ Mandatory ]


Microsoft BI

Spark RDD [ Preferred ]

Storage Layer Tools [ One of the tools is Mandatory ]

Elastic Search

Mongo DB

AWS RedShift [ Preferred ]

Azure DW [ Preferred ]

Google BigQuery


Amazon S3/HDFS [ Preferred ]

Reporting Tools ( One of the tools is mandatory )

Power BI



Job Description:

Coordinate with cross-functional teams to understand the client and business requirements.

· Analyze requirements and determine technical feasibility.

· Good knowledge on Datawarehouse principles and sound database design skills.

· Thorough understanding of SQL queries, joins, triggers, cursors, packages, procedures. [Mandatory]

· Ability to understand and develop DataMarts based on the Business requirements and reporting needs.

· Ability to develop programs in Python that can be used to onboard click stream data into the Data Lake. [Mandatory]

· Ability to enrich the Data with other In House CORE Database models to produce strategic reports.

· Ability to work on Database designing for the reporting needs by understanding the unstructured data into suitable RDBMS schema. [Mandatory]

· Create point in time snapshots of the ClickStream Analytics and build knowledge-base based on the Analytics data with Algorithms.

· Ability to do Machine Learning through Spark RDD and Graph processing. [Preferred ]

· Working knowledge of MapReduce. [Preferred ]


Sikkander | IT Recruiter

AVTECH Solutions Inc.

EX 503 (Direct)