Data Warehouse Engineer

Join AIL as a Data Warehouse Engineer. Candidates will utilize a broad skill set for data to architect, design, and develop a data warehouse analytics platform for our Single Family Buy-to-Rent business. This platform provides property level data and analytics for a nationwide portfolio.  In addition to designing the data warehouse, this role will be responsible for ETL and BI reporting system design, as well as, providing reports and tools that allow executives to understand the data and make critical future business decisions.  

Ideal Candidate:
  • An engineer who strives to build the best and most efficient data-driven platforms in today’s market.
  • Interest in researching emerging technologies and willing to explore new languages.
  • Ability to tackle and solve complex problems through data and analysis.
  • Passionate about delivering quality data solutions in a fast-paced environment.
  • Work with business owners, data and BI teams to determine the best architecture for the data warehouse
  • Gain and document and thorough understanding of the business and reporting needs 
  • Utilize SQL Server, SSIS and .NET tools and technologies to design and develop the data warehouse, including data import tools, SSAS cubes and BI reporting infrastructure
  • Develop tools, scripts, and queries to automate validation of data
  • Create ETL scripts for data integration into the data repository or data marts from source systems
  • Ensure timely availability of accurate data in our data warehouse
  • Develop tools, API integrations, etc. to support BI reporting
  • Develop tools, scripts, and queries to automate the validation of data
  • Troubleshoot and resolve issues with the data warehouse and external data feeds  
Required Skills and Experience
  • Bachelor’s degree in Computer Science, Mathematics, Engineering or related field.
  • Proven track record of designing and delivering scalable data warehouse solutions. 
  • Extensive experience with SQL Server, physical database design and modeling.
  • Expertise with SQL, SSIS, dimensional modeling, OLAP cube design, T-SQL, and SSAS. 
  • SQL performance analysis and tuning using the latest tools and techniques.
  • Experience with enterprise reporting tools such as SSRS or Tableau.
  • Ability to take ownership of projects with diligence and consistency in carrying out tasks with a high level of attention to detail.
  • Excellent written and verbal communications skills with the ability to function well in a team oriented and fast paced interrupt driven environment.
Bonus Skills and Experience 
  • C#
  • Enterprise reporting tools such as SSRS or Tableau.
  • Big Data, NoSQL and/or MapReduce technologies (Hadoop, Hive, Pig, etc.).
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 and PlayStation 4), on premise fitness center with showers/lockers and towel service, free snacks, and beverages (beer fridge!), breakfast taco Thursday and daily catered lunches!
Read Full Job Description
Apply now
loading ...


5001 Plaza on the Lake, Austin, TX 78746
5001 Plaza on the Lake, Austin, TX 78746

Perks of working here

Daily Meals Provided
Health Benefits
Stocked Kitchen
More Jobs at Amherst InsightLabs5 open jobs
Data + Analytics
Developer + Engineer
Data + Analytics
Amherst InsightLabs
Amherst InsightLabs
Data + Analytics
Amherst InsightLabs
Amherst InsightLabs
Amherst InsightLabs