Senior Data Engineer (ELT, BI)

What you’ll do:

• Develop robust and scalable data models that support analytics, data science, reporting and other data workflows. Ensure data models adhere to best practices for maintainability, performance, and security.
• Design, build and maintain the semantic layer in our cloud-native warehouse that enables self-service analytics and data democratization. Create reusable, business-friendly data abstractions that empower stakeholders across the organization.
• Identify opportunities to leverage new data technologies and methodologies. Collaborate with cross-functional teams to prototype, test, and implement innovative data solutions that enhance data quality, accessibility, and usability.
• Design, implement, and maintain automated orchestration of our data workflows that support transformation across several layers in our warehouse, ensuring data integrity and data availability while optimizing for performance at scale.
• Partner closely with data analysts, data scientists, and other stakeholders to understand business requirements, translate them into engineering specifications, and deliver high-quality data products.
• Implement data governance standards and best practices to ensure data is accurate, consistent, and secure. Support compliance with relevant data privacy and security regulations.

What We Seek:

• Extensive data modeling experience working with cloud-based data warehousing solutions at scale, particularly Snowflake. Knowledge of data architecture, different data modeling approaches, performance optimization, and cost management.
• Deep expertise in writing and optimizing complex SQL queries, including performance tuning, clustering strategies, and troubleshooting.
• Expertise in creating and maintaining scalable and efficient data models using tools like dbt. Experience in developing star and snowflake schemas, as well as implementing best practices for data modeling and transformation.
• Strong experience in building, maintaining, and optimizing ETL/ELT pipelines using tools like dbt, Airflow, Matillion, or similar. Familiarity with data orchestration, data quality monitoring, automation and SLAs.
• Proficiency in at least one programming language such as Python or Java for data manipulation, automation, and pipeline development.
• Hands-on experience with cloud platforms such as AWS, Azure, or GCP, particularly with services like S3, Lambda, Glue, and other data-related services.
• Experience with data visualization, data front end and BI tools such as Tableau, Looker, or Streamlit to build and support the semantic layer and self-service analytics.
• Familiarity with CI/CD and version control systems like Git to automate deployment and testing of data models and pipelines.
• Understanding of data governance principles, data privacy regulations, and security best practices. Experience implementing role-based access controls and encryption strategies in data environments.
• Experience working in Agile environments and collaborating with cross-functional teams using tools like JIRA or Confluence.

Why join us:

• Ability to work remotely from anywhere in the world
• Close cooperation with the development team and client
• Opportunity to influence product development
• Professional growth: the certification preparation course is free for our specialists. The company pays for two attempts to pass the exam, regardless of the exam result
• We cover English classes (with a native speaker)
• Boost professional brand: you can participate in local conferences as a listener or as a speaker
• Regular team buildings: have fun with teammates
• Gifts for significant life events (marriage, childbirth)
• Tech and non-tech Zazmic Communities: support and share experience with each other