Database Engineer

Job Description

Key Skills and Responsibilities Snowflake Architecture: Deep understanding of Snowflake's architecture, components, and functionalities. Snowflake cost model: Understanding of how Snowflake cost model operates and ability to improve efficiency and track costs across the platform. Database Management: Expertise in creating, managing, and optimizing databases, schemas, tables, and views. Data Modeling: Knowledge of dimensional modeling (star and snowflake schemas) for data warehousing. Data Warehousing: Knowledge of data warehousing concepts, methodologies, and best practices. SQL: Proficiency in SQL for querying, manipulating, and analyzing data. Performance Optimization: Understanding of performance tuning techniques (clustering, materialized views, warehouse sizing) to improve query performance. Security: Expertise in implementing security measures (IAM, role-based access control, data encryption, password rotation processes) to protect sensitive data. ETL/ELT Tools: Familiarity with ETL/ELT tools (e.g., HVR, SnapLogic) for data loading and transformation. Cloud Computing: Understanding of cloud concepts (e.g., scalability, elasticity, resource management) and experience with cloud platforms (AWS, Azure). Scripting: Proficiency in scripting languages (e.g., Python, Bash) for automation and data processing tasks. Reporting platform: Experience in setting up Power BI workspaces and Cognos Packages with secure data models ready for reporting. Project Management: Knowledge of project management methodologies (e.g., Agile, Waterfall) and tools. Other Skills Problem-Solving: Ability to troubleshoot and resolve technical issues efficiently. Communication: Effective communication skills to interact with stakeholders and team members. Analytical Thinking: Ability to analyze data and identify patterns and trends. Attention to Detail: Meticulous approach to ensure data accuracy and integrity. Adaptability: Willingness to learn new technologies and adapt to changing requirements. Project Management: Ability to plan, execute, and monitor projects effectively. Leadership: Ability to lead and motivate project teams. Time Management: Effective time management skills to meet project deadlines. Adaptability: Flexibility to adapt to changing project requirements. Stakeholder Management: Ability to manage expectations and build relationships with stakeholders.