Database Developer at Amherst

| Austin
Sorry, this job was removed at 11:33 a.m. (CST) on Tuesday, July 9, 2019
Find out who's hiring in Austin.
See all Data + Analytics jobs in Austin
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Database Developer– Austin, TX
 
Amherst is revolutionizing the way U.S. real estate is priced, managed and financed in order to unlock opportunities for all market participants. Driven by data, analytics and technology, Amherst has a 20-year history of anticipating where the next risks and opportunities are likely to emerge and designing actionable strategies for investors to capitalize on opportunities across residential real estate, commercial real estate and public securities. Amherst, along with its affiliates and subsidiaries, has more than 900 employees, $5 billion under management and approximately $15 billion under advisement and oversight. www.amherst.com 
 
What we are looking for:
 
As our Database Developer you will use your broad skill set and passion for data to architect, design and develop data platforms which will provide property level data and analytics for each property within our nationwide portfolio. We are looking for a database developer with experience in the Microsoft full stack on SQL Server (2014/2016) to support and grow our core datawarehouse processing across the enterprise and help solve data problems. In addition to designing and building data systems you will also be responsible for ETL and data processing systems that provide data and tools that allow our executives to understand the data and make critical future business decisions. This position will require oncall rotational support including nights and weekends. 
 
A little more about this role:
  • Design, modify, and implement core tooling to support the data warehouse and ETL processing 
  • Define standards & governance surrounding the use of our core datawarehouse system tools
  • Ability to multi-task between multiple ETL partner/vendor integration projects
  • Design and build data structures and processes to populate data warehouse systems using knowledge of relational and dimensional data modeling techniques
  • Recommend and implement alterations and improvements to back end ETL applications and APIs to improve stability, security and performance
  • Create unit tests, validation procedures, and document technical specifications
  • Troubleshoot data/system issues as required
What you’ll need to have:
  • Strong knowledge of MS SQL Server (SQL Server 2012/2016) and TSQL
  • Solve complex requirements using advanced level SQL techniques such as window functions, CTEs, cross apply, etc.
  • Experience designing and building logical data models, and working with large datasets on a relational database system
  • Solid programming foundations and proficiency in the following languages: C# and/or Java
  • Exposure to building service-oriented applications using C# and WebAPIs
  • Excellent communication skills. Able to effectively communicate with both technical and non-technical audiences
Additional Skills and Experience: (Preferred, but Not Required)
  •  BA/BS in Computer Science, Mathematics, Engineering or related field
  • Experience with Hadoop on Cloudera or Hortonworks
  • Experience in financial industry is a plus. Domain knowledge of financial industry concepts: Securities, Capital Markets, Real Estate Assets etc. is desirable.
  • Messaging technologies such as Rabbit MQ, Solace, Tibco
  • Financial Analytics Data Providers: Bloomberg BPipe, YieldBook, Intex, Corelogic
  • Experience with Agile Methodology and JIRA
  • Experience with version control (e.g. TFS, SVN or Git) and build tools
    What we offer: 
     
    Amherst is a privately held corporation located in West Austin with beautiful views of Lake Austin and the loop 360 bridge in a modern workspace with open floor plans.
    • 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
    • On-premise fitness center, locker rooms
    • Daily catered lunches, fully stocked kitchen with snacks/drinks
    • Relaxed casual environment and weekly/quarterly office events!
    Amherst is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information or veteran status, and encourage all applicants to apply.
    Read Full Job Description
    Apply now
    By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

    Technology we use

    • Engineering
    • Product
      • .NETLanguages
      • C#Languages
      • JavascriptLanguages
      • RLanguages
      • SqlLanguages
      • D3JSLibraries
      • jQueryLibraries
      • ReactLibraries
      • ReduxLibraries
      • AngularJSFrameworks
      • ASP.NETFrameworks
      • HadoopFrameworks
      • Node.jsFrameworks
      • HBaseDatabases
      • Microsoft SQL ServerDatabases
      • MongoDBDatabases
      • HadoopDatabases
      • AsanaManagement
      • ConfluenceManagement
      • JIRAManagement

    Location

    Two offices around Austin at our HQ with beautiful views of Lake Austin in a modern office and our tech co-working space near Lady Bird Lake

    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!

    Austen

    Director of Talent Programs

    What projects are you most excited about?

    I'm most excited about our Budget Revision Project! We were tasked with the challenge of moving a tedious process into a more user and mobile friendly system. This will allow the field teams to submit budget revisions from MSR Properties and have one system to manage the majority of their work. This excitement is why I love being a part of the team

    Gage

    Business Analyst

    How has your career grown since starting at the company?

    “At Amherst, I am able to work collaboratively with peers who have had years of experience similar to mine. The technology is current and evolving as the company grows. Therefore, my skills stay current and always improve.”

    Stan

    Senior Systems Engineer

    How do your team's ideas influence the company's direction?

    My team is expected to create new IP (Intellectual Property) through innovation in software, hardware, workflow process and data. Our goal is to build franchise value/shareholder value, solve difficult problems through creative solutions, and improve over-all efficiency that in turn makes life easier for all of Amherst

    Todd

    Chief Technology Innovation Officer

    What are some things you learned at the company?

    Within my first year, I have acquired solid enterprise-level knowledge in developing .NET applications by using Angular 4+, ASP.NET MVC, WPF, Entity Framework, and advanced SQL. We’re transitioning into ‘React’ apps that I'm excited about as it will add to my tech skills. I like that we have autonomy regarding the tech decisions in development

    Ruchi

    Software Engineer

    What are Amherst Perks + Benefits

    Amherst Benefits Overview

    Competitive salaries
    Choice of Mac or Windows hardware
    Flexible vacation days, paid holidays, and work from home options
    Medical, Dental, Vision, LTD, Life, EAP, and 401K with matching benefits
    Stellar colleagues with proven track records
    Free sodas, kombucha, cold brew, beer and healthy and unhealthy snacks at our Barton Springs WeWork location
    Free lunch every day and breakfast tacos on Thursdays!

    Culture
    Friends outside of work
    Eat lunch together
    Daily stand up
    Open door policy
    Group brainstorming sessions
    Open office floor plan
    Diversity
    Highly diverse management team
    Health Insurance & Wellness Benefits
    Flexible Spending Account (FSA)
    Disability Insurance
    Dental Benefits
    Vision Benefits
    Health Insurance Benefits
    Life Insurance
    Retirement & Stock Options Benefits
    401(K)
    401(K) Matching
    Performance Bonus
    Child Care & Parental Leave Benefits
    Generous Parental Leave
    Flexible Work Schedule
    Amherst provides employees with a flexible work schedule that includes Flexible start and end times.
    Remote Work Program
    Family Medical Leave
    Vacation & Time Off Benefits
    Generous PTO
    Paid Holidays
    Paid Sick Days
    Perks & Discounts
    Beer on Tap
    Casual Dress
    Company Outings
    Free Daily Meals
    Stocked Kitchen
    Happy Hours
    Parking
    Pet Friendly
    Our coworking space near Ladybird Lake is pet-friendly!
    Relocation Assistance
    We offer relocation assistance depending on location and position.
    Professional Development Benefits
    Job Training & Conferences
    Acme Co. offers employees professional development opportunities like Annual individual budget for training, Onsite training courses, The ability to attend job related conferences and seminars.
    Lunch and learns
    Acme Co. hosts lunch and learn meetings weekly.
    Promote from within
    Time allotted for learning
    Amherst. allows employes to set aside 50% of working hours for learning.
    Online course subscriptions available
    Customized development tracks

    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 Amherst18 open jobs
    All Jobs
    Finance
    Data + Analytics
    Internships
    Marketing
    Operations
    Product
    Sales
    Internships
    new
    Austin
    Operations
    new
    Austin
    Operations
    new
    Austin
    Data + Analytics
    new
    Austin
    Marketing
    new
    Austin
    Finance
    new
    Austin
    Finance
    new
    Austin
    Finance
    new
    Austin
    Finance
    new
    Austin
    Sales
    new
    Austin
    Finance
    new
    Austin
    Sales
    new
    Austin
    Operations
    new
    Austin
    Apply now
    By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
    Save jobView Amherst's full profileSee more Amherst jobs