Solution Architect
Snowflake
CloudETLPythonSQL
AI Data Engineer
Zendesk
full-time
Posted on:
Location Type: Hybrid
Location: Dublin • 🇮🇪 Ireland
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
CloudETLPythonSQL
About the role
- Collaborate with team members to define requirements and translate them into scalable data models and pipelines.
- Develop and maintain ELT pipelines, ensuring data reliability and scalability for business reporting and analytics use cases.
- Build and optimize SQL-based data models using dbt and other ETL tools.
- Identify and implement improvements in data delivery, processing performance, and system efficiency.
- Contribute to the team’s technical vision and bring innovative solutions to enhance data systems.
- Work closely with engineering and analytics teams to enhance Zendesk’s CRM and customer support tools.
Requirements
- 3+ years of data engineering experience building, maintaining and working with data pipelines & ETL processes in big data environments.
- Extensive experience with SQL, ideally in the context of data modeling and analysis.
- Hands-on production experience with dbt.
- Proven knowledge in modern and classic Data Modeling - Kimball, Inmon, etc.
- Programming skills in Python or a similar language, with an emphasis on data transformation and automation.
- Experience with cloud columnar databases - primarily with Snowflake, query authoring (SQL) as well as working familiarity with a variety of databases.
- Proven experience in performance testing, capacity planning, and cost optimization for large-scale, complex data pipelines and systems.
- Excellent communication and collaboration skills.
- SnowPro Core certification or equivalent hands-on expertise (preferred).
- Familiarity with Lean/6 Sigma principles and an understanding of CRM analytics (preferred).
Benefits
- Hybrid way of working with local office attendance required part of the week; flexibility to work remotely for part of the week.
- Offices in global cities with spaces for collaboration, quiet, and events.
- Opportunity to grow your skills in a dynamic environment.
- Inclusive experience and global diversity, equity, & inclusion efforts.
- Reasonable accommodations for applicants with disabilities and disabled veterans.
ATS Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data engineeringdata pipelinesETL processesSQLdbtdata modelingPythoncloud columnar databasesSnowflakeperformance testing
Soft skills
communicationcollaboration
Certifications
SnowPro Core certification
