Data Warehouse Engineer

Sorry, this job was removed at 1:02 p.m. (CST) on Thursday, March 1, 2018
Find out who's hiring in Austin.
See all Data + Analytics jobs in Austin
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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.

Responsibilities

  • 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
By clicking Apply Now you agree to share your profile information with the hiring company.

Location

Austin at our HQ with beautiful views of Lake Austin in a modern office as well as our second office in the top floor of the Frost Tower downtown

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about DO NOT USE - AmherstFind similar jobs