Job Title: Database Engineer
Reports to: Director – Software Engineer
Career Path Classification: Non-Supervisory/Manager/Level 4
About Railbookers:
At Railbookers, we believe that the journey is just as fulfilling as the destination. Life onboard is full of opportunities, new experiences, and rewarding relationships.
We’re a team of diverse, talented people from around the world. As we continue to expand internationally, we strive to ensure that our culture remains alive and well -that we remain aligned and engaged. Global movements don’t spring from one individual. It takes an entire team to make an impact and do something BIG. At Railbookers, we encourage every employee to identify areas of opportunity within the organization.
Every single person at Railbookers has a passion for travel, which explains why we’re so avid about encouraging our customers to get out and discover the world for themselves. Most importantly, we embolden you to be yourself and enjoy the work you do on a daily basis. We like having a great time at work, not just outside of it.
Job Overview:
We're seeking a substantially experienced Database Engineer with a proven track record in Azure and Salesforce to join our team at Railbookers Group. The ideal candidate will be a highly skilled professional with a comprehensive understanding of wider department goals, cross-functional impacts, and the company's operational landscape. This role focuses on data curation, cleaning, structuring, and integrating data from various sources, including Salesforce, to support our rail travel booking services.
As the Database Engineer at Railbookers, you will be responsible for designing, implementing, and maintaining the company's complex database systems that support all aspects of the business. This critical role requires a deep understanding of database architecture, performance optimization, and data security. You will work on complex problems where analysis of situations or data requires in-depth evaluation and knowledge, with the ability to use creative concepts to resolve complex issues successfully towards company objectives.
Key Responsibilities:
- Database Design and Implementation:
- Design, maintain, and implement robust, scalable, and secure database solutions to support Railbookers' growing business needs.
- Create and optimize data models that capture the complexity of our business, including customer bookings, inventory, pricing, and financial information.
- Implement best practices for data normalization, indexing, and partitioning to optimize query performance.
- Data Engineering and Pipeline Development:
- Design, maintain, and implement data pipelines for efficient data collection and processing, including integrating data from Salesforce.
- Utilize Azure Data Factory, Azure Databricks, and other Azure services to build and maintain data solutions.
- Automate data pipeline processes to improve efficiency and reliability.
- Data Curation and Quality Assurance:
- Curate and clean data from multiple sources to ensure accuracy and consistency.
- Implement data governance policies and procedures to ensure data integrity, accessibility, and compliance with relevant regulations.
- Develop and manage data collection processes to ensure data is accurate, complete, and timely.
- Performance Optimization and Monitoring:
- Optimize database performance, ensure high availability, and implement effective backup and disaster recovery strategies.
- Analyze database logs and metrics to identify and resolve issues, improve overall system performance, and enhance user experience.
- Cross-functional Collaboration and Leadership:
- Build productive and stable working relationships with internal functional teams and relevant cross-functional stakeholders autonomously.
- Collaborate with cross-functional teams, including developers, business analysts, and subject matter experts, to understand and document data requirements.
- Model the RBG Values and Ways of Working, and coach, lead, and inspire more junior team members.
- Continuous Learning and Innovation:
- Stay up to date with the latest database technologies, best practices, and industry trends.
- Actively seek diverse perspectives for continuous learning, feedback, and growth.
- Conduct retrospectives for improvement and share insights for broader functional enhancements.