Data Analyst - Designer

Company: Cloud Analytics Technologies LLC
Location: Minneapolis
Posted on: November 6, 2024

Job Description:

Work Authorization: US Citizen, Green Card, H-1B, GC-EAD, OPT-EAD, L2-EAD, TN VisaUS 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.Job DescriptionRole: Data Analyst - DesignerLocation: Minneapolis, MNDuration: 12+ MonthsRate: $50/hr on C2C (Max)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;
  • Determine database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating and analyzing data in current systems;
  • Develop data warehouse solutions by designing proposed system; utilizing data warehouse design techniques; defining database physical models and functional capabilities, following 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; documenting actions; ensuring application and business partners' data access adheres to Enterprise Security policy standards;
  • Maintain database performance by identifying and resolving production and application problems; evaluating, integrating, and installing new releases; updating models; completing maintenance; answering user questions;
  • Consult on data warehouse and cube design and metadata layers; reviewing design against common methodologies and standards.Project: 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;
    • Excellent oral and written communication skills;
    • Lead/mentor/offshore experience is ideal.Equal Opportunity EmployerCloud 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

Keywords: Cloud Analytics Technologies LLC, Apple Valley , Data Analyst - Designer, Professions , Minneapolis, Minnesota