Senior Data Engineer

Anblicks; Dallas (TX); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading data solutions company in Texas is seeking a Senior Data Engineer to design and maintain data pipelines, optimize data models, and implement ETL processes. The ideal candidate will have strong SQL skills and hands-on experience with Snowflake and DBT, and a capacity for analytical thinking and problem-solving. This role offers a dynamic work environment with opportunities for collaboration across teams.

Qualifications

• Strong SQL skills for writing and optimizing queries.
• Hands-on experience with Snowflake, including data modeling and performance tuning.
• Proficient in using DBT for data transformation and modeling.

Responsibilities

• Design, build, and maintain efficient data pipelines using Snowflake and DBT.
• Develop and optimize data models in Snowflake to support analytics.
• Implement ETL processes to transform raw data into structured formats.

Skills

SQL proficiency

Snowflake experience

DBT expertise

Data warehousing knowledge

Analytical thinking

Communication skills

Problem-solving

Python

PySpark

AWS

Job description

Job Title

Senior Data Engineer

Key Responsibilities

• Data Pipeline Development: Design, build, and maintain efficient data pipelines using Snowflake and DBT.
• Data Modeling: Develop and optimize data models in Snowflake to support analytics and reporting needs.
• ETL Processes: Implement ETL processes to transform raw data into structured formats using DBT.
• Performance Tuning: Optimize Snowflake queries and DBT models for performance and scalability.
• Data Integration: Integrate Snowflake with various data sources and third-party tools.
• Collaboration: Work closely with data analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions.
• Data Quality: Implement data quality checks and testing to ensure the accuracy and reliability of data.
• Documentation: Document data transformation processes and maintain comprehensive records of data models and pipelines.

Required Skills

• Proficiency in SQL: Strong SQL skills for writing and optimizing queries.
• Experience with Snowflake: Hands-on experience with Snowflake, including data modeling, performance tuning, and integration.
• DBT Expertise: Proficient in using DBT for data transformation and modeling.
• Data Warehousing: Knowledge of data warehousing concepts and experience with platforms like Snowflake.
• Analytical Thinking: Ability to analyze complex data sets and derive actionable insights.
• Communication: Strong communication skills to collaborate with cross-functional teams.
• Problem-Solving: Excellent problem-solving skills and attention to detail.
• python, pyspark, AWS