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 Data Architecture and DB Optimization.

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 rapidly growing, family-owned company that feels very much like family. Our team is a diverse group of mortgage experts, sales superstars, tech gurus, marketing whizzes and more. And our award-winning workplace just happens to be home to the #1 wholesale mortgage lender in the nation, United Wholesale Mortgage. 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:

  • Large, state-of-the-art fitness center with a full-size basketball court, outdoor sand volleyball court, plus Zumba and yoga classes
  • 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, and a dedicated food truck
  • Free fruit, soft drinks and coffee
  • Convenience store featuring grab-and-go snacks
  • In-house Starbucks and indoor/outdoor café with Wi-Fi
  • Escape room designed for team-building activities
  • Indoor/outdoor putting greens 

DISCLAIMER

All 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 United Shore is "at-will." United Shore is an Equal Opportunity 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 sure what to apply for? Connect with us to speak with a Recruiter and explore opportunities!