Data Analyst - Minneapolis, United States - Cloud Analytics Technologies LLC

Description

Work Authorization:
US Citizen, Green Card, H-1B, GC-EAD, OPT-EAD, L2-EAD, TN Visa
US citizens (USC) and Permanent Residents (GC) are encouraged to apply. We are unable to offer any sort of Visa sponsorship for this position.
Local Candidates Preferred. Non-local candidates must be willing to pay for your own interview travel expenses and relocation costs
**Candidates submitted over the max. bill rate will be automatically disqualified and counted as a submittal. For each position CBD allows only 2 (two) submittals from our
sub-vendors/partners. So please send us only the exact matching profiles for better chances of shortlisting and quick response.
Job Description

Role :
Data Analyst - Designer

Location :
Minneapolis,MN

Duration : 12+ Months


Rate :
$50/hr on C2C(Max)


Job Description :

Required Skills:
years experience with medium to expert Data Analysis and minimum 4 years Data Modeling;
Hands-on working experience with Power Designer or Erwin data modeling tools;
2 – 4+ years experience working with Teradata

Responsibilities:
Coordinate with the Business Analysts, business Intelligence team, and end users to understand reporting requirements, translating them into Data Warehouse design;
Create necessary Functional Specification Documentation (i.e. source target mapping, data models, business rules, etc.) to support the business requirements;
Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating and analyzing data in current systems;
Develops data warehouse solutions by designing proposed system; Utilizing data warehouse design techniques; Defining database physical models and functional capabilities, follow EDA and Enterprise level standards, security procedures, back-up, and recovery specifications;
Work closely with the DBA team while defining and implementing physical database structures;
Facilitate design and architecture concept discussions with Development team to define ETL processes;
Implement database structure by developing process flow diagrams; applying optimum access techniques; coordinating installation actions; documents actions; ensure application and business partners data access adheres to Enterprise Security policy standards;
Maintains database performance by identifying and resolving production and application problems; evaluating, integrating, and installing new releases; updating models; completing maintenance; answering user questions;
Consult data warehouse and cube design and metadata layers; reviewing design against common methodologies and standard;

Project (how does this affect the company/why open?):
Current focus is a technology asset management project. Identifying parent/child relationships as it pertains to all of Wells Fargo's technology assets (i.e. printers, computers, phones, etc.) Need to understand, source, and integrate data points of over 1 Trillion. They need to find a creative solution to more efficiently process this data.

Requirements:
years experience with medium to expert Data Analysis and minimum 4 years Data Modeling;
Hands-on working experience with Power Designer or Erwin data modeling tools;
2 – 4+ years experience working with Teradata;
Mid-to-high end SQL skills;
Excellent experience presenting Enterprise Data Warehouse design and modeling solutions to technical teams and business partners;
Solid understanding of Metadata concepts; including data mapping, business level metadata and technical metadata
Excellent oral and written communications skills;
Lead/mentor/offshore experience is ideal.

Equal Opportunity Employer Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V).

Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status.

Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters.

Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract

Equal Opportunity Employer Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V).

Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status.

Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters.

Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract

#J-18808-Ljbffr