Data Lead - Azure Data Factory (ADF), Databricks

HCL Technologies Limited; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

Sapsf is seeking a skilled Data Engineer to design and optimize scalable data pipelines, architectures, and datasets in the United States. You will ensure data availability and enable data-driven decision making while implementing robust ETL processes and governance.

The role emphasizes collaboration with data scientists and analysts, building data warehouses and lakes, and optimizing performance across large datasets with modern tooling.

Qualifications

• Bachelor’s degree in computer science, engineering, information technology, or a related field.
• 5+ years of experience as a Data Engineer or in a similar role.
• Proficiency in Snowflake SQL and experience with relational databases (e.g., MySQL, PostgreSQL).
• Knowledge of data warehousing solutions- BigQuery.
• Good to have hands on programming languages like Python.
• Strong understanding of Matillion ETL tool and processes.
• Experience with data modeling and data architecture design.

Responsibilities

• Data Pipeline Development: Design, construct, test, and maintain highly scalable data management systems.
• Data Integration: Integrate structured and unstructured data from multiple data sources into a unified data system.
• Data Warehousing: Build and maintain data warehouses and data lakes for large data volumes.
• Data Processing: Implement data processing frameworks e.g., Hadoop, Spark for real-time or batch processing.
• Automation and Monitoring: Automate manual processes, optimize data delivery, and monitor data integrity.
• Collaboration: Work with data scientists, analysts, and stakeholders to meet data needs.
• Data Governance: Ensure data security, privacy, and regulatory compliance.
• Performance Tuning: Optimize ETL processes and data pipelines to reduce processing times.

Skills

Data Pipeline Development

Data Integration

Data Warehousing

Data Processing

Automation and Monitoring

Collaboration

Data Governance

Performance Tuning

Education

Bachelor's degree

Tools

Snowflake SQL

MySQL/PostgreSQL

BigQuery

Python

Matillion ETL

Job description

We are looking for a skilled Data Engineer to join our team. The ideal candidate will have experience in building and optimizing data pipelines, architectures, and data sets. You will be responsible for creating and maintaining scalable data architectures, ensuring data availability, and enabling data-driven decision-making processes. This role requires a deep understanding of data management practices, data warehousing, and ETL processes.

Key Responsibilities

• Data Pipeline Development: Design, construct, test, and maintain highly scalable data management systems. Develop and implement architectures that support the extraction, transformation, and loading ETL of data from various sources.
• Data Integration: Integrate structured and unstructured data from multiple data sources into a unified data system, ensuring data quality and consistency.
• Data Warehousing: Build and maintain data warehouses and data lakes to store and retrieve vast amounts of data efficiently. Optimize the performance of databases and queries to meet business needs.
• Data Processing: Implement data processing frameworks e.g., Hadoop, Spark to process large datasets in real-time or batch processing.
• Automation and Monitoring: Automate manual processes, optimize data delivery, and develop data monitoring systems to ensure data integrity and accuracy.
• Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand data needs and provide technical solutions that meet business requirements.
• Data Governance: Ensure data governance policies are followed, including data security, data privacy, and compliance with regulations.
• Performance Tuning: Optimize the performance of ETL processes, databases, and data pipelines to handle large volumes of data and reduce processing times.

Skill Requirements

• Data Pipeline Development: Design, construct, test, and maintain highly scalable data management systems. Develop and implement architectures that support the extraction, transformation, and loading ETL of data from various sources.
• Data Integration: Integrate structured and unstructured data from multiple data sources into a unified data system, ensuring data quality and consistency.
• Data Warehousing: Build and maintain data warehouses and data lakes to store and retrieve vast amounts of data efficiently. Optimize the performance of databases and queries to meet business needs.
• Data Processing: Implement data processing frameworks e.g., Hadoop, Spark to process large datasets in real-time or batch processing.
• Automation and Monitoring: Automate manual processes, optimize data delivery, and develop data monitoring systems to ensure data integrity and accuracy.
• Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand data needs and provide technical solutions that meet business requirements.
• Data Governance: Ensure data governance policies are followed, including data security, data privacy, and compliance with regulations.
• Performance Tuning: Optimize the performance of ETL processes, databases, and data pipelines to handle large volumes of data and reduce processing times.

Other Requirements

• Bachelor’s degree in computer science, Engineering, Information Technology, or a related field.
• 5+ years of experience as a Data Engineer or in a similar role.
• Proficiency in Snowflake SQL and experience with relational databases (e.g., MySQL, PostgreSQL).
• Knowledge of data warehousing solutions- BigQuery.
• Good to have hands on programming languages like Python.
• Strong understanding of Matillion ETL tool and processes.
• Experience with data modeling and data architecture design.