IntePros · 1 day ago
Snowflake Engineer
United States
Contract
Remote
Entry, Mid Level
2+ years expIntePros is seeking a highly skilled Snowflake Data Engineer to support and enhance a Snowflake-based data warehouse environment within the mortgage and real estate domain. This role focuses on orchestrating ELT workflows within the Snowflake platform and requires hands-on experience with Snowflake, SQL, and Python to build and optimize data pipelines.
ConsultingInformation TechnologyStaffing Agency
Responsibilities
Support and enhance a Snowflake data warehouse, with a strong focus on performance, scalability, and reliability
Design and maintain ELT pipelines that move data across multiple layers (raw, processed, curated) within Snowflake
Develop and optimize heavy SQL workloads, including complex transformations, tuning, and optimization
Implement and manage Snowflake streams, dynamic tables, tasks, and stored procedures
Use Python to orchestrate workflows, build DAGs, and automate data processes within and around Snowflake
Process inbound data files, converting formats (e.g., flat files → Parquet) and loading data into S3 and Snowflake
Support application-side data needs, including building data pipelines for a pricing engine integrated with third-party suppliers
Handle imperfect, incomplete, or incorrect data, improving data quality, validation, and processing logic
Partner closely with data engineers, application engineers, and other technical teams to deliver scalable solutions
Contribute to DevOps and deployment practices related to data pipelines and Snowflake environments
Document data flows, transformations, and Snowflake use cases
Qualification
Required
2+ years of hands-on experience working with Snowflake in a production environment
Strong expertise in SQL, including query optimization and complex transformations within Snowflake
Proficiency in Python for data processing, orchestration, and workflow automation
Experience building and managing DAGs for data orchestration
Deep understanding of Snowflake architecture and features, including streams, dynamic tables, tasks, and stored procedures
Experience implementing ELT patterns within cloud-based data platforms
Familiarity with AWS, particularly S3 and file-based ingestion workflows
Exposure to DevOps practices in data engineering environments
Strong communication skills and the ability to collaborate effectively with technical teams
Preferred
Experience working with mortgage, lending, or real estate data
Familiarity with financial services data models, compliance, or regulatory considerations
Experience supporting application-facing data pipelines
Company
IntePros
IntePros is an established, woman-owned, privately-held technology and business services consulting agency committed to building long-term relationships and helping more companies leverage the power of a more diverse workforce.
201-500 employees
H1B Sponsorship
IntePros has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (3)
2023 (6)
2022 (7)
2021 (6)
2020 (13)
Funding
Current Stage
Growth StageLeadership Team
Loren Kovalcik
CEO
Company data provided by crunchbase