Big Data Lead
At a glance
Senior Data Engineering role at Fa Etqo Saasfaprod1. United States · full-time · no salary stated · we estimate $142,500–$193,650 across the United States.
Fa Etqo Saasfaprod1 has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build and tune SQL queries, applying indexing and partitioning to improve database performance
- Create ETL/ELT pipelines for structured and unstructured data, with logging, error handling and recovery
- Use advanced SQL to transform and process data, and maintain fact and dimension tables for reporting
- Design data warehouse models, including star schemas, and tune performance in warehouse environments
What you bring
- Strong SQL development skills, including query optimization and advanced scripting for data transformations
- Hands-on ETL/ELT development experience and the ability to build and optimize data pipelines
- Experience with Snowflake or another relational database, plus an understanding of data warehousing and dimensional modeling
Who this fits
This senior role suits someone focused on SQL, ETL/ELT development and data warehousing. Snowflake is preferred; experience with GIT, CI/CD tools and Azure or AWS is useful but not core to the role.
From the employer
Database Development & Management • Strong experience in SQL development and query optimization. • Hands-on experience with Snowflake (preferred), Oracle, or any relational database. • Understanding of database indexing, partitioning, and performance tuning. . ETL/ELT Development • Expertise in ETL/ELT development, preferably using Talend (or any other ETL tool). • Strong proficiency in Advanced SQL scripting for data transformation and processing. • Ability to design, develop, and optimize data pipelines for structured/unstructured data. • Experience in error handling, logging, and recovery mechanisms for ETL processes. Data Warehousing & Modeling • Understanding of Data Warehousing concepts, including Star Schema and Dimension Modeling. • Hands-on experience with Snowflake (preferred) or other cloud/on-prem data warehouses. • Ability to design and maintain Fact and Dimension tables for analytics and reporting. • Knowledge of data partitioning and performance tuning techniques in DWH environments. CI/CD & Version Control (Good to Have, Not Core Focus) • Experience using GIT for version control of ETL scripts and database objects. • Exposure to CI/CD tools like TeamCity (preferred), Jenkins, or Azure DevOps for ETL deployment automation. • Understanding of branching strategies, merging, and automated deployments for ETL processes. • Familiarity with scheduled job execution and monitoring via CI/CD tools. Cloud Exposure (Good to Have, Not Core Focus) • Basic familiarity with Azure or AWS cloud environments. • Understanding of Snowflake on Azure/AWS or Redshift on AWS (data storage, querying, and schema management). • Exposure to cloud storage solutions (Azure Blob, AWS S3) for data ingestion and staging. • Awareness of cloud-based ETL services (Azure Data Factory, AWS Glue) – preferred but not required.