Enterprise Data Architect

| Austin
Enterprise Data Architect - Austin, TX
 
Founded in 1993, Amherst is a financial services company headquartered in Austin, TX. We offer a wide array of brokerage, investment banking and advisory services covering the residential, commercial mortgage and structured finance markets for global institutional investors. We’ve developed cutting edge proprietary analytical tools and methodologies that give us the competitive edge in our broker dealer, origination and asset manager lines of business.
 
We are currently looking for an enterprise data architect to be a hands-on leader in the governance, management and stewardship of data across the organization. This role will work with engineering, business leaders, security, and investor services teams to help understand and track the flow of data throughout Amherst and third party systems. Reporting to the Director of Datawarehouse and Business Intelligence, this position is critical towards establishing trusted data through careful data management and curation.
 
 
Duties and Responsibilities
 
We are seeking a hand-on technical data leader with demonstrated track record of data architecture and design:
  • Build and deploy Data Governance and data lineage systems to support data ownership and transparancy across the enterprise using tools such as Manta and Collibra
  • Architect data flow and master data management - Map, Rationalize, Model, and Manage master enterprise data
  • Design, Build and deploy Integrations – Build and deploy consistency and availability of core business data across the enterprise data landscape
  • Produce conceptual, logical and physical data models, interface specifications, data flow diagrams, and a range of other models as needed, using industry-leading modelling tools
  • Document the data architecture and environment in order to maintain a current and accurate view of the larger data picture
  • Develop, update and maintain Data Governance methodologies, including documentation, tools, approach, and identifying data owners
  • Act as the primary advocate of data modelling methodologies and data processing best practices
  • Select and assist in the implementation of the appropriate tools, software, applications, vendors and service providers to support company goals to solve data problems
  • Map data sources, document interfaces and data movement
  • Work with Business Leaders to architect current and future data needs
  • Architect, design and build new ETL layers across the enviroment. Provide recommendations and key changes to improve current data flow and ETL.
  • Support data engineering team with solving the most difficult problems and providing hands-on development assistance
 
Required Experience/Skills
  • 10+ years of prior experience in data architecture, data warehousing or data goverance
  • Experience in data modeling, data lineage, data quality, data cleansing
  • Experience architecting and deploying data governance tools
  • Must be versed in different approaches to data architecture and applications including traditional and modern Data warehousing concepts and Data Lakes
  • Demonstrate experience designing, deploying and maintaining architectures across Data Storage, Knowledge Discovery, Data Governance, Data Visualization and Data Security and Privacy
  • Experience building ETL workflows and familiarity with design principles
  • Experience with data warehouse architecutres - Normalized / Denormalized / Star / Snowflake / Kimball design concepts
  • Expert in MS SQL Server 2014/2016 and in writing TSQL scrips, stored procedures, views and triggers
  • Expertise in SQL Server performance tuning and troubleshooting enterprise data systems
  • Preferred experience in C#, .NET
  • Experience in financial services is a plus
 
What we offer:
  • A competitive compensation package, annual bonus, 401k match
  • Flexible PTO, 8 paid holidays
  • Employer paid benefits (medical, dental, vision, health savings account)
  • Professional career development and reimbursement
Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • D3JSLibraries
    • jQueryLibraries
    • ReactLibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • Node.jsFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases

Location

5001 Plaza on the Lake, Austin, TX 78746

An Insider's view of Amherst

What are some social events your company does?

Amherst is always participating in exciting events. From Dell Match Play to SXSW, Amherst engages in a variety of local events. We also host smaller events for employees such as summer BBQ's and happy hours. Nothing tops our holiday party, a true family celebration!

Nicole Giannetta

VP Corporate Affairs

What makes someone successful on your team?

Our team juggles many different deadlines, so being able to stay organized is key! It’s also helpful to be very detail oriented and comfortable in a fast paced environment, but most importantly, you need to have a solid sense of humor and to be able to laugh at yourself (and us).

Jordan Perras

Investor Services

What are Amherst Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Company Outings
Free Daily Meals
Stocked Kitchen
Happy Hours
Parking
Fitness Subsidies

Additional Perks + Benefits

Competitive compensation and bonus program. Flexible PTO. Health, vision, dental and long term disability coverage. Paid maternity/paternity leave. Attractive office space. Training certifications assistance. Daily catered lunch and stocked kitchens. Monthly birthday celebrations. Casual work environment with regular team-building outings. Breakfast Taco Thursday.

More Jobs at Amherst33 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Sales
Content
Project Mgmt
new
Austin
Finance
new
Austin
Product
new
Austin
Data + Analytics
new
Austin
Finance
new
Austin
Operations
new
Austin
Developer
new
Austin
Developer
new
Austin
Finance
new
Austin
Developer
new
Austin
Data + Analytics
new
Austin
Developer
new
Austin
Content
new
Austin
Operations
new
Austin
Operations
new
Austin
Project Mgmt
new
Austin
Data + Analytics
new
Austin
Operations
new
Austin
Marketing
new
Austin
Operations
new
Austin
Data + Analytics
new
Austin
Developer
new
Austin
Data + Analytics
new
Austin
Finance
new
Austin