Snowflake Data Engineer
Upload My Resume
Drop here or click to browse · PDF, DOCX, TXT
Requirements
- 3+ years of experience in a data engineering or analytics engineering role
- data engineering or analytics engineering role
- Strong hands-on experience with Snowflake
- Snowflake
- Proficiency in SQL, including complex joins, aggregations, and stored procedures
- Experience supporting ETL pipelines and troubleshooting data flow issues
- ETL pipelines
- Familiarity with BI tools such as Tableau and/or Power BI
- BI tools
- Experience designing data models for analytics and reporting use cases
- analytics and reporting use cases
- Ability to read and implement third-party technical documentation
- third-party technical documentation
- Strong problem-solving skills and attention to detail
- Ability to manage multiple priorities in a fast-moving environment
- Experience working with API-driven reporting architectures
- API-driven reporting architectures
- Familiarity with Angular or frontend-consumed APIs (understanding how data is consumed, not UI development)
- Angular or frontend-consumed APIs
- Experience with cloud data integrations and vendor-provided data feeds
- cloud data integrations
- Knowledge of data warehousing best practices (star schemas, aggregates, performance tuning)
- Experience working in a SaaS or analytics-heavy environment
- Experience with Snowflake cost optimization strategies
- Familiarity with CI/CD practices for data or analytics engineering
- Exposure to multiple data sources (CRM, marketing platforms, operational systems)
- What You’ll Work On
- What You’ll Work On
- Scalable reporting datasets for executive and dealer-facing dashboards
- Backend data logic that powers modern Angular applications
- Real-world integrations with external vendors and data providers
- Work from Here
- At Affinitiv, we have the best of both worlds. Our team members have embraced remote work and our Work from Here program allows for remote working and the utmost flexibility while keeping in person collaborating thriving in a safe work environment. Our Work from Here approach gives team members a choice to work on campus or remote, leaders can hold in person or virtual team meetings to collaborate and cultivate relationships.
- Affinitiv knows you have interests outside of work, which is why we offer a comprehensive benefits package that includes medical, dental, vision and 401K effective day 1 just to name a few. We also offer generous PTO so you can enjoy off time with family and friends.
- At Affinitiv, we celebrate diversity, equality, and an inclusive environment.
Responsibilities
- Monitor and support ETL processes moving data from on-premise or hosted servers into Snowflake
- Monitor and support ETL processes
- Troubleshoot data pipeline issues, including failed loads, data discrepancies, and performance bottlenecks
- Troubleshoot data pipeline issues
- Design and maintain aggregate and reporting tables optimized for Tableau and Power BI dashboards
- Design and maintain aggregate and reporting tables
- Create and maintain Snowflake stored procedures (GET procs) used by APIs to support Angular reporting applications
- Create and maintain Snowflake stored procedures (GET procs)
- Optimize Snowflake performance and cost, including warehouse usage, query tuning, and table design
- Optimize Snowflake performance and cost
- Support ad-hoc data requests from product, engineering, and analytics teams
- Support ad-hoc data requests
- Integrate third-party vendor data by reviewing technical documentation, designing ingestion processes, and validating data accuracy
- Integrate third-party vendor data
- Collaborate with application engineers to ensure data structures align with frontend and API requirements
- Collaborate with application engineers
- Maintain clear documentation for data pipelines, stored procedures, and integrations
- Maintain clear documentation
Similar Jobs
15h ago
Yesterday
Yesterday
Yesterday