Amherst InsightLabs (AIL) is a leader in data analytics and engineering within the FinTech industry. We continually seek quantitative thinkers who are passionate about creating reliable, scalable, data-driven systems that help mitigate risk for our clients and strive to create innovative solutions in the FinTech space. If you thrive in a fast paced environment, enjoy solving complex business problems with a forward-thinking and collaborative approach with direct social impact, then look no further. We have an exciting and energetic atmosphere with a team of leading FinTech engineers including Wall Street Quantitative Analysts, PhD’s and Data Scientists with expertise in mortgage and real estate.

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!
 
Find more startup and tech jobs in Austin
Loading...
Apply Now
Why work with us
AIL brings teamwork, integrity and excellence to new levels. Our cohesive team of FinTech professionals provide proprietary software and models that support the Amherst Holdings business lines and third parties. Our passion for excellence sets the standards for FinTech solutions. We are proud to be the proven technology developer for Amherst for the past 20+ years and are actively looking for fresh talent, eager to bring new ideas to the table, to join our team.
Culture
At AIL, we believe you’re only as strong as the team behind the company. Which is why we created a team-oriented environment. We seek to maintain an open culture, similar to that of a startup, where every team member feels valuable. Our open, collaborative office setting allows for direct interaction with senior executives, creating a dynamic atmosphere. Our goal is to create a culture that fosters individual and team growth. We offer robust benefits and perks to further enhance our rich company culture.
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

Oh no!

You're fresh out of job post slots.

Upgrade your planmanage current jobs

Create an account

Let startups find you

Create a profile and upload your resume today.

Saved Jobs
Job Saved
Find your saved jobs by scrolling over this star

Oh no!

You're fresh out of job post slots.