Design, build and maintain Zero-ETL scalable data pipelines and Redshift data models. Develop and manage Airflow workflows, integrate multiple data sources, ensure data quality and availability, optimize queries and warehouse performance, monitor and resolve platform issues, document pipelines and collaborate with analysts and stakeholders on architecture and analytics needs.
About the role
We are looking for a Senior Data Engineer to design, build and maintain our data analytics platform. You will be responsible for developing scalable data pipelines with Zero-ETL approach, ensuring high-quality and reliable data and enabling analytics across the organisation. You will work closely with Data Analysts and business stakeholders to deliver robust data solutions while driving improvements in architecture, performance and operational excellence.
What you'll be doing
- Design, develop and maintain scalable Zero-ETL pipeline.
- Build, optimise and maintain data models in Amazon Redshift.
- Develop and manage workflow orchestration using Apache Airflow.
- Integrate data from multiple internal and external data sources.
- Ensure data quality, reliability, consistency and availability across the platform.
- Monitor, troubleshoot and resolve data platform issues from identification through root cause analysis and resolution.
- Optimise SQL queries, data processing jobs and warehouse performance.
- Design data models that support reporting and analytical use cases.
- Collaborate with Data Analysts to deliver reliable datasets for reporting and business intelligence.
- Improve data architecture, automation, monitoring and engineering best practices.
- Maintain documentation for pipelines, data models and platform architecture.
- Participate in technical planning, architecture discussions and code reviews.
What you'll bring
- 5+ years of experience as a Data Engineer.
- Strong expertise in SQL and relational databases.
- Hands-on experience with AWS data services, including Amazon Redshift and Amazon RDS.
- Experience developing and maintaining Apache Airflow workflows.
- Strong understanding of ETL design and implementation.
- Experience designing scalable data warehouse solutions and data models.
- Ability to independently investigate and resolve complex production issues.
- Excellent communication and stakeholder management skills.
- Proactive mindset with strong ownership and accountability.
- Experience working in Agile software development environments.
What's in it for you
- Sporty is a remote first company in pursuit of sustainability
- A competitive salary + individual performance based bonuses every quarter
- 28 days paid annual leave
- Our core working hours are 10am-3pm in your local time zone with flexibility outside of this
- Referral bonuses & flash bonuses
- Top of the line equipment
- Annual company retreats to provide great internal networking opportunities
If you're interested, we encourage you to apply! Every application is reviewed by a member of our team (AI is not used in our recruitment process), and we aim to respond within 48 hours.
Similar Jobs
Blockchain • Analytics
Design, build, and scale high-performance data pipelines and infrastructure (ingestion, transformation, storage, modeling, serving) using ClickHouse, Postgres, Python and dbt. Manage data quality, reliability, and observability at terabyte and 500M+ address scale, collaborate with researchers and product, mentor engineers, and leverage AI tools to accelerate work.
Top Skills:
Ai Tools And AgentsClaude CodeClickhouseCursorDbtMcpsPostgresPythonSQLStreaming Data ArchitecturesWeb3
Gaming
Own and evolve the core data platform: warehouse design, dbt transformations, and production AWS pipelines. Refactor and harden API-driven data flows, ensure observability and testing, partner with backend and product teams, and contribute to data-aware backend features to deliver reliable, product-focused data.
Top Skills:
AWSBigQueryDatabricksDbtPythonRedshiftSnowflakeSQL
Fintech • Software • Analytics • Financial Services
Lead design and ownership of a cloud-native data platform: build scalable batch ETL and ingestion pipelines, develop analytical models (Athena/Redshift/ClickHouse), integrate data workflows with microservices on ECS, ensure data quality/observability, performance tuning, implement IaC and CI/CD, and mentor engineers.
Top Skills:
Amazon AthenaAmazon EcsAmazon Kinesis FirehoseAmazon RedshiftAmazon S3Aws AppflowAws DmsAws GlueAws LambdaAws Step FunctionsCi/CdClickhouseCloudFormationEventbridgeJavaKinesisPythonSparkSQLSqsTerraform
What you need to know about the Dublin Tech Scene
From Bono and Oscar Wilde to today's tech leaders, Dublin has always attracted trailblazers, with more than 70,000 people working in the city's expanding digital sector. Continuing its legacy of drawing pioneers, the city is advancing rapidly. Ireland is now ranked as one of the top tech clusters in the region and the number one destination for digital companies, with the highest hiring intention of any region across all sectors.
