[Remote] Data Movement Engineer

Note: The job is a remote job and is open to candidates in USA. USPRO is seeking a Data Movement Engineer to support and enhance their enterprise data ecosystem. This role will lead the design, optimization, and support framework for Snowflake-based data solutions while ensuring the robustness and scalability of ETL environments.ResponsibilitiesOversee the full lifecycle of Snowflake data operations including monitoring, troubleshooting, and optimization of data pipelinesProactively identify and resolve issues related to data integrity, latency, and pipeline failuresTranslate business and stakeholder requirements into scalable Snowflake data solutionsDesign and implement performant SQL queries, data models, and warehouse configurationsBuild, test, and maintain Snowflake pipelines for data ingestion, transformation, and analyticsApply best practices for data storage, modeling, and securitySupport and implement advanced features including Change Data Capture (CDC) and Slowly Changing Dimensions (SCD Type 2)Leverage modeling frameworks such as Data Vault and dimensional modeling to optimize the data architectureConduct thorough testing and validation of production solutions prior to deploymentProvide operational support for Snowflake, IBM DB2, and ETL orchestration tools such as Airflow or ESPAnalyze data quality issues, perform root cause analysis, and implement fixes and preventive measuresEnsure data accuracy, completeness, and consistency across systems through validation and reconciliation processesContribute to metadata management, data lineage, and governance initiativesDevelop and maintain production support playbooks and ticket resolution proceduresLead design reviews, mentor junior data engineers, and collaborate with cross-functional teamsCommunicate technical findings, incident updates, and project timelines effectivelyDocument Snowflake processes, job configurations, and troubleshooting proceduresParticipate in on-call and after-hours support rotations as neededSkillsMust be located in EST time zone of U.SMust be able to travel onsite to New Haven, CT up to 10% as neededThis position does not provide visa sponsorship, must be authorized to work in the U.SBachelor's degree in Computer Science, Information Systems, or a related fieldMinimum of 5+ years of hands-on experience with Snowflake development and data warehouse integrationMinimum of 5 years of experience in data warehousing, business intelligence, or data analysisMinimum of 3 years' experience developing in Snowflake and writing complex SQL queries across different database platforms (e.g., Oracle, SQL Server, DB2)Deep expertise in Snowflake architecture, performance tuning, and security management (certification preferred)Strong skills in SQL and scripting languages such as Python and ShellExperience with cloud database technologies and modern data ecosystemsFamiliarity with orchestration tools (Airflow, ESP) and version control (Git)Hands-on experience with incident tracking tools (ServiceNow, Jira) and CI/CD processesProven success implementing CDC and SCD Type 2 logic using SQLStrong understanding of dimensional modeling, data architecture, and frameworks such as Data Vault 2.0Ability to work independently, investigate issues proactively, and solve complex technical problemsExcellent organization, communication, and time management skillsBenefitsThis position will be available for >90% Remote/Hybrid work schedule, with periodic travel onsite up to 10%. Candidates should be located in Eastern Time Zone of the U.S., preferably regional to the New Haven, CT with ease in ability to work onsite as needed. (travel expenses will be paid by company)USPRO is an equal opportunity employer and will consider all applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, disability and/or other protected categories.We are also committed to providing reasonable accommodation(s) to qualified individuals with disabilities or needs, as required by law.Company OverviewUSPRO is a staffing agency that offers temporary and permanent hiring solutions. It was founded in 2009, and is headquartered in Boston, Massachusetts, USA, with a workforce of 11-50 employees. Its website is https://uspro.net.