Senior Engineering Lead
Persistent
Persistent
Join our innovative team as a Senior Engineering Lead, driving the future of data platforms. This role focuses on designing, developing, and optimizing scalable data solutions using Snowflake and dbt. You will be instrumental in building robust ELT pipelines, ensuring data quality, and fostering best practices within modern cloud analytics environments. We seek a technical leader with hands-on development skills and a collaborative spirit to deliver exceptional data outcomes.
Lead the design and implementation of scalable data models and transformation pipelines with dbt on Snowflake. Develop and refine complex SQL queries, views, and stored procedures for advanced analytics. Construct and manage ELT pipelines, incorporating dbt models for staging, intermediate, and mart layers. Implement incremental data processing, snapshots, and slowly changing dimensions using dbt best practices. Oversee data ingestion from diverse sources into Snowflake. Maintain data warehouse architecture, including star/snowflake schemas, for analytical workloads. Ensure data integrity through validation tests, profiling, and monitoring with dbt. Optimize Snowflake performance via clustering, partitioning, query tuning, and warehouse management. Implement robust RBAC, data security, and governance protocols within Snowflake. Collaborate with analytics, BI, and data science teams to deliver valuable datasets and insights. Create and maintain comprehensive technical documentation, including data models and lineage. Contribute to architecture discussions, performance tuning, and cost optimization initiatives.
Possess 5 to 8 years of experience in SQL development, Data Engineering, or Data Warehousing. Demonstrate strong hands-on expertise in SQL, including complex queries, CTEs, window functions, and performance tuning. Exhibit practical experience with dbt, covering models, macros, snapshots, tests, and documentation. Showcase significant experience working with the Snowflake cloud data platform for loading, transformation, and performance optimization. Possess a solid understanding of data modeling concepts, such as dimensional modeling and star/snowflake schemas. Have experience with ELT pipelines and modern data stack architectures. Familiarity with cloud platforms like Azure, AWS, or GCP, and data orchestration tools such as Airflow or ADF is advantageous. Exhibit a good grasp of data governance, access control, and security practices within Snowflake. Apply strong analytical, troubleshooting, and problem-solving capabilities. Communicate effectively in both written and verbal formats.
Persistent Systems
IT Consulting