Job Summary: We are seeking a highly skilled Senior Lead Engineer with extensive experience in data analysis, architecture, and strategy. The ideal candidate will have a strong background in designing databases, data warehouses, and data products, with a proven ability to lead teams and communicate effectively with both technical and non-technical stakeholders. This role requires a deep understanding of Snowflake and other data technologies to optimize performance and ensure best practices are followed.

Responsibilities:

- Provide technical and architectural guidance to the team, enforcing processes and best practices.

- Optimize database queries and indexing strategies to enhance performance across various platforms.

- Communicate complex design concepts to a diverse audience, including technical teams and non-technical stakeholders.

- Collaborate with cross-functional teams to develop data strategies that support organizational objectives.

- Mentor and train team members on data technologies and architectural principles.

Mandatory Skills:

- Expertise in Snowflake as a primary data warehousing solution.

- Proficient in Azure Data Factory (ADF) for data integration and workflow management.

- Strong SQL skills with experience in SQL Server (T-SQL) and Mysql.

- Experience in performance optimization of database queries and indexing.

- Excellent communication skills, with the ability to convey technical information to a broader audience.

Preferred Skills:

- Experience with SSIS or Pentaho for ETL processes.

- Familiarity with data visualization tools such as Power BI or Tableau.

- Knowledge of Python for data manipulation and analysis.

Qualifications:

- Bachelor's degree in Computer Science, Information Technology, or a related field.

- 8-10 years of experience in data architecture, data analysis, and database design.

- Proven leadership experience in managing technical teams and projects.

- Strong problem-solving skills and attention to detail.