Sr. Snowflake Data Engineer & DBA

Jobs via Dice; Dallas (TX); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is looking for a skilled data professional to develop and maintain scalable data solutions using Snowflake. This role requires a deep understanding of data modeling, particularly Data Vault architecture, alongside expertise in database administration. You will work with cloud technologies like AWS and tools such as Python, Spark, and Apache Airflow to create efficient data pipelines and analytics solutions. This position offers a dynamic and collaborative environment where your contributions will significantly impact data-driven decision-making processes. If you are passionate about data and eager to innovate, this opportunity is perfect for you.

Qualifications

• Expertise in Snowflake and Data Vault architecture is essential.
• Strong background in AWS services and Python for data solutions.

Responsibilities

• Design and implement scalable data solutions using Snowflake.
• Build ETL/ELT pipelines with Python and Spark for data integration.

Skills

Snowflake development

Data modeling

Database administration

AWS services

Python

Spark

Apache Airflow

SQL Server DBA

Job description

We are seeking a talented data professional to design, develop, and maintain scalable data solutions using Snowflake. The ideal candidate brings expertise in data modeling (particularly Data Vault architecture) and database administration (DBA), with additional skills in AWS, Python, Spark, and Apache Airflow to support cloud-based data pipelines and analytics. Experience with SQL Server DBA is a strong plus.

Key Responsibilities

• Design and implement scalable data solutions using Snowflake.
• Perform data modeling, including Data Vault, to optimize data organization and retrieval.
• Optimize Snowflake environments for performance, scalability, and security.
• Build ETL/ELT pipelines using Python and Spark for data integration and transformation.
• Leverage AWS services (e.g., S3, Glue, Lambda) for cloud-based data storage and processing.
• Create task orchestration workflows with Apache Airflow.
• Collaborate with cross-functional teams to gather requirements and deliver tailored solutions.
• Ensure data integrity, security (e.g., RBAC, encryption), and compliance with industry standards.

Required Skills

Primary

• Proficiency in Snowflake development (e.g., data pipelines, Snowpipe, stages, stored procedures).
• Strong experience in data modeling, including Data Vault architecture.
• Solid knowledge of database administration principles.

Secondary

• Expertise in AWS services (e.g., S3, Glue, Lambda).
• Proficiency in Python for scripting and automation.
• Experience with Spark for distributed data processing.
• Familiarity with Apache Airflow for orchestration.

Desirable

• Experience with SQL Server DBA.