Sr.Data Engineer

Role Responsibility

• Design, develop, and maintain scalable data pipelines and analytics solutions using DBT, Snowflake, and related
• technologies
• Collaborate with stakeholders to gather requirements and translate business needs into technical solutions
• Develop efficient code with unit testing and code documentation
• Ensuring accuracy and integrity of data and applications through analysis, coding, documenting, testing, and problem
• solving
• Optimize and fine-tune data models, SQL queries, and transformations for performance and scalability
• Design, develop, and maintain scalable data models and transformations using DBT in conjunction with Snowflake,
• ensure the effective transformation and load data from diverse sources into data warehouse or data lake.
• Integrate FiveTran connectors to streamline data ingestion from various sources into Snowflake
• Develop custom Python scripts and functions to automate data workflows and enhance system capabilities
• Provide technical expertise and support to resolve data-related issues and troubleshoot system failures
• Collaborate with the API development team to integrate data pipelines with external systems and applications
• Contribute to the development of web-based data visualization solutions and dashboards
• Communicate with all the project stakeholders on the project status
• Manage, monitor, and ensure the security and privacy of data to satisfy business needs
• Contribute to the automation of modules, wherever required
• Stay updated on emerging trends and technologies in data engineering, cloud computing, and analytics domains

EXPERTISE AND QUALIFICATIONS

Role Requirements:

• Bachelor's degree in Computer Science, Engineering, or a related field
• Proven experience of at least 5 years as a data engineer, ETL developer, or similar role, with a focus on DBT and Snowflake
• Strong proficiency in SQL and database concepts, with hands-on experience in Snowflake data warehouse

Subject Matter expert of Data warehouse and Data Lake concepts (Dimensional Modelling, change data capture, slowly

changing dimensions etc.)

• Proficiency in programming languages such as Python for data manipulation, automation, and scripting
• Knowledgeable in relational databases, nonrelational databases, data pipelines (ELT/ETL), and file stores
• Knowledgeable in performance tuning and optimization
• Experience with cloud platforms like Azure and tools like Azure OCR for data extraction and processing
• Familiarity with data integration tools like FiveTran
• Knowledge of API development principles and experience integrating data pipelines with external systems
• Proficient in written, verbal and presentation communication (English)
• Ability to work effectively in a fast-paced, collaborative environment and manage multiple priorities
• Excellent analytical, problem-solving, and communication skills