Data Warehouse Architect - Virtual - open to any location in US

The Senior Data Warehouse Engineer will help architect, build, and maintain a robust, scalable, and sustainable business intelligence platform. Surrounded by a diverse group of fun and dedicated individuals, this role will tackle highly scalable systems with complex data models, heterogeneous ETL technologies, and large volumes of internet log and transactional data. This is a highly visible and strategic role as our business decisions are driven by data. As we grow, it will become even more important that we have the right data to make the right decisions. As the Sr. Data Warehouse Engineer, you are responsible for analysis, design, requirements gathering, functional/technical specification, development, deployment, and testing work related to the data warehouse. Essential Responsibilities • Design, develop, and maintain highly scalable ETL & Data Warehousing-related systems that use a variety of technologies to aggregate data from across various external entities and from within the business. • Engineer data warehousing solutions through the use of multiple technologies including: DBMS (Oracle, SQL Server, MySQL), App Dev (Java, Ruby, C++ etc), ETL tools (Informatica, Ab Initio, SSIS), OS (Solaris, HP-UX, Windows, Linux), scripting (Shell, Python, Perl).

• Integrate third party data into our enterprise data warehouse. Create and maintain the logical and physical dimensional data model. • Provide data streams from front-end/third-party systems to drive real-time business metrics and decisions • Invest time and effort to constantly learn latest technologies related to BI and big data applications. • Document business requirements, design specifications, and ETL operational manuals. • Join forces with analysts and stakeholders to gather, understand, and develop technical requirements • Recommend standards and methodology for creation, capture, maintenance, and integration of metadata • Provide expertise and leadership on making technical decisions, thus delivering a platform that provides business value and meets end user goals • Be flexible, adaptable, and available for full production support during off-business hours on a regular basis.