Negotiable
Outside
Remote
USA
Summary: The Datawarehouse Consultant role is a remote position focused on leveraging expertise in Snowflake and ETL processes, particularly with Azure Data Factory. The consultant will be responsible for production support, monitoring, and managing ETL processes, with a strong emphasis on critical thinking and problem-solving during data transformation projects. A background in financial services is required, and candidates should ideally have experience with Talend and Python. The position is contract-to-hire, with no visa sponsorship available.
Key Responsibilities:
- Strong expertise in Snowflake and ETL processes
- Proficient in Azure Data Factory
- Experience with Talend is helpful
- Python programming experience
- Utilization of GIT for repository management
- Production support, monitoring, and managing processes and tasks
- Setting up and configuring ETL processes
- Migrating from Talend, potentially to Azure Data Factory or DBT
- Strong experience with Azure Fabric
- Critical thinking and problem-solving during data transformation
- Experience extracting existing Talend code is helpful but not required
- Must be located on the East Coast
- Background in financial services is required
Key Skills:
- Snowflake expertise
- ETL process experience
- Azure Data Factory proficiency
- Talend knowledge
- Python programming skills
- GIT repository management
- Production support and monitoring
- ETL process configuration
- Azure Fabric experience
- Critical thinking and problem-solving abilities
- Financial services background
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Datawarehouse Consultant
Location: Remote East Coast
Duration: 6 months contract to hire - no visa sponsorship
About the Role:
- Looking for someone who is strong with Snowflake and experience with ETL
- Strong with Azure Data Factory
- Talend would be helpful
- Python experience
- Experience with GIT for repository
- Focused on production support monitoring and managing processes and tasks
- Standing up and configuring ETL Processes
- Migrating away from Talend, choice will more likely than not be azure data factory but still looking at DBT so if they have experience with this as well will be helpful
- Strong Azure Fabric experience
- Needs to have Azure and snowflake capabilities
- Needs a critical thinker someone who has gone through a transformation in the past, understands the complexity of it, and can come up with creative solutions
- Having experience previously extracting existing Talend code would be helpful but not required
- Position can be completely remote, but they need to be on the East Coast
- Financial services background required