Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 7th Nov 2020
Role : Data Analyst - Data warehouse Consultant
Duration : Englewood, CO
Duration : 6-12 months C2C
Experience : 8+ years
H1B also fine with PP details.
Roles & Responsibility:
Mandatory Requirements:
At least 3 years work experience as a data analyst in an enterprise data warehouse environment with sound knowledge in the following domains
· Data Analysis and Data Quality
· Data Warehouse Overall Architecture & Data Modelling
· Data Warehouse Databases
· Data Sourcing, Acquisition, Staging, Cleanup and Transformation Tools
· Data Marts creation
· Meta data
· Information Delivery System ( Analytics and Reporting )
· The candidate will be required to Prepare data quality analysis (DQA) artifacts, including recommendations and data profiles used in the analysis and interpretation of data as appropriate.
· The Candidate will be expected to proactively drive to improve processes and methods around Data Analysis. This could include helping define standards and procedures; refining methods and techniques for information modeling, recommend tools to improve delivery timeframes.
· Responsible for designing and supporting the components of data warehouses such as ETL processes, databases, reports and reporting environments.
· The candidate will be required to discover, analyze, profile and document findings on source data systems for data integration projects.
· Collects, evaluates, and prepares data analysis and/or other complex statistics on databases for a specific business unit.
· Identifies and documents all requirements both fresh and current data warehouse components and Reports by working with End Users.
· The position requires very strong SQL development skills as the candidate will be required to develop analytical reports using SQL.
· The ideal candidate will be a self-starting individual who is able to drive into details and quickly provide summary level readouts of the source data.
· The position requires very strong communication skills as the candidate will be required to interact on a daily basis with all levels within the organization, including business users, architects, developers and management.
· The Candidate will be responsible for preparing ETL technical specification documents post system/requirements analysis and also assist the ETL team during the development phase to resolve data issues and understand data constraints. Once development activities are completed the candidate will drive the initial system testing of the final application data output to ensure it is consistent with the source data system.
· Ensures quality control of databases through the development and maintenance of test plans and quality control procedures and may assist in development and implementation of measurement systems.
Desired
· Experience with SQL and modeling tools is desired
· Experience with Teradata and other relational databases is desired.
· Experience with very large databases and knowledge of media domain preferred.
· Experience with AWS and/ or other Cloud Platforms is desired
Mandatory Skills:
· Data warehousing Professional
· Excellent oral and written communication skills
· Solid traditional Data warehousing experience – minimum 4 years
· Excellent RDBMS Knowledge
· Excellent SQL development skills
· Excellent Analytical and Problem Solving Skills
Questions to be asked for choosing the right profile
1) Do you have Traditional and/or Cloud Data Warehousing experience? If so what percentage for each?
The Ideal candidate’s experience mix for this role would be Traditional (65-70%): Cloud (25 -30%).
Meaning traditional DWH experience is an absolute must, Cloud is “nice to have”.
2) As a data analyst, were you part of an Enterprise Data warehousing Team?
If so how for many years?
3) Have you worked on Data warehouses built on /Teradata/ Oracle/DB2/SQL Server or any other relational database management system? If so what was your role and for how many years?
4) Have you used SQL/Advanced SQL to create Reports from the Data warehouse? If so for how many years?
5) Have you translated business requirements for data warehouse - data integration into technical requirements? If so for how many years?
6) Have you used any reporting tools? If so which ones and for how many years?
Profiles that are not a good fit:
· Exclusively Data scientist profiles
· Exclusively BI developer profiles: Tableau, Power BI
· Exclusively Data Engineer / ETL developer profiles
· Exclusively NON - DWH data analyst profile
Partial (but not complete) list of data warehouse platforms today:
DW survivors, originally on premise, now hybrid
Teradata
Oracle
Microsoft
IBM
Pivotal/Greenplum
Pure Cloud
Redshift [Amazon]
Snowflake [Snowflake]
Incorta
Google
Thanks & Regards
Praveen Mahendra
Sr. Technical Recruiter
IDC Technologies.
Ph: 408-868-5126
Email: Praveen.mahendra@idctechnologies.com