Skip navigation
Data Warehouse Engineer

Data Warehouse Engineer

Job Description

Data drives All Web Leads' success. AWL’s Technology team is looking for a Data Warehouse Engineer to play a pivotal role in building and deploying systems that allow the entire company to access and utilize the data that enables AWL’s success. In this role, you will collaborate with a multidisciplinary team of engineers, product managers, business intelligence analysts, online marketers, and sales managers on a wide range of data-driven solutions that will shape the future of our company.

As an AWL Data Warehouse Engineer, you will be accountable for the performance, stability, and integrity of our data warehouses and OLAP cubes. Our business is fueled by the customer, web traffic, click stream, and calculated measures data that reside in and are accessed via these systems.

All Web Leads, Inc. (AWL) is one of the most successful online lead generation providers to the US Insurance industry. Our amazing team of extremely talented and successful individuals uses internet marketing to turn consumer interest in insurance products into policy sales for many of the largest insurance carriers (and their agents) in the world. Our growth over the past several years has been remarkable. We’ve been recognized by the Austin Business Journal as one of their “Fast 50" fastest growing private companies in Central Texas for the third consecutive year. We are a tight-knit team with a fast paced, energetic, and entrepreneurial company culture. We are highly profitable and Austin-based. We provide competitive pay, excellent benefits, and a fun and collaborative work environment.

Responsibilities will include:

  • Working closely with system owners, BI analysts, and revenue/profit owners across all parts of the company.
  • Leading projects and collaborating with others on requirements and product deliverables.
  • Architecting OLAP cubes for reporting and processing purposes.
  • Analyzing data anomalies and performing root cause analysis.
  • Monitoring, managing, and maintaining AWL’s databases such that performance meets expectations.
  • Implementing automated data quality checks and monitoring.
  • Educating the BI and engineering teams on data domain knowledge and best practices for querying data sets.
  • Working with developers to drive best practices for efficient database and OLAP performance

Job Requirements

  • 3-5 years of experience in a software development role with a focus on data systems.
  • Significant hands-on experience with modern RDBMS technologies (e.g. MySQL, Vertica, Oracle, Microsoft SQL Server)
  • Hands-on experience optimizing database performance and queries
  • Hands-on experience working with large data sets, ETL approaches and building systems that process large volumes of data
  • Experience with data modeling for warehouse, OLAP cubes, and transactional database systems
  • Experience with MS SQL-Sever, MS-SQL Server Analysis Services, and SQL/MDX query languages
  • Experience with BI reporting software is a plus (e.g. SSRS, Tableau, MicroStrategy, SAS)
  • Bachelor’s degree in Computer Science, Engineering, Information Systems, or relevant industry experience required

  • The ideal candidate will be intimately familiar with agile software development methodology, have software development and scripting experience, and be passionate about documentation and educating others.

    Job Snapshot

    Employment Type Full-Time
    Job Type Engineering, Information Technology
    Education 4 Year Degree
    Experience At least 3 year(s)
    Manages Others Not Specified
    Industry Computer Software, Internet - ECommerce
    Required Travel Not Specified
    Job ID 235
    CareerBuilder Tip:
    For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

    By applying to a job using you are agreeing to comply with and be subject to the Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

    Data Warehouse Engineer

    Enter notes about this job: