Lead Data Engineer (RDBMS, Snowflake)

Agama Solutions • Dallas, TX

4d

About The Position

We are seeking a Lead Data Engineer with expertise in RDBMS and Snowflake to join our team. The role involves designing, constructing, installing, testing, and maintaining highly scalable data management systems. You will be an integral part of an Agile scrum team, partnering with various stakeholders to conceptualize and design detailed solutions. This includes prioritizing features for ongoing sprints, managing data requirements based on industry trends and project needs, and communicating project progress. The ideal candidate will be adept at handling risks and issues affecting the project.

Requirements

• In-depth understanding of Snowflake (must)
• Experience with PostgreSQL
• Proficiency in Python
• Experience with Snap Logic
• Strong knowledge of and experience with databases
• Ability to write medium to high complexity SQL statements
• Experience with programming (ETL/ELT frameworks)
• Knowledge of Data Warehouse Architecture to build and articulate conceptual, logical, and physical dimensional data models, and Star Schema artifacts
• Understanding of data modeling techniques
• Working knowledge with OLTP and OLAP systems
• Hands-on experience working with Python
• Experience with data visualization tools like Power BI
• Bachelor's or master's degree in computer science, Information Systems, or related field
• 7+ years of relevant work experience
• Previous experience leading a team
• Excellent problem-solving and analytical skills
• Ability to be hands-on and work closely with all levels in the company

Nice To Haves

• Good understanding of shell scripts (bash/zsh, grep/sed/awk etc.)
• Familiarity with cloud platforms like AWS

Responsibilities

• Designing, constructing, installing, testing, and maintaining highly scalable data management systems
• Being part of an Agile scrum team and partnering with various stakeholders
• Conceptualizing and designing detailed solutions
• Prioritizing features for ongoing sprints and managing a list of data requirements based on industry trends, new technologies and project requirements
• Communicating project progress to stakeholders
• Handling risks and issues affecting the project

What This Job Offers

• Job Type: Full-time
• Career Level: Senior