What are the responsibilities and job description for the Lead/Junior Data Engineer position at SRM Digital LLC?
Job Title: Lead Data Engineer / Junior Data Engineer
Job Summar
yWe are seeking talented Data Engineers to join our growing data team. The ideal candidates will have hands-on experience with Snowflake, dbt, SQL, and modern data engineering practices. You will be responsible for designing, developing, and maintaining scalable data pipelines, optimizing data models, and supporting business intelligence and analytics initiatives
.
Key Responsibiliti
• Design, develop, and maintain scalable ETL/ELT pipelines for structured and unstructured dat
.• Build and maintain data pipelines using Snowflake and db
• Design efficient and scalable data models including Star Schema and Snowflake Schem
• Develop, optimize, and troubleshoot complex SQL queries for data transformation and reportin
• Implement ELT workflows leveraging Snowflake architecture and best practice
• Work with semi-structured data formats such as JSON and Parque
• Collaborate with business stakeholders, analysts, and cross-functional teams to understand data requirements and deliver solution
• Monitor, schedule, and manage data workflows using Control-M or similar orchestration tool
• Perform data validation, testing, and quality assurance to ensure data accuracy and integrit
• Troubleshoot data pipeline failures, performance bottlenecks, and system issue
• Maintain technical documentation for pipelines, models, and processe
• Utilize Python for data processing, automation, and scripting task
• Work in UNIX/Linux environments and develop shell scripts when require
Required Ski
• Strong experience with Snowflake Data Warehou
• Hands-on experience with dbt (Data Build Too
• Advanced SQL development and query optimization skil
• Experience building ETL/ELT pipelin
• Knowledge of data modeling concepts (Star Schema, Snowflake Schem
• Experience handling semi-structured data (JSON, Parque
• Working knowledge of Pyth
• Experience with UNIX/Linux commands and shell scripti
• Familiarity with Control-M or similar scheduling/orchestration too
• Understanding of data pipeline monitoring, troubleshooting, and performance tuni
ng.
Lead Data Engineer - Additional Requirem
ents• 7 years of Data Engineering experie
nce.• Proven experience leading data engineering initiatives and mentoring team memb
ers.• Strong expertise in data architecture, pipeline optimization, and data governa
nce.• Ability to collaborate with business and technical leadership to define data strateg
ies.• Experience driving best practices for scalability, security, and performa
Junior Data Engineer - Additional Require
• 1-3 years of Data Engineering experi
• Basic understanding of data warehousing and ETL conc
• Strong willingness to learn modern data engineering tools and technolo
• Ability to work collaboratively in a fast-paced environ
• Good analytical and problem-solving sk