Data Architect

Company: United Wholesale Mortgage
Location: Pontiac
Posted on: February 22, 2021

Job Description:

At UWM Data Architects (DAs) are thought leaders that collaborate with and across functional teams to create and design new data models, structure data warehouses, and enforce Data Governance best practices.DAs are big data specialists and champions of data integrity. At UMW, our DAs have extensive data modeling skills and provide prescriptive guidance across storage, operating systems, RDBMS & NoSQL databases, data analytics, BI/reporting and security.As a DA you will be responsible for the availability, curation, stewardship and usability of our vast data estate. The ideal candidate will have experience with conceptual, logical and physical data modeling and passionate about defining data architecture framework, standards and principles.Joining UWM as a DA gives you the opportunity to make a positive impact by helping to shape the future of how people purchase a home.This position reports directly to Architecture.WHAT YOU WILL BE DOING

• Design and implement a modern data architecture (warehouse, relational, NoSQL, data streaming, containers, microservices, iPaaS)
• Experience defining Data Flows, reference data architecture, and Inmon, Kimball, OLAP, star and snowflake schemas
• Management of the availability, usability and security of our data
• Maintaining database model for performance
• Interact well with multiple teams
• Strong ability to prioritize multiple simultaneous requests
• Help aid in the success of projects WHAT WE NEED FROM YOU Required:
  • 5+ Years of database development and modeling experience
  • Working knowledge of SQL Server as a DBA or Developer
  • Ability to work with limited guidance in a team environment
  • Computer-related degree or equivalent work experience
  • Experience in evaluating technologies
  • Full software life-cycle experience
  • Ability to mentor team members
  • Schema Design (Relational & Dimensional)
  • OLTP / OLAP / Graph / Multi-Model / NoSQL
  • ETL/ELT process design and tooling
  • Data Modeling Tools (Erwin Data Modeler, etc.) Preferred:
    • Experience with Hardware/Software specific to data architecture
    • Experience with BI Tooling (PowerBI/Excel, Tableau)
    • Awareness/experience with Kafka, Kylin, marklogic, cassandra, Hadoop, cosmosdb, HDFS, R
    • Experience in evaluating services offered by external vendors
    • Experience in the mortgage industry
    • Experience in an Agile environment
    • Architecture Certification (TOGAF, CITA, EACOE). THE PLACE & THE PERKSReady to join thousands of talented team members who are making the dream of home ownership possible for more Americans? It's all happening on UWM's campus, where our award-winning workplace packs plenty of perks and amenities that keep the atmosphere buzzing with energy and excitement.It's no wonder that out of our six pillars, People Are Our Greatest Asset is number one. It's at the very heart of how we treat each other, our clients and our community. Whether it's providing elite client service or continuously striving to improve, our pillars provide a pathway to a more successful personal and professional life.From the team member that holds a door open to the one that helps guide your career, you'll feel the encouragement and support on day one. No matter your race, creed, gender, age, sexual orientation and ethnicity, you'll be welcomed here. Accepted here. And empowered to Be You Here.More reasons you'll love working here include:
      • Paid Time Off (PTO) after just 30 days
      • Additional parental and maternity leave benefits after 12 months
      • Adoption reimbursement program
      • Paid volunteer hours
      • Paid training and career development
      • Medical, dental, vision and life insurance
      • 401k with employer match
      • Mortgage discount and area business discounts
      • Free membership to our large, state-of-the-art fitness center, including exercise classes such as yoga and Zumba, various sports leagues and a full-size basketball court
      • Wellness area, including an in-house primary-care physician's office, full-time massage therapist and hair salon
      • Gourmet cafeteria featuring homemade breakfast and lunch
      • Convenience store featuring healthy grab-and-go snacks
      • In-house Starbucks and Great Lakes Coffee Roasting Company
      • Indoor/outdoor caf with Wi-Fi DISCLAIMERAll the above duties and responsibilities are essential job functions subject to reasonable accommodation and change. All job requirements listed indicate the minimum level of knowledge, skills and/or ability deemed necessary to perform the job proficiently. Team members may be required to perform other or different job-related duties as requested by their team lead, subject to reasonable accommodation. This document does not create an employment contract, implied or otherwise. Employment with UWM is "at-will." UWM is an Equal Opportunity Employer. Apply for this job online Refer this job to a friend Share on your newsfeed Connect with UWM! Not sure what to apply for? Connect with us to speak with a recruiter and explore opportunities! - provided by Dice

Keywords: United Wholesale Mortgage, Pontiac , Data Architect, Hospitality & Tourism , Pontiac, Michigan