Senior Software Engineer - ETL

About Census Census is the first Data Activation platform built on your warehouse. Sync 360° customer data to 200+ business tools today with Reverse ETL. Empower marketing teams to build dynamic audiences with a no-code segment builder. Census is how data teams at companies like Canva, Figma, Rippling, Carta, and Notion build better business operations. Backed by a16z , Sequoia, Tiger Global & Insight; we're a hybrid team headquartered in San Francisco that loves taking annoying problems most people avoid and building elegant solutions for them. We believe that data should be used for more than just making charts. This is why we invented integrations that work directly from cloud data warehouses. About The Team: The ETL team is at the heart of Census, tackling exciting challenges and pushing the boundaries of what's possible! We own the core platform that backs Census' sync engine. We are responsible for keeping our customer data flowing smoothly - on time, every time. We design and implement projects like our recent Sync Tracking overhaul - enabling us to capture, store, and process huge datasets, giving customers complete visibility into what data is flowing through our pipes; providing the capability to verify that every record is getting where it needs to go. We manage a constantly scaling and resizing fleet of machines to handle the dynamic needs of our customers, so one could call us the shadow infrastructure team as well. What You Do: Make valuable contributions to the deepest recesses of our tech stack - including writing typesafe Ruby and Rails with Sorbet, building performant Kotlin microservices, managing highly available Spark clusters, working on deterministic Temporal workflows, and Terraforming all the things in AWS. Think in Parquet, live in cloud storage, and have data flowing through your veins. Operate in hostile territory on all sides-building and managing a data diffing ETL engine that operates across every type of data warehouse and SQL dialect imaginable on data you don't own or control, and send it to countless permutations of destinations that could respond any number of unpredictable ways. Be a reliable and steadfast operator, participating in the team on-call rotation to help diagnose, triage and fix performance bottlenecks and gnarly edge-cases our customers discover. You'll leave the campsite cleaner than you found it. Work closely with our product team to help design and develop new features to improve data pipeline observability and debuggability, putting you on a first name basis with the data teams of many companies you have come to love and respect. Inform much of our early culture and be part of creating a truly special team. What We're Looking For: Technical Proficiency Expertise in at least one interpreted language such as Python, Ruby on Rails, etc. Expertise in at least one compiled language such as C++, Kotlin, Scala, Go, Java, etc. Solid understanding of relational databases (experience with data warehousing solutions (e.g., Snowflake) is a bonus) Proven experience in system integration, including API consumption and development (experience with infrastructure management is a bonus) Familiarity with leading cloud providers, such as GCP, AWS, or Azure Experience being on-call Autonomous and Self-Motivated - thrives in a high-trust environment, driving projects forward and making independent decisions with confidence Adaptable and Resilient - comfortably navigates ambiguity and views challenges as opportunities for growth Driven and Persistent - maintains a strong focus on goals, confidently overcoming obstacles and eagerly seeking innovative solutions to exceed expectations Able to work in-person in the Census SF or NY office 2-3 days a week Compensation Salary $180,000 - $230,000 Our Benefits Meaningful equity (we mean it!). We're going to ask you to work hard and build an amazing company, so we are going to pay you well while we build, and set our sights on your equity having real value We want you to take care of yourself, medical, dental, and vision plans are heavily subsidized for you, AND for your qualifying dependents Investing in your future can be expensive so we want to help, their is a company match for 401K/Pensions Flexible work schedule & unlimited PTO Growing family? Amazing! 12 weeks of fully paid parental leave. Annual All-Hands Offsite - hangout with your work-friends and make some memories! All the tools you need to do your best work. We believe the best companies bring together diversity in race, age, physical and mental ability, sexuality, gender identity, ethnicity, perspectives, and ideas. People do their best work when they feel like they are included, valued, and equal - when they feel like they belong. The Census we are building is a place where everyone brings their full selves to work knowing that they'll be heard, championed, and supported to succeed. Come and join our Census flock! What are you waiting for? Apply ↓

Created: 2024-11-05