> Markdown version of [/jobs/ext/4655317-snowflake-data-engineer-senior-data-engineer-w2](https://www.wearedevelopers.com/jobs/ext/4655317-snowflake-data-engineer-senior-data-engineer-w2). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Snowflake Data Engineer / Senior Data Engineer - W2 - **Company:** JUPITER IT SOLUTIONS LLC - **Location:** Kansas City, KS, United States - **Experience:** Expert - **Contract:** Contract - **Skills:** Artificial Intelligence, Amazon Web Services, ARM Architecture, Microsoft Azure, Big Data, Data Validation, Data Integration, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Migration, Data Systems, Data Transformation Services, Data Warehousing, Database Queries, Python (Programming Language), Operational Data Store, Performance Tuning, Query Optimization, Software Deployment, SQL Stored Procedures, Macros, Snowflake, Information Technology, Real Time Data, Apache Kafka, Data Pipelines - **Published:** November 10, 2026 - **Apply:** https://www.dice.com/job-detail/80bd5cca-cd01-44ec-aa20-371b780279c1 ## About the Role Experience: 5-12 Years (Flexible based on expertise) Primary Skills: Snowflake, ETL, DBT Good to Have: Snowflake Cortex AI, Railway / Transportation Domain, Experience working with Snowflake Cortex AI and railway or transportation-related projects will be an added advantage., Strong hands-on experience in Snowflake. - Good experience in ETL/ELT development and data integration. - Hands-on experience with DBT (models, tests, snapshots, macros, and incremental models). - Strong SQL skills, including complex queries and stored procedures. - Experience with data warehousing concepts and dimensional data modelling. - Knowledge of data pipeline orchestration and scheduling. - Experience handling large volumes of data and optimizing performance. Good to Have Skills - Exposure to Snowflake Cortex AI, Cortex Search, Cortex Analyst, or AI-powered data solutions. - Experience with Snowflake Snowpark and Python. - Experience with cloud platforms such as AWS or Azure. - Experience in railway, transportation, logistics, or supply chain domain. - Understanding of railway operational data, train movements, schedules, events, and operational reporting. - Experience with CDC, Kafka, or real-time data integration. Preferred Domain Experience Candidates with experience in railway or transportation projects will be given preference, particularly those who have worked on: - Train scheduling and movement data. - Train tracking and operational events. - Locomotive and equipment data. - Operational reporting and KPI dashboards. - Integration of multiple railway source systems. Education Bachelor's or Master's degree in Computer Science, IT, Engineering, or a related discipline ## Description We are looking for an experienced Snowflake Data Engineer with strong expertise in Snowflake, ETL development, and DBT. The candidate should have hands-on experience designing, developing, and maintaining scalable data pipelines and implementing efficient data transformation solutions., Design, develop, and maintain scalable data pipelines using Snowflake. - Build and optimize ETL/ELT workflows for integrating data from multiple source systems. - Develop and maintain DBT models, including staging, intermediate, and data mart layers. - Implement incremental data loads, CDC mechanisms, and data transformation logic. - Perform Snowflake query optimization and performance tuning. - Work with Snowflake features such as Streams, Tasks, Dynamic Tables, and Snowpipe. - Implement data quality checks, data reconciliation, and validation processes. - Collaborate with architects, business analysts, and other engineering teams. - Support data migration, integration, and production deployment activities.