Tech Stack
ApacheAzureCloudETLKafkaMatillionPythonSparkSQL
About the role
- Lead the design, development, and maintenance of a scalable Snowflake data solution serving the enterprise data & analytics team
- Architect and implement data pipelines, ETL/ELT workflows, and data warehouse solutions using Snowflake and related technologies
- Optimize Snowflake database performance, storage, security, and credit control/management
- Provide guidance on Snowflake best practices and governance
- Collaborate with cross-functional teams of data analysts, business analysts, data scientists, and software engineers to define and implement data solutions
- Ensure data quality, integrity, and governance across the organization
- Provide technical leadership and mentorship to junior and mid-level data engineers
- Troubleshoot and resolve data-related issues, ensuring high availability and performance of the data platform
- Perform independent in-depth data analysis and data discovery to understand source systems, fact and dimension data models, and implement an enterprise data warehouse in Snowflake
Requirements
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field
- 7+ years of in-depth data engineering experience
- At least 3+ years of dedicated experience engineering solutions in a Snowflake environment
- Tactical expertise in ANSI SQL, performance tuning, and data modeling techniques
- Strong experience with cloud platforms (preference to Azure) and their data services
- Proficiency in ETL/ELT development using tools such as Azure Data Factory, dbt, Matillion, Talend, or Fivetran
- Hands-on experience with scripting languages like Python for data processing
- Strong understanding of data governance, security, and compliance best practices
- Snowflake SnowPro certification; preference to the engineering course path
- Experience with CI/CD pipelines, DevOps practices, and Infrastructure as Code (IaC)
- Knowledge of streaming data processing frameworks such as Apache Kafka or Spark Streaming
- Familiarity with BI and visualization tools such as PowerBI
- Familiarity working in an agile scrum team and using Azure Dev Ops for user stories and tasks
- Strong analytical, problem-solving, oral, written, and interpersonal communication skills
- Ability to read, understand, and apply state/federal laws, regulations, and policies
- Ability to self-manage large complex deliverables and mentor junior/mid-level engineers