Unique opportunity with a mobile marketing leader
We help marketers unlock new revenue by arming them with the technology and expertise they need to succeed in mobile marketing. Vibes Mobile Engagement Platform enables marketers to easily manage all mobile communication channels including text messaging, push notifications, Apple Wallet, Android Pay and mobile web campaigns — all through a single interface. Vibes has delivered more than five billion mobile experiences on behalf of customers that include Chipotle, Gap, Old Navy, Home Depot, Pet Smart, Foot Locker and Allstate, and is recognized as one of only four Tier 1 aggregators by the Common Short Code Administration (CSCA). To learn more about Vibes, visit www.vibes.com.
We are currently seeking an experienced Data Warehouse/Business Intelligence Engineer who will work with our analytics team on developing and maintaining our enterprise data warehouse, ETL and analytics tools. In addition, you will play a key role in designing and developing Vibes’ next-generation EDW and analytics platform.
In this role, you will collaborate with analysts, product managers, and key business contacts. Our environment is innovative, intellectually challenging, and fast-paced. Advanced 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:
- Gather, analyze and validate business requirements from non-technical functional users and subject matter experts and transform them into system requirements and technical specifications
- Design and implement data integration, database schema and dimensional data modeling components to support business requirements
- EDW performance tuning and optimization
- Design and build optimal ETL processes and frameworks considering best practices around efficiency, data integrity, scalability and maintainability
- Demonstrate good judgment in selecting methods and techniques for obtaining solutions
- Perform effort estimation for various Data Warehouse activities
- Develop rapid prototypes and proofs of concept to help assess strategic opportunities and future BI capabilities
- Production support of EDW/Analytics platforms
Requirements & Qualifications:
- Bachelor's degree in Computer Science or related discipline or equivalent work experience
- 4+ years IT experience
- 3+ years Data Warehouse / Business Intelligence experience
- Strong data engineering background with prior experience in Microsoft SQLServer datawarehouse environment
- Good knowledge of dimensional data modeling, query performance turning & optimization
- Strong problem solving/analytical skills
- Excellent knowledge of relational database technologies
- Experience writing complex SQL queries and stored procedures with fluency in one or more programming languages such as Java, Python or Perl
- Awareness of testing process within Data Warehouse implementation methodologies
- Hands-on knowledge of scripting languages (Python, Perl, Shell scripts) on Unix Platforms
- Effective team player with minimal supervision and effectively meet project deadlines in an agile environment
Preferred Qualifications:
- Experience with big data ecosystem like Snowflake, Redshift or Azure SQL Data Warehouse a huge plus
- Familiarity with reporting products such as MicroStrategy, Tableau, SSRS/SSAS or PowerBI
- Prior experience with distributed data warehouse platforms
- Prior experience with ETL tools/frameworks
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.
Please click 'Apply Now' down below to apply to this position.