Restaurant365
Irvine, CA
201-500 employees
R365's cloud-based restaurant management software helps leaders master accounting, operations, & workforce to create incredible moments that drive profits.
Data Warehouse Engineer I
Data Warehouse Engineer I
This job is no longer open
Restaurant365 is a SaaS company disrupting the restaurant industry! Our cloud-based platform provides a unique, centralized solution for accounting and back-office operations for restaurants. Restaurant365’s culture is focused on empowering team members to produce top-notch results while elevating their skills. We’re constantly evolving and improving to make sure we are and always will be “Best in Class” ... and we want that for you too!
*Please note, this position can be based in Irvine, CA, Austin, TX, or remote
Will be responsible for all aspects of design development and delivery of database solutions. Will develop and maintain high database development standards, do peer review, and maintain high code quality. Will collaborate with other team member and lend support to business/technology teams as necessary during SDLC process to ensure robust and scalable solution.
How you'll add value:
- Proficient knowledge of database technologies
- Work closely with Data warehouse, report development and architecture team/s
- Design, build, test, and maintain data structures such as data marts, Data warehouse, cubes, and data pipelines in Azure.
- Design, build, test, and maintain data pipeline and ELT/ETL process for structured, and semi-structured data.
- Implement MS SQL best practices involved with OLTP and Data warehouse environments.
- Recommend ways to improve overall performance, reliability, and quality of ELT/ETL process.
- Optimize database performance using DMVs, execution plan, SQL profiler and other SQL monitoring and debugging tools.
- Research opportunities for data acquisition and new uses for existing data
- Remain current with development in data architecture, data analytics, and data science industry
- Logical and detail-oriented approach to work
- Keeps a strong client focus in executing all functions of the job
- Communicates effectively and responds to internal emails and inquiries within reasonable timeframes
- Is a team-player in his or her department and the Company as a whole
- Behaves respectfully to others in the workplace
- o Design and develop DW practice to support time variant historical reporting of transactional and business critical data
- o Design and develop fault tolerant near real-time data pipeline
- o Design and develop DataMart’s and Cube
- o Develop and maintain high database development standards
- o Work with business/technology teams to support database development
Data warehouse and BI
Database development
What you'll need to be successful in this role:
- CS Degree or related experience
- Data warehouse experience using Microsoft SQL server
- Tools and technologies: SSAS, SSRS, SSIS
- PowerShell
- GitHub
- Bamboo
- Azure SQL
- Detail-oriented, strong organizational skills
R365 Team Member Benefits & Perks
- Competitive compensation package
- Salaried position: $100K-$160K
- Ability to work remote or hybrid
- Comprehensive medical benefits
- 401k + matching
- Equity Option Grant
- Unlimited PTO + Company holidays
- Wellness initiatives
- Philanthropy events
Why join our amazing team?
- We're a community that prides itself in creating innovative solutions and producing quality work
- Our product is the secret ingredient that makes a real difference to restaurants nationwide
- The open concept work environment that we've created is causal, collaborative, and cultivates communication
#BI-Remote
R365 is an Equal Opportunity Employer and we encourage all forward-thinkers who embrace change and possess a positive attitude to apply.
This job is no longer open