Data Warehouse/Business Intelligence (DW/BI) Lead Engineer
Unique opportunity with a mobile marketing leader
We are currently seeking an experienced Data Warehouse/Business Intelligence Lead Engineer who will be responsible for driving DW/BI innovation across all aspects of our enterprise data warehouse and analytics platform. In this hands-on role, you will collaborate with our engineering, product and analytics teams to maintain, enhance and automate our data warehousing and analytics systems. You will lead DW/BI team’s efforts to determine data engineering and reporting needs and assume ownership for end-to-end delivery of enterprise data warehouse and business intelligence projects.
Our environment is innovative, intellectually challenging and fast-paced. Advanced architectural, development and programming skills, a collaborative work ethic, strong analytical skills and a drive to succeed are the best fit. This position is located at our office in downtown Chicago at 300 W. Adams.
Responsibilities:
- Lead development of architectural standards and frameworks for data warehouses considering performance, efficiency, data integrity, scalability and maintainability
- Develop expertise in mobile marketing and Vibes’ proprietary data sets and lead data engineering and modeling efforts to enable insights using agile SDLC practices
- Design and implement high-performance, resilient, secure and scalable dimensional models, data pipelines and reporting interfaces
- Provide strong domain-based experience with toolsets and methods to help get the most from current and next-generation data technologies and industry best practices
- Perform effort estimation for various data warehouse activities and effectively drive data projects to completion
- Develop rapid prototypes and proofs of concept to help assess strategic opportunities and future BI capabilities
- Lead the effort to build an efficient multi-tenant self-service BI platform
Requirements & Qualifications:
- Bachelor's or master’s degree in Computer Science or related discipline or equivalent work experience
- 7+ years relevant experience designing and delivering DW/BI and analytics solutions
- Expert level knowledge in designing entire data warehousing/business intelligence architecture end-to-end; including data integration architecture, database schema designs, dimensional data modeling, query performance optimization and reporting/visualization
- Experience writing complex SQL queries and stored procedures with fluency in one or more programming languages such as Java or Python
- Awareness of continuous integration and automated testing for data warehouse processes
- Expert level knowledge in tuning and scaling data management and engineering processes in a high-volume data warehouse environment
- Expert level knowledge in ETL frameworks and best practices
- Experience in running large-scale data warehouses on big data technologies such as Amazon Redshift, PostgreSQL clusters or Snowflake using Pentaho/Talend is a plus
- Good communication and documentation skills
- Client service attitude with ability to persuade and educate when appropriate
- Ability to multitask and prioritize work
- Ability to adapt to changing environments, tools and technologies
Our Core Values:
- Respect, Honesty, and Integrity for All Stakeholders
- Always be Learning
- Relentless Focus on the Customer
- Never be Satisfied
- Create Value
- Seek Accountability and Ownership
Vibes is an equal opportunity employer that encourages and fosters diversity in the workplace. We offer a career building experience in a fast paced organization and industry.