Role : Data Analyst - Designer
Location : Minneapolis,MN
Duration : 12+ Months
Rate : $50/hr on C2C(Max)
Job Description :
Required Skills: 7 - 10+ 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:
- 7 - 10+ 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
Soft skills:
- 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 Apply Now
Washington, District of Columbia