Lead Data Engineer

| Austin
Lead Data Engineer – 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.
 
We are hiring for a Lead Data Engineer to utilize their industry knowledge, technical skills and passion for data to work closely with executive stakeholders and our financial engineering team developing solutions that support and optimize business operations. We’re solving a variety of Big Data challenges and modernizing legacy data loaders as well as exploring the benefits and tradeoffs of other cutting edge tools. In this role, you will be responsible for a variety of duties including; understanding our data, application design and development, SQL query optimization and ensuring accuracy and consistency of data.
 
Ideal Candidate:
  • Analytical mindset with the ability to structure and process qualitative data and draw insightful conclusions.
  • Problem solver able to take a complex business request and transform it into a clean, simple data solution.
  • Quick learner open to new ideas and technologies, and willing to offer creative solutions.
  • Ownership and prideful in work and brings new ways and ideas to the table.
Responsibilities:
  • Develop logical data models and processes to transform, cleanse, and normalize raw data into high-quality datasets aligned with our analytical requirements.
  • Develop and maintain comprehensive controls to ensure data quality and completeness.
  • Manage data movement through our infrastructure. Streamline existing data workflows to create a flexible, reliable, and faster process.
  • Develop real-time data transformations and validations.
  • Identify and onboard new data sources. Collaborate with data vendors and internal stakeholders to define requirements and build interfaces. Troubleshoot and resolve issues with data feeds.
  • Work with our team of researchers to identify and analyze investment opportunities in real estate and fixed income securities markets.
  • Design, develop, and implement data infrastructure and pipelines that collect, connect, centralize, and curate data from various internal and external data sources
  • Participate in data architecture discussions to understand target data structures, required data transformations and deliver data pipelines/ETL loading processes that meet requirements.
  • Perform detailed exploration of new internal and external source data to perform source-to-target mapping to inform the development of new data pipelines/flows.
  • Work in close collaboration with your data-minded colleagues focused on back-end development and business intelligence reporting.
  • Investigate the root cause of data-related issues and implement viable, sustainable solutions to correct issues.
  • Act as a lead to a small engineering group focused on the above responsibilities and duties
Requirements:
  • 3-5 years of experience in data analysis and/or management in an enterprise environment within finance, operations or analytics.
  • Passion for data organization, quality, and reliability.
  • MS SQL Server, Oracle, Postgres, Hive, Presto, etc. preferred. Experience developing complex efficient queries, designing and building logical data models, and working with large datasets on a relational database system
  • Experience with at least one language (e.g. Python, C#, Scala, Java).
  • Strong problem-solving skills.
  • Must be an intellectually curious self-starter and motivated to continually learn.
  • Proactive, hardworking team player with excellent communication skills
Bonus Skills:
  • Strong knowledge of statistics, including hands-on experience with SAS, R, Matlab, Machine Learning, AI.
  • Experience working with large datasets (1B+ Records)
  • Knowledge of Big Data or Cloud technologies 
  • Experience with version control (e.g. TFS, SVN or Git) and build tools.
  • Tableau/BI Tools
What We Offer:
  • 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!
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

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 Amherst31 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Sales
Finance
new
Austin
Finance
new
Austin
Project Mgmt
new
Austin
Developer
new
Austin
Finance
new
Austin
Sales
new
Austin
Finance
new
Austin
Data + Analytics
new
Austin
Marketing
new
Austin
Product
new
Austin
Finance
new
Austin
Operations
new
Austin
Data + Analytics
new
Austin
Developer
new
Austin
Finance
new
Austin
Operations
new
Austin
Product
new
Austin
Finance
new
Austin
Finance
new
Austin
Operations
new
Austin
Design + UX
new
Austin
HR
new
Austin
Project Mgmt
new
Austin
Data + Analytics
new
Austin