Lead, Data Engineer at Amherst
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.
Develop and design a data warehouse analytics platform to support analytics for each property within a nationwide portfolio. Utilize SQL Server tools and technologies to design and develop the data warehouse. Develop tools, scripts, and queries to automate validation of data, support BI reporting, and to automate the validation of data. Create ETL scripts for data integration into the data repository or data marts from source systems. Implement data infrastructure and pipelines that collect, connect, centralize, and curate data from various internal and external data sources. Troubleshoot and resolve issues with the data warehouse and external data feeds and implement viable, sustainable solutions to correct issues. Collaborate with business owners, data, and BI teams. Supervises up to 5 employees and/or contractors. Related degree and/or experience and/or skills required. Where a degree is required, the employer will accept a foreign degree equivalent. Where experience is required, the employer will accept university-level experience in lieu of work experience in a job offered or similar occupation.
Our full-time employee benefits include:
- A competitive compensation package, annual bonus, 401k match
- Flexible PTO including 7 paid holidays, 1 floating holiday, and 1 volunteer day
- Employer-paid benefits (medical, dental, vision, health savings account)
- Professional career development and reimbursement
- Up to 16 weeks paid maternity leave; up to 4 weeks of paid parental leave
- Backup childcare offered through Bright Horizons
- Relaxed casual environment with virtual 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.