IT Data Architect

Information Technology Dallas, Texas Salt Lake City, Utah


Description

IT Data Architect

 

PURPOSE

The Data Architect will be accountable to design both the logical and physical data model that represents the Worldwide Express business information. Working across multiple IT and Business groups, this position will understand the business needs and define the master data model that will be the foundation for our new platform, and ensure the development of the database and database access is appropriate to meet business needs.  This individual will also collect metadata pairing it with business process from various sources to create standardization of data definitions from a business and technical perspective.

 

ESSENTIAL DUTIES, RESPONSIBILITIES & OUTCOMES

  • Understands the current data structures to get good grasp of as is environment
  • Designs master data model across all business functions
  • Creates logical and physical data models for next generation across the entire product lifecycle
  • Develops, maintains, and governs data model policies and standards based on industry best practices
  • Ensure appropriate implementation of master data model recommendations within software and systems
  • Evolves the overall master data model, including the functions, entities within those functions and attributes within those entities as business needs shift and change
  • Drives overall master data governance process
  • Ensures strong collaboration with business teams on any changes required to master data model to meet future business needs
  • Defines criteria, specifications and data standards for the creation, storage and usage of operational and analytical data models.  Standards include naming conventions, derivation and other quality measures
  • Ensures master data model meets the need of both the operational business needs and the needs of the Business Intelligence teams to ensure master data model meets their future analytical and reporting needs

 

 

WHAT WE EXPECT FROM YOU:

 

EDUCATION

  • Bachelor’s Degree
  • Master’s Degree Preferred

 

EXPERIENCE

  • 5+ years of related experience in complex data environments
  • 5+ years of experience in strong SQL background
  • 5+ years of experience in writing ETL packages
  • 5+ years of hands on experience in database and SQL performance tuning
  • 3+ years of scripting experience in Linux sell / python / Perl
  • 3+ years of experience with XML, JSON, SOAP structure file formats
  • Excellent understanding of relational database concepts, impact of design on performance
  • Strong experience with master data modeling best practices and data warehousing concepts
  • Experience using data modeling tools like Erwin, Toad, Embarcadero, etc.
  • Experience using Hadoop / Cloudera / Impala / Hive
  • Experience using industry standard version control systems like SVN, GIT
  • Experience working with BI tools for data visualization like Tableau
  • Excellent written and, verbal, analytical and presentation skills
  • Experience in the logistics/transportation industry or adjacent industries applicable to WWEX.

 

KNOWLEDGE OF

  • Understanding of the industry, specific WWEX business model, and unique characteristics of the Company.
  • Building collaborative relationships across teams, leaders and vendors

 

 

SKILLS AND ABILITIES IN

  • Organizational effectiveness, consulting, coaching, and solution development.
  • Verbal and written communication skills.
  • Conflict management and problem solving.
  • Assessment and decision-making skills.
  • Relationship building both within the organization and with external sources.
  • Presentation and facilitation skills.
  • Analytical.
  • Deductive and inductive reasoning.
  • Critical thinking.
  • Forward thinking.
  • Operational Expertise.

 

WE ARE COMMITTED TO GIVING YOU:

  • A competitive Salary
  • Advancement opportunity
  • A comprehensive benefits package including medical, dental and vision coverage as well as the opportunity to participate in a 401(k) program


WHO ARE WE?

Quite simply, we make shipping simple. Worldwide Express is a relationship company offering customers a comprehensive solution for their shipping needs, whether it be small package, less-than-truckload or full truckload. We are a local partner for our customers’ global supply chain, providing consultative service from more than 125 offices across the nation. Through our relationship with UPS® and a highly selective carrier portfolio, we provide our customers with a breadth of shipping options unmatched in the 3PL field.

Worldwide Express has a strategic partnership with UPS for light package, domestic and international shipping to penetrate the small to medium size business sector. As UPS's largest non-retail authorized reseller in North America, our sales teams do what they do best, which is providing solutions to C-Level executives while letting UPS do what they do best: deliver more packages on time than anyone else. In addition to our relationship with UPS, WWEX has alliances with over 65 LTL, Domestic Air Freight, and International Air Freight carriers. WWEX provides tailored services and individualized shipping solutions to fit the needs of any small to medium-sized business customers.


Worldwide Express is an Equal Opportunity Employer. Worldwide Express Operations, LLC and WWEX Franchise Holdings, LLC ,(collectively “Worldwide Express”) strive to make employment decisions on the basis of merit, seeking the most qualified individuals in every job.  All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, pregnancy, gender identity or expression, sexual orientation, marital status, national origin or ancestry, genetics, disability, age, veteran status, or other status protected by law.  All employment decisions will be based on valid job requirements or other legitimate, non-discriminatory reasons.  Worldwide Express offers reasonable accommodations for individuals with disabilities in the job application and hiring process.  If you would like to request such an accommodation, please contact the Vice President of Human Resources for Worldwide Express.