Data Analytics Engineer

• Data Warehouse Development : Design and develop scalable, secure, and compliant data warehouses using Snowflake and dbt technologies. This includes creating Snowflake data models and performing transformations in dbt.
• Analytical Skills : Exhibit strong problem-solving abilities and attention to detail. Analyse and organize raw data and generate reports using Power BI.
• SQL Expertise : Demonstrate proficiency in SQL, including writing complex queries and optimizing SQL performance in Snowflake and dbt.
• ETL/ELT Processes : Familiarity with Snowflake s ETL/ELT tools and techniques, as we'll as dbt s transformation methods.
• Data Modeling : Possess a solid understanding of data modeling concepts and be adept with Snowflake s and dbt s data modeling tools and techniques.
• Performance Optimization : Optimize the performance of Snowflake and dbt queries and data loading processes. This includes optimizing SQL queries, creating indexes, tuning data loading processes, and automating manual tasks.
• Security and Access Management : Manage the security and access controls of the Snowflake environment, including configuring user roles and permissions, managing encryption keys, and monitoring access logs.
• Database Maintenance : Maintain existing databases and warehouse solutions, addressing support needs, enhancements, and troubleshooting.
• Collaboration : Work closely with data scientists, analysts, and other stakeholders to understand and meet data requirements.
• Documentation and Reporting : Document data processes and pipeline architecture using dbt.
• Training and Support : Provide training and support to team members on the usage of dbt and Snowflake.

Specific Skills:

• Transform raw data into structured formats using dbt.
• Implement data quality checks and testing within dbt to ensure accuracy and consistency.
• Maintain data accuracy and consistency throughout the pipeline.
• Document data models, transformations, and processes comprehensively.
• Optimize dbt models and transformations for maximum efficiency.
• Manage dbt projects using version control systems like Git.

Technical Skills:

• Extensive proficiency in Snowflake, dbt, and Power BI.
• Experience with cloud services such as AWS and Azure.
• Proficient in programming languages including SQL, Python, and Java.

• Preferred Experience : Experience as a data engineer in the engineering or IT industry is advantageous.
• Educational Background : Bachelor s degree in computer science, Information Technology, or a related field.
• Professional Experience : 6-8 years of overall experience in data engineering. and relating to others.