United Shore

  • Data Architect

    Business Unit
    United Shore
    Location
    US-MI-Pontiac
  •  

    At United Shore 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 United Shore 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 PERKS

    United Shore is a diverse group of over 2,700 mortgage experts, sales superstars, tech gurus, marketing whizzes and more. We’re a $30 billion and growing, family owned and operated company that still feels like family. Our award-winning workplace just happens to be home to the #1 wholesale mortgage lender in the nation, United Wholesale Mortgage. And we believe in setting our team members up for success by creating a unique, energetic culture where you can be yourself and still reach your professional goals.

     

    Here are some of the reasons you’ll love working here:

    • Free fruit, soft drinks and coffee
    • Gourmet cafeteria featuring homemade breakfast, lunch and a stationary food truck featuring $1 sliders
    • Wellness area including an in-house primary-care doctor’s office, full-time massage therapist and hair salon
    • Large, state-of-the-art fitness center with a full-size basketball court, outdoor sand volleyball court, plus Zumba and yoga classes
    • Convenience store featuring grab-and-go snacks
    • In-house Starbucks and indoor/outdoor café with Wi-Fi
    • Lawn vouchers to concerts at DTE Energy Music Theatre
    • Escape room for team-building activities
    • Indoor/outdoor putting greens
    • Bicycle-sharing program with bike and jogging paths

    DISCLAIMER

    All the above duties and responsibilities are essential job functions subject to reasonable accommodation. All job requirements listed indicate the minimum level of knowledge, skills and/or ability deemed necessary to perform the job proficiently. Employees may be required to perform any other job related instructions as requested by their supervisor, subject to reasonable accommodations. This document does not create an employment contract, implied or otherwise, other than an "at will" employment relationship. United Shore Financial Services is an Equal Opportunity/Affirmative Action Employer.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With United Shore!

    Not ready to apply? Connect with us for general consideration.