

Sr Data Engineer
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Sr Data Engineer in the Bay Area, CA or Alpharetta, GA (Hybrid) for 12+ months at a competitive pay rate. Key skills include Matillion, Snowflake, Azure Data Factory, and strong SQL proficiency.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
-
ποΈ - Date discovered
July 9, 2025
π - Project duration
More than 6 months
-
ποΈ - Location type
Hybrid
-
π - Contract type
Unknown
-
π - Security clearance
Unknown
-
π - Location detailed
Oakland, CA
-
π§ - Skills detailed
#Azure Databricks #Debugging #Azure Blob Storage #Matillion #ADLS (Azure Data Lake Storage) #Data Warehouse #Version Control #Azure ADLS (Azure Data Lake Storage) #Storage #Databricks #Data Integration #Data Orchestration #Scripting #Azure cloud #Scala #Synapse #Data Pipeline #Data Quality #Data Governance #Data Engineering #SQL (Structured Query Language) #Bash #Documentation #"ETL (Extract #Transform #Load)" #Security #Data Science #Automation #Data Lake #Azure #Data Storage #Azure Data Factory #Microsoft Azure #Azure Synapse Analytics #Data Architecture #Data Analysis #Data Modeling #Python #ADF (Azure Data Factory) #Snowflake #GIT #Cloud
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
Position: Sr Data Engineer
Location: Bay Area, CA or Alpharetta, GA (Hybrid)
Duration: 12+ Months
Job Summary: The Data Engineer will be responsible for designing, developing, and maintaining data pipelines and ETL processes, ensuring the smooth integration of data from various sources into Snowflake. This role will focus on using Matillion for data transformation, working with Snowflake for cloud data warehousing, and leveraging Microsoft Azure tools for data orchestration and automation.
Key Responsibilities:
β’ ETL Development & Data Pipeline Management:
β’ Design, develop, and optimize ETL processes using Matillion to integrate, transform, and load data into Snowflake data warehouse.
β’ Collaborate with data architects and other teams to gather requirements and build robust, scalable data pipelines.
β’ Troubleshoot and optimize existing ETL workflows to enhance performance and minimize bottlenecks.
β’ Cloud Data Engineering:
β’ Work with Snowflake to design, implement, and manage data models, schemas, and tables.
β’ Ensure data quality, integrity, and consistency across various platforms.
β’ Manage the lifecycle of data stored in Snowflake and ensure proper governance, access control, and security protocols are followed.
β’ Integration with Azure:
β’ Leverage Azure Data Factory and other Azure services (e.g., Azure Databricks, Azure Data Lake) for orchestration and automation of data workflows.
β’ Manage and monitor the data pipeline performance, ensuring timely data movement across cloud environments.
β’ Utilize Azure Blob Storage or Azure Data Lake Storage for data storage and processing needs.
β’ Collaboration & Documentation:
β’ Collaborate with cross-functional teams including data scientists, analysts, and business stakeholders to understand data needs.
β’ Document processes, architectures, and pipelines to ensure clear knowledge sharing within the team.
β’ Data Optimization & Performance Tuning:
β’ Optimize Snowflake queries and data models to ensure high-performance analytics.
β’ Implement best practices for query performance, data compression, and cost optimization in Snowflake.
Required Skills and Qualifications:
β’ Experience:
β’ Proven experience as a Data Engineer, Data Analyst, or similar role, with hands-on experience working with Matillion, Snowflake, and Azure technologies.
β’ Strong experience in designing and managing ETL pipelines using Matillion.
β’ Solid experience working with Snowflake data warehousing solutions (data modeling, SQL, query optimization).
β’ Expertise in Azure cloud services (Azure Data Factory, Azure Blob Storage, Azure Databricks, etc.).
β’ Experience in cloud-based data integration and transformation workflows.
β’ Technical Skills:
β’ Strong proficiency in SQL for data querying, optimization, and debugging.
β’ Familiarity with scripting languages such as Python or Bash for automation tasks.
β’ Knowledge of Data Warehousing, Data Lakes, and Data Modeling concepts.
β’ Understanding of cloud architecture and design patterns.
β’ Soft Skills:
β’ Strong analytical and problem-solving skills.
β’ Excellent communication skills, with the ability to articulate technical concepts to non-technical stakeholders.
β’ Ability to work independently as well as part of a collaborative team.
Desired Qualifications:
β’ Experience in other Azure services such as Azure Synapse Analytics.
β’ Knowledge of data governance frameworks and security best practices.
β’ Familiarity with version control systems like Git.
β’ Certification in Matillion, Snowflake, or Azure is a plus.