Snowflake Data Architect - Data Warehousing (6-12 yrs)

Inviting applications for the role of Senior Engineer - Software Development, Data Engineer!

Mandatory Skillsets : Snowflake+ DBT+ DataWarehousing +Data Modelling+ Python

Responsibilities

- Architect, Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow.

- Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.

- Actively monitor and triage technical challenges in critical situations that require immediate resolution.

- Evaluate viable technical solutions and share MVPs or PoCs in support of the research

- Develop relationships with external stakeholders to maintain awareness of data and security issues and trends

- Review work from other tech team members and provide feedback for growth

- Implement Data Performance, Data security policies that align with governance objectives and regulatory requirements.

Qualifications we seek in you!

Minimum Qualifications

- You have experience in data warehousing, data modeling, and the building of data engineering pipelines.

- You are well versed in data engineering methods, such as ETL and ELT techniques through scripting and/or tooling.

- You are good in analyzing performance bottlenecks and providing enhancement recommendations; you have a passion for customer service and a desire to learn and grow as a professional and a technologist.

- Strong analytical skills related to working with unstructured datasets.

- Collaborating with product owners to identify requirements, define desired outcomes and deliver trusted results.

- Building processes supporting data transformation, data structures, metadata, In this role, SQL is heavily focused.

- An ideal candidate must have hands-on experience with SQL database design. Plus, Python.

- Demonstrably deep understanding of SQL (level: advanced) and analytical data warehouses (Snowflake preferred). Demonstrated ability to write new code i.e., well-documented and stored in a version control system (we use GitHub & Bitbucket)

- Extremely talented in applying SCD, CDC and DQ/DV framework. Familiar with JIRA & Confluence.

- Must have exposure to technologies such as dbt, Apache airflow and Snowflake.

- Desire to continually keep up with advancements in data engineering practices. Knowledge on AWS cloud, Python is a plus.

- Essential Education Bachelor's degree or equivalent combination of education and experience.

Preferred Qualifications

- Bachelor's degree in information science, data management, computer science or related field preferred.