Associate Data Engineer (Analytics)
Join Amherst InsightLabs as an Associate Data Engineer (Analytics) to help maintain and enhance our best in class repository of property, mortgage loan, and fixed income securities data and analytics. This platform drives the market-leading performance of a diverse group of real estate finance businesses.
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 the real estate and fixed income securities markets.
Requirements:
- Bachelor’s degree in Computer Science, Mathematics, Engineering or related field.
- 3+ years of experience in data analysis and management in an enterprise environment within finance, operations or analytics.
- Passion for data organization, quality, and reliability.
- MS SQL Server skills. 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 scripting language (e.g. Python, Perl, PowerShell).
- Strong problem-solving skills.
- Must be an intellectually curious self-starter and motivated to continually learn.
- Proactive, hardworking team player with excellent communication skills
Additional Skills and Experience (Not Required):
- Strong knowledge of statistics, including hands-on experience with SAS, R, or Matlab.
- Command of object oriented programming languages (e.g. C++, C#, Java).
- Experience with version control (e.g. TFS, SVN or Git) and build tools.
- Master’s degree in a technical field.Commercial real estate or lending experience.
- Tableau
We Offer:
Amherst Holdings LLC is a privately held corporation and is located in West Austin with beautiful views of Lake Austin and the loop 360 bridge in a beautifully renovated modern workspace with the latest technologies.
We offer a competitive compensation package including bonus, 401k, flexible PTO, 11 paid holidays, accrued sick/personal time, employer paid benefits (medical, dental, vision), maternity/paternity paid leave, life insurance and more. Our new office features a large gaming area (ping pong/pool table/golf), on premise fitness center with showers/lockers and towel service, free snacks, and beverages (beer fridge!), breakfast taco Thursday and daily catered lunches!