What are the responsibilities and job description for the Database Analyst position at Revenue Management Solutions?
The Opportunity
As a Database Analyst, you will play a critical role in managing and optimizing data processes for our team and clients, including half of the top 30 global restaurant brands, representing over 100,000 restaurant locations worldwide. You’ll be part of a tech-driven culture, leveraging the latest cloud-based technologies like Azure to support data integration, automation, and process improvements.
You will work within our DevOps team, which develops and supports software solutions that enable restaurant and hospitality brands to maximize the value of their data. Your primary focus will be gathering, importing, cleansing, and analyzing client data while ensuring seamless data ingestion and integration. You will also collaborate with cross-functional teams to automate workflows and enhance system performance.
You will be assigned to a specialized focus area—Data Management, New Development, or Automation—allowing you to develop expertise in a specific domain and contribute meaningfully to our data-driven solutions.
Who You’ll Work With
You will be based in our Tampa office, working in the DevOps Data Integration team and reporting to a Team Lead. Our Data Integration team is dedicated to enhancing the client experience by improving data processes and ensuring seamless integration with our software solutions.
Collaboration is key in this role. You will work closely with our consulting team on data projects, guiding clients through onboarding and ongoing assignments. Additionally, you may engage with teams from Software Development, Product Management, and Research & Development to automate data workflows in a hybrid-cloud environment.
At RMS, we take pride in fostering career growth and supporting professional development, offering opportunities to expand your expertise and skills.
What You’ll Do
- Monitor and manage automated processes to ensure seamless execution and promptly address any issues.
- Develop and analyze reports to verify data accuracy and detect anomalies.
- Troubleshoot IS Catalog - Level 1 system errors, researching issues, recommending solutions, escalating as needed, and executing jobs manually when necessary.
- Investigate and resolve data issues, ensuring consistency and integrity across platforms.
- Become an expert in assigned processes, providing insights and recommendations for optimization.
- Identify and implement process improvements to enhance efficiency and automation.
- Design and develop ETL/ELT solutions (e.g., ADF, SSIS) following best practices in database design and data pipeline management.
- Analyze complex data sources to determine optimal transformation and loading methods.
- Maintain compliance with coding standards and development best practices.
- Document workflows, data structures, and business rules for clarity and consistency.
- Support system enhancements, including application upgrades and process optimizations.
- Assist with client onboarding, managing setup, configuration, and data integration.
- Collaborate across teams, working with consultants, analysts, and developers to streamline data workflows and resolve issues.
Skills and Qualifications
- Strong analytical and problem-solving skills, with a keen eye for data accuracy and integrity.
- A solid sense of ownership and accountability for delivering high-quality results on time
- Self-motivated with the ability to work independently and as part of a team
- Experience with Microsoft SQL Server, T-SQL, SSIS, or equivalent ETL tools
- Familiarity with Microsoft Office 365 applications
- Strong written and verbal communication skills with both technical and non-technical teams
- Ability to meet deadlines and manage multiple tasks with shifting priorities
- Commitment to continuous learning and expanding your knowledge base
Preferred
- Bachelor’s degree in Computer Science, Information Systems or related field
- Previous experience in hospitality or retail
- Experience with data automation, ETL processes, or business intelligence tools (e.g., Power BI, Tableau) is a plus.
- Experience with Microsoft Azure PaaS, Azure Data Factory
Benefits
As a full-time RMS employee, you will receive:
- 100% employer-paid HSA medical insurance or 80% employer-paid medical insurance for HMO and PPO plans for you and qualifying dependents
- Dental and vision insurance (80% employer-paid)
- Basic Life and AD&D insurance (100% employer-paid)
- Telemedicine (100% employer paid)
- 401k plan with company matching contribution of 4% of annual gross salary with immediate vesting
- 15 business days paid vacation for the first year based on your hire date (pro rata),; 20 days after two years, and 25 days after ten years. Vacation days accrue on a semi-monthly basis.
- 8 paid holidays 1 personal floating holiday
- Gym membership or ClassPass (optional)
- Access to optional group insurance plans (100% employee paid): Accident, Critical Illness, Hospital, Voluntary Life and AD&D, Long-term Disability, Short-term Disability, and Pet Insurance
Who We Are
Revenue Management Solutions (RMS) is committed to supporting restaurants through these ever-changing times. Today, more than 50 major brands in 40-plus countries trust RMS and rely on its data-driven analytics and tech-enabled solutions to optimize sales, menus and a brand’s financial health. RMS provides actionable insights to more than 100,000 restaurant locations worldwide to help them make informed business decisions that drive profitability and combat inflation and increasing wages. The company holds five US patents on menu pricing and customer segmentation and supports ongoing academic research efforts. For more information on how RMS helps its clients, visit revenuemanage.com.
What We Believe
Our goal at RMS is to create a positive change in the communities we inhabit. With over 20 countries represented throughout our offices, we respect and embrace different cultures, interests, and actions. The acknowledgment of our unique identities is something that connects us across continents to uphold our values of diversity, respect, and responsibility.
Revenue Management Solutions LLC. is an equal opportunity employer and an E-verify participant. RMS considers qualified applicants without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability status or any other legally protected characteristic.
