Advantage TechnicalRemote
Data Movement Engineer
United States of America
Contract
2 hours ago
$55 - $65 USD
No H1B
Key skills
TalendSnowflakeData Vault 2.0SQLPythonShell scriptingCloud database technologiesAirflowESPGitServiceNowJiraCI/CD practicesChange Data Capture (CDC)Slowly Changing Dimensions (SCD Type 2)Dimensional modelingData warehousingShellETLData WarehousingBusiness IntelligenceVaultOracleSQL ServerVersion ControlCI/CDLeadershipMentoringTime Management
About this role
Advantage Technical is a company that connects top talent in technology, engineering, and technical fields with forward-looking companies. They are currently seeking a Data Movement Engineer to provide production support and lead the design and optimization of Snowflake-based data solutions. The ideal candidate will have strong technical expertise in Snowflake and data warehousing methodologies, and will be responsible for managing data operations and mentoring team members.
Responsibilities:
- Manage the full lifecycle of Snowflake data operations, including monitoring, troubleshooting, and optimizing data pipelines
- Proactively identify and resolve issues related to data integrity, latency, and pipeline failures to maintain smooth operations
- Translate stakeholder requirements into Snowflake-specific solutions for data movement
- Develop and optimize SQL queries, warehouse configurations, and data models for performance, reliability, and scalability
- Design, develop, and optimize Snowflake data pipelines and models
- Recommend and implement best practices for data ingestion, transformation, storage, security and data modeling
- Support advanced features like Change Data Capture (CDC)and Slowly Changing Dimensions (SCD Type 2)
- Support frameworks like Data Vault and dimensional modeling in Snowflake
- Monitor and troubleshoot data pipeline failures and performance issues in ETL and Snowflake environments
- Thoroughly test all production solutions prior to implementation
- Perform root cause analysis of data discrepancies, latency, and integrity issues
- Provide production support for IBM DB2, Snowflake, and orchestration tools (Airflow, ESP)
- Collaborate with other teams to implement fixes and preventive measures
- Perform data quality analysis, report issues, and propose solutions
- Ensure data accuracy, completeness, and consistency across systems
- Implement validation and reconciliation checks within pipelines
- Support data governance initiatives including metadata management and lineage tracking
- Lead the design, development, and maintenance of Snowflake processes
- Provide technical leadership, code reviews, and mentorship to junior developers
- Coordinate with business stakeholders, data architects, and application teams to gather requirements and deliver solutions
- Communicate issue status, impact, and resolution timelines effectively
- Maintain comprehensive documentation for all Snowflake-related issues, fixes, and scripts, ensuring they are version-controlled and aligned with data architecture and security standards
- Develop and maintain production support playbooks and detailed ticket resolution procedures to enable consistent and efficient incident handling
- Prepare effort estimations and contribute to architectural decisions
- Provide regular updates and reports on issue trends and improvement initiatives
- On-call and/or after-hours work required
Requirements:
- Strong Talend and Snowflake experience
- Minimum of 5 years of relevant experience in data warehousing, business intelligence tools, and data analysis
- Minimum of 3 years of SQL query development across multiple database platforms (Snowflake, Oracle, SQL Server, DB2)
- Strong expertise in Snowflake (development, data modeling, security)
- Strong proficiency in SQL and scripting languages (e.g., Python, Shell)
- Experience with cloud database technologies
- Familiarity with orchestration tools (ESP, Airflow) and version control systems (Git)
- Experience with incident management tools (e.g., ServiceNow, Jira) and CI/CD practices
- Expertise in CDC and SCD Type 2 implementations using SQL
- Solid understanding of data architecture, dimensional modeling, and frameworks like Data Vault
- Ability to solve problems using analytical thinking skills
- Must work well independently and be inquisitive
- Strong organizational and time management skills
- Bachelors degree in computer science, Information Systems, or related field
- 5+ years of experience in Snowflake, Talend development and data warehousing
- Snowflake certification