Ruby Developer (Data Engineering)

Ruby Developer (Data Engineering) - ClubReady

As a Ruby Developer on our Data Engineering team at ClubReady, you'll be responsible for supporting, maintaining, and enhancing the Ruby-based ETL processes and data pipelines that power our customers' access to their ClubReady data. You'll leverage your deep SQL expertise and Ruby programming skills to ensure data replication processes are reliable, performant, and scalable. You'll collaborate closely with BI developers, DevOps, and Product teams to troubleshoot data syncs, optimize database operations, and implement enhancements to our existing data infrastructure.

Key Responsibilities

• Maintain and enhance existing Ruby-based ETL processes that replicate and transform ClubReady data into customer-facing databases.
• Write and optimize complex SQL queries across SQL Server and PostgreSQL environments for data extraction, transformation, and loading.
• Monitor and troubleshoot daily data loads, ensuring reliability and data consistency.
• Perform database performance optimization including query tuning, indexing strategies, and schema improvements.
• Collaborate with BI and Product teams to implement data set enhancements and support analytics use cases.
• Automate operational processes such as monitoring, alerting, and health checks for data syncs using Ruby scripts.
• Ensure data security and compliance in all data handling and transfer processes.
• Contribute to code documentation, pipeline design standards, and best practices.

Required Qualifications:

• 5+ years of professional Ruby development experience.
• Expert-level SQL knowledge with proven experience in SQL Server and PostgreSQL.
• Strong experience with data pipelines, ETL processes, and data transformation workflows.
• Deep understanding of database performance tuning, indexing, query optimization, and execution plans.
• Experience with data modeling, change data capture (CDC), and incremental load strategies.
• Familiarity with cloud environments (AWS or Azure).
• Strong debugging and troubleshooting skills for production data systems.

Preferred:

• Experience with data replication systems or synchronization frameworks between operational and analytics databases.
• Experience with additional languages such as Go or Python.
• Familiarity with workflow orchestration tools like Airflow or similar.
• Experience with Snowflake or other cloud data warehouses.
• Experience supporting multi-tenant or customer-facing data platforms.
• Exposure to BI tools such as Looker, Power BI, or Tableau.