Role: Snowflake Architect/Developer
Location: Dallas, TX(Day 1 onsite)
Rate: $65-70/hr on C2C
Go with 12+ years of experience
Primary skills should be:
1) Proficient in Snowflake design and implementation
2) Dimensional Data Models ( Snowflake schema/ star schema)
3)Data Warehouse concepts
4) Able to write complex SQL queries/ statements
5) Experience in Postgres SQL
6) Familiarity with cloud platforms like AWS.
Key Responsibilities:
- Designing, constructing, installing, testing, and maintaining highly scalable data management systems
- Familiarity with the Agile development methodology and to be part of Agile scrum team and partner with various stake holders.
- Responsible for conceptualizing and designing detailed solutions.
- Works with product team to prioritize 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 and capable of handling risks and issues affecting the project.
SKILLS REQUIRED:
- RDBMS: In-depth understanding of Snowflake. (must), PostgreSQL.
- Programming Languages: Python.
- ETL / EL Product: Snap logic
- Strong knowledge of, and experience with databases, writing medium to high complexity SQL statements, programming (ETL/ELT frameworks).
- Knowledge with Data Warehouse Architecture to build and articulate conceptual, logical, and physical dimensional data models, and Star Schema artifacts.
- Understanding of data modelling techniques and working knowledge with OLTP and OLAP systems.
- Hands on experience working with Python and a good understanding of shells scripts (bash/zsh, grep/sed/awk etc..) is preferred.
- Experience with data visualization tools like Power BI.
- Familiarity with cloud platforms like AWS.
QUALIFICATIONS:
- Bachelor’s or master’s degree in computer science, Information Systems, or related field.
- 10+ years of relevant work experience, including previous experience leading a team.
- Excellent problem-solving and analytical skills.
- The individual will need to be hands-on and work closely with all levels in the company.