Affinitiv

Snowflake Data Engineer

Affinitiv

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AngularCloudETLSQLTableau

About the role

  • Monitor and support ETL processes moving data from on-premise or hosted servers into Snowflake
  • Troubleshoot data pipeline issues, including failed loads, data discrepancies, and performance bottlenecks
  • Design and maintain aggregate and reporting tables optimized for Tableau and Power BI dashboards
  • Create and maintain Snowflake stored procedures (GET procs) used by APIs to support Angular reporting applications
  • Optimize Snowflake performance and cost, including warehouse usage, query tuning, and table design
  • Support ad-hoc data requests from product, engineering, and analytics teams
  • Integrate third-party vendor data by reviewing technical documentation, designing ingestion processes, and validating data accuracy
  • Collaborate with application engineers to ensure data structures align with frontend and API requirements
  • Maintain clear documentation for data pipelines, stored procedures, and integrations

Requirements

  • 3+ years of experience in a data engineering or analytics engineering role
  • Strong hands-on experience with Snowflake
  • Proficiency in SQL, including complex joins, aggregations, and stored procedures
  • Experience supporting ETL pipelines and troubleshooting data flow issues
  • Familiarity with BI tools such as Tableau and/or Power BI
  • Experience designing data models for analytics and reporting use cases
  • Ability to read and implement third-party technical documentation
  • Strong problem-solving skills and attention to detail
  • Ability to manage multiple priorities in a fast-moving environment
  • Preferred: Experience working with API-driven reporting architectures
  • Preferred: Familiarity with Angular or frontend-consumed APIs
  • Preferred: Experience with cloud data integrations and vendor-provided data feeds
  • Preferred: Knowledge of data warehousing best practices (star schemas, aggregates, performance tuning)
  • Preferred: Experience working in a SaaS or analytics-heavy environment
  • Nice to Have: Experience with Snowflake cost optimization strategies
  • Nice to Have: Familiarity with CI/CD practices for data or analytics engineering
  • Nice to Have: Exposure to multiple data sources (CRM, marketing platforms, operational systems)
Benefits
  • Medical, dental, vision, and 401K effective day 1
  • Generous PTO
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SnowflakeSQLETLdata modelingstored proceduresdata pipeline troubleshootingquery tuningdata warehousingAPI integrationcloud data integrations
Soft Skills
problem-solvingattention to detailtime managementcollaborationdocumentation