Tech Stack
ApacheAzureCloudETLKafkaMatillionPythonSparkSQL
About the role
- Design, develop, and maintain a scalable Snowflake data solution for the enterprise data & analytics team
- Implement data pipelines, ETL/ELT workflows, and data warehouse solutions using Snowflake and related technologies
- Optimize Snowflake database performance and ensure scalability
- Perform independent data analysis and data discovery of source systems, fact and dimension data models
- Implement enterprise data warehouse solutions following Medallion data architecture best practices
- Collaborate with data analysts, business analysts, data scientists, and software engineers to define and implement data solutions
- Ensure data quality, integrity, and governance across the data platform
- Troubleshoot and resolve data-related issues to maintain high availability and performance
- Take direction from Lead Snowflake Data Engineer and Director of Data Engineering while contributing domain expertise
Requirements
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field
- 4+ years of experience in-depth data engineering
- At least 1+ year of dedicated experience engineering solutions in an enterprise scale 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
- Experience 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
- 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 including sprint planning, daily stand-ups, backlog grooming, and retrospectives
- Ability to document user stories and tasks through Azure Dev Ops
- Ability to read, understand, and apply state/federal laws, regulations, and policies
- Strong analytical and problem-solving skills
- Strong oral, written, and interpersonal communication skills
- Eligible for Ventra performance-based incentive plan
- Referral bonus for referring a friend
- Discretionary incentive bonus in accordance with company policies
- Rewards & Recognition program participation
- Reasonable accommodations for qualified individuals with disabilities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SnowflakeETLELTANSI SQLdata modelingdata processingPythonCI/CDDevOpsInfrastructure as Code
Soft skills
analytical skillsproblem-solving skillsoral communicationwritten communicationinterpersonal communication
Certifications
Snowflake SnowPro certification