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 Purpose and Overview:
We're seeking a skilled Data Engineer with experience in Azure and Salesforce to join our team at Railbookers Group. The ideal candidate will focus on data curation, cleaning, structuring, and integrating data from various sources including Salesforce to support our rail travel booking services.
As the Data 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, from customer bookings and inventory management to financial reporting and business intelligence. This is a critical role that will require a deep understanding of database architecture, performance optimization, and data security.
- Design, maintain, and implement data pipelines for efficient data collection and processing, including integrating data from Salesforce.
- Curate and clean data from multiple sources to ensure accuracy and consistency.
- Utilize Azure Data Factory, Azure Databricks, and other Azure services to build and maintain data solutions.
- Develop and maintain optimal data structure and architecture.
- Collaborate with cross-functional teams to understand data needs and requirements, specifically related to Salesforce data.
- Implement data quality checks and validation processes.
- Optimize data storage and retrieval systems for improved performance.
Key Responsibilities and Duties:
- Design, maintain and implement robust, scalable, and secure database solutions to support Railbookers' growing business needs.
- Optimize database performance, ensure high availability, and implement effective backup and disaster recovery strategies.
- Develop and maintain database-driven applications and web services that integrate with the company's various systems and platforms.
- Collaborate with cross-functional teams, including developers, business analysts, and subject matter experts, to understand and document data requirements.
- Implement data governance policies and procedures to ensure data integrity, accessibility, and compliance with relevant regulations.
- Analyze database logs and metrics to identify and resolve issues, improve overall system performance, and enhance user experience.
- Stay up to date with the latest database technologies, best practices, and industry trends, and recommend improvements to the company's data infrastructure.
- Provide technical support and training to other team members who interact with the database systems.
- Contribute to the development and implementation of the company's data strategy and roadmap.
Data Curation:
- Develop and manage data collection processes to ensure data is accurate, complete, and timely.
- Implement data governance and quality assurance practices.
- Collaborate with business stakeholders to understand data needs and curate datasets accordingly.
Data Cleaning:
- Identify and rectify data inconsistencies, errors, and gaps.
- Develop automated data cleaning processes to ensure ongoing data integrity.
- Implement data validation and monitoring tools to detect and address data quality issues in real-time.
Data Structuring:
- Design and implement efficient data models and schemas.
- Build and optimize data storage solutions, including databases and data lakes.
- Ensure data structures are scalable and support the needs of data analytics and reporting.
Pipeline Development:
- Automate data pipeline processes to improve efficiency and reliability.
- Monitor and troubleshoot data pipelines to ensure continuous data flow.
Collaboration:
- Work closely with data analysts and business stakeholders to understand data requirements and deliver solutions.
- Provide technical guidance and support to team members and stakeholders.
Database Design and Implementation:
- Design and develop scalable, high-performance database architectures to support the company's growing data needs.
- Create robust data models that capture the complexity of Railbookers' business, including customer bookings, inventory, pricing, and financial information.
- Implement best practices for data normalization, indexing, and partitioning to optimize query performance.
- Integrate the database systems with various business applications, APIs, and reporting tools.
Database Optimization:
- Monitor database performance, identify bottlenecks, and implement optimization strategies to ensure high availability and responsiveness.
- Automate and streamline database maintenance tasks, such as backups, recovery, and index maintenance.
- Implement effective security measures, including access controls, encryption, and data masking.
- Continuously analyze database metrics and logs to proactively identify and resolve issues.
Data Governance and Reporting:
- Develop and enforce data governance policies to ensure data accuracy, integrity, and compliance with relevant regulations.
- Collaborate with business stakeholders to understand reporting and analytics requirements, and design and develop custom data views and dashboards.
- Provide technical support and training to data consumers, enabling them to effectively utilize the company's data assets.
Database Modernization:
- Optimize the cloud-based database architecture to take advantage of scalability, elasticity, and advanced features.
