Job Description
We are seeking a Database Engineer SQL to become an integral part of our development team! You will design strategies for database systems as well as set standards for operations, programming and security.
- SQL Expertise: Develop and optimize SQL queries, stored procedures, and functions. Ensure the performance, integrity, and security of databases. Manage database access and implement best practices for SQL coding.
- Snowflake Proficiency: Design and implement data warehousing solutions using Snowflake. Understand Snowflake architecture and optimize data storage and retrieval. Manage Snowflake's features like data sharing, cloning, and time travel.
- ETL Processes: Design, build, and maintain ETL pipelines. Develop strategies for data acquisitions and integration. Ensure efficient data flow between systems and databases.
- SSAS and SSIS Implementation: Develop and maintain SSAS cubes for complex analytical reports. Use SSIS to extract, transform, and load data into data warehouses. Create and manage ETL processes with SSIS packages.
- Report Writing: Design and develop reports using various tools. Translate business requirements into technical specifications for reports. Ensure the accuracy and effectiveness of report data.
- Database Design and Maintenance: Design database schemas and tables. Monitor and optimize database performance. Implement disaster recovery strategies.
- Collaboration and Communication: Work closely with other IT professionals and business stakeholders. Communicate complex data concepts to non-technical team members. Participate in code reviews and share best practices with the team.
Recruiting Company