Support and maintain Census syncs between Snowflake and downstream tools.
Help design and document Census models and sync logic to ensure data reliability and consistency.
Monitor and troubleshoot data issues related to Census, Fivetran, and Segment pipelines.
Partner with Analytics to ensure upstream data supports activation and reporting needs.
Write and maintain SQL queries in Snowflake to support reporting and analysis.
Assist with ad hoc data requests and exploratory analysis for internal stakeholders.
Support the creation, maintenance, and updates of Tableau dashboards and published data sources.
Help validate data accuracy and investigate discrepancies surfaced through reporting.
Work with Analytics team members to refine data requirements and improve metric clarity.
Contribute SQL and documentation to shared repositories and knowledge bases.
Use tools like Notion, Git, and Jira to track work and communicate progress.
Support ongoing efforts to standardize definitions and improve data transparency.

Requirements

2+ years of experience working with SQL and relational databases, ideally Snowflake.
Hands-on experience with Census, or strong familiarity with reverse ETL concepts.
Experience working with Fivetran and Segment data pipelines.
Experience building or supporting Tableau dashboards.
Comfort working with Git and basic project tracking tools.

Benefits

Unlimited Vacation (PTO)
Fully remote/work from home role
Gym membership/wellness stipend
Opportunities for professional growth and development

Applicant Tracking System Keywords

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

Hard skills

SQLSnowflakeCensusFivetranSegmentTableaudata modelingdata validationdata analysisreverse ETL

Soft skills

troubleshootingcommunicationcollaborationdocumentationdata transparencyanalytical thinkingproblem-solvingattention to detailorganizational skillsstakeholder management