Snowflake data engineer - Dallas TX
Lorven Technologies Inc
Dallas, United States of America
3 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Remote
Dallas, United States of America
Tech stack
API
Artificial Intelligence
ARM
Automation of Tests
Software as a Service
Databases
Data Cleansing
Data Discovery
Information Engineering
Data Infrastructure
Data Integration
ETL
Data Transformation
Data Systems
Data Warehousing
Relational Databases
Decision Support Systems
Dimensional Modeling
Data Intelligence
Python
Performance Tuning
Query Optimization
Data Logging
Data Processing
Freeform SQL
Data Ingestion
Sql Optimization
Rollup
Large Language Models
Snowflake
Analytic Functions
Backend
Information Technology
Data Lineage
Enterprise Integration
Virtual Agents
REST
Pagination
Stream Processing
Data Pipelines
Api Management
Job description
- Design, develop, and optimize scalable data solutions within Snowflake.
- Build and maintain logical and physical data models to support analytics and reporting requirements.
- Develop and optimize advanced SQL queries utilizing features such as PIVOT, GROUPING SETS, ROLLUP, and CUBE.
- Manage and support Snowflake production environments, ensuring performance, security, and reliability.
- Implement best practices for data warehousing, governance, and performance tuning.
Data Integration & Pipeline Development
- Design and implement ETL/ELT pipelines to ingest, transform, and load data from diverse sources.
- Integrate data from relational databases, REST APIs, SaaS applications, and event-streaming platforms.
- Build scalable and reusable data ingestion frameworks and transformation processes.
- Ensure high-quality, consumption-ready datasets through data cleansing, validation, and transformation.
Data Modeling & Architecture
- Design normalized and dimensional data models, including star and snowflake schemas.
- Collaborate with business stakeholders to translate requirements into scalable data solutions.
- Develop and maintain metadata, documentation, and data lineage artifacts.
Python Development
- Develop Python-based solutions for data transformation, workflow automation, and orchestration.
- Build API integrations, automation scripts, and data processing services.
- Implement robust error handling, logging, monitoring, and retry mechanisms.
- Support deployment and maintenance of production-grade data engineering solutions.
AI & Intelligent Data Workflows
- Utilize Snowflake Cortex and LLM-powered capabilities to develop intelligent data applications.
- Design and implement AI agent workflows within the Snowflake ecosystem.
- Explore and apply agent-based architectures for data discovery, automation, and decision support.
- Collaborate with data science and AI teams to operationalize AI-driven solutions.
Backend Integration & Services
- Develop backend integrations using Python and REST APIs.
- Implement authentication, authorization, pagination, rate limiting, and error-handling strategies.
- Support service-to-service communication and scalable integration architectures., Position: Senior Snowflake Data Engineer Location: Richardson TXONSITE Duration: 1 Years Mandatory Skills : ETL Concepts, Python for DATA, Snowflake We are looking fo…
- 19 hours ago
- Apply easily, Mandatory Skills : ETL Concepts, Python for DATA, Snowflake We are looking for a Senior Data Platform Engineer Candidate will design and operate data pipelines that connect heter…
- 20 hours ago
- Apply easily
Requirements
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- 5+ years of experience in Data Engineering, Data Warehousing, or related roles.
- Strong hands-on experience with Snowflake in enterprise production environments.
- Advanced SQL expertise with complex query optimization and analytical functions.
- Strong proficiency in Python for data engineering and automation.
- Experience designing and implementing ETL/ELT pipelines.
- Expertise in dimensional modeling, data warehousing concepts, and schema design.
- Experience integrating data from APIs, databases, SaaS platforms, and streaming systems.
- Familiarity with Snowflake Cortex, LLM functions, or AI-enabled data workflows.
- Experience with REST API integrations and backend development patterns., Job Overview: We are seeking a Snowflake Data Engineer with a background in healthcare data to design and implement data solutions. Requirement/Must Have: Strong experience i…
- 19 hours ago