← Back to jobs

Senior Software Engineer - Semantic Layer

fivetran

Bengaluru, Karnataka, India, APAC
Development

Job Score

80 pts
On-site model (+70) Development (+10)

From Fivetran’s founding until now, our mission has remained the same: to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonical and ready to query, with no engineering or maintenance required. We’re proud that more organizations continue to leverage our technology every day to become truly data-driven.

About Us

Fivetran and dbt Labs are bringing together two industry-leading companies with a shared mission: helping organizations unlock the full value of their data. Together, we’re delivering the data infrastructure layer that helps organizations move, transform, and trust their data — from the moment data moves, through every transformation, to the context teams and AI systems rely on. Fivetran helps organizations automate data movement across the systems, clouds, engines, and tools they rely on. dbt Labs pioneered analytics engineering, helping teams transform data into reliable, governed insights. Together, we support thousands of organizations as they build a trusted foundation for analytics, AI, and better business decisions.

As we bring our teams and technology together, we’re building on the strengths of both companies while continuing to deliver the products and experiences our customers know and trust. It’s an exciting time to join us: we’re creating a company with the scale, talent, and technology to help more organizations put their data to work with greater speed, confidence, and impact. During this transition period, you may see references to both Fivetran and dbt Labs throughout our recruiting process as we integrate our teams, systems, and career sites.

About the Team

The Semantic Layer team owns the systems that turn dbt models into trusted, reusable business metrics. At the heart of this is MetricFlow — the open-source semantic engine that powers the dbt Semantic Layer. MetricFlow lets data teams define metrics once in code and consume them consistently across BI tools, notebooks, AI agents, and downstream applications.

This team is the steward of MetricFlow as an open-source project: shipping releases, reviewing community contributions, evolving the query compiler, and ensuring it integrates cleanly with the broader dbt ecosystem. You'll work at the intersection of language design, query compilation, and distributed data execution — solving problems that directly shape how thousands of organizations measure their business.

About the Role

We're hiring a Senior Software Engineer to join the Semantic Layer team in Bangalore. You'll be a core contributor to MetricFlow — designing features, optimizing query generation, hardening the open-source codebase, and partnering with the community of contributors and adopters around it. This is a high-ownership role: you'll write production code, drive technical decisions, and help shape the long-term architecture of one of the most important projects in the modern data stack.

What You'll Do

  • Design, build, and maintain core features of MetricFlow, including metric definitions, query compilation, dimensional modeling, and SQL generation across multiple data warehouses (Snowflake, BigQuery, Databricks, Redshift, and others).
  • Own MetricFlow as an open-source project — triage issues, review external pull requests, manage releases, and engage the community on GitHub and in Slack.
  • Collaborate with engineers across dbt Cloud, dbt Core, and the Semantic Layer service to ensure MetricFlow integrates seamlessly with the rest of the dbt ecosystem.
  • Improve performance, reliability, and observability of metric query execution at scale.
  • Partner with product, design, and developer-relations teammates to translate customer and community feedback into shipped improvements.
  • Write clear technical documentation, RFCs, and design docs that raise the bar for how the team thinks and ships.
  • Mentor other engineers through code review, pairing, and technical guidance.

Skills We're Looking For

  • Strong professional software engineering experience, with a strong track record of shipping production systems.
  • Deep proficiency in Python, including modern typing, testing practices, and packaging.
  • Strong SQL fundamentals and a working understanding of how analytical query engines and data warehouses execute queries.
  • Experience designing systems that involve parsing, compilation, or transformation — for example: query planners, DSL compilers, type systems, or rule-based engines.
  • Solid grasp of software design principles: clean APIs, modularity, testability, and backwards compatibility.
  • Excellent written and verbal communication — you can explain complex tradeoffs clearly to engineers, PMs, and external community members.
  • Experience collaborating in a distributed, asynchronous team environment.

Nice to Have

  • Prior experience contributing to or maintaining a popular open-source project.
  • Familiarity with dbt, MetricFlow, LookML, Cube, or other semantic-layer technologies.
  • Background in data warehousing internals, query optimization, or analytical SQL dialects.
  • Experience with CI/CD, GitHub Actions, and release engineering for Python libraries.
  • Exposure to building developer-facing APIs, SDKs, or CLIs.

Why Join Us

  • Impact at scale: Your code will run inside the data platforms of tens of thousands of companies, including some of the world's largest enterprises.
  • Open-source ownership: You'll be a public, named maintainer of a foundational project — your work is visible, reviewed, and used by the global data community.
  • A team that values craft: We invest in design docs, code review, and durable engineering. We ship fast, but we don't ship sloppy.
  • Competitive compensation: Market-leading salary, equity, comprehensive health insurance, generous time off, learning & wellness stipends, and home-office support.

#LI-HYBRID

#LI-SA1

 

Perks and Benefits

  • 100% employer-paid medical insurance*
  • Generous paid time-off policy (PTO), plus paid sick time, inclusive parental leave policy, holidays, and volunteer days off
  • RSU stock grants*
  • Professional development and training opportunities
  • Company virtual happy hours, free food, and fun team-building activities
  • Monthly cell phone stipend
  • Access to an innovative mental health support platform that offers personalized care and resources in areas such as: therapy, coaching, and self-guided mindfulness exercises for all covered employees and their covered dependents.

*May vary by country and worker type - please reach out to your recruiter for more information

Click here to learn more about Fivetran's Benefits by Region.


We’re honored to be valued at over $5.6 billion, but more importantly, we’re proud of our core values of Get Stuck In, Do the Right Thing, and One Team, One Dream. Read about us in Forbes.     

Fivetran brings together high-quality talent across the globe to make data access as easy and reliable as electricity for our customers. We value and recognize that our customers benefit from having innovative teams made of people from many backgrounds, experiences, and identities. Fivetran promotes diversity, equity, inclusion & belonging through attracting, recruiting, developing, and retaining a diverse workforce, not only because it is the right thing to do, but because it helps us build a world-class company to better serve our customers, our people and our communities.

To learn more about Fivetran’s culture and what it’s like to be part of the team, click here and enjoy our video.

To learn more about our candidate privacy policy, you can read our statement here.


We are committed to ensuring that all candidates have an equal opportunity to participate in our interview process. If you require accommodations at any stage of the process due to a disability, medical condition, or any other circumstance, please don't hesitate to submit your request by filling out this form. We will work with you to provide reasonable accommodations to facilitate your participation and ensure a fair and accessible interview experience. Your request and any information provided will be kept confidential and will not impact your candidacy. We look forward to hearing from you and accommodating your needs to the best of our ability.

About Software Development

Software Development is one of the most dynamic and constantly evolving fields in the job market. Professionals in this area are responsible for creating, maintaining, and optimizing web, mobile, and desktop applications that impact millions of users daily.

Key languages and frameworks include JavaScript (React, Node.js, Vue.js), Python (Django, Flask), Java (Spring), PHP (Laravel), and TypeScript. Demand for full-stack developers continues to grow, especially in tech companies and startups.

Salaries range from entry-level to senior positions, with growing opportunities for remote work and international freelancing.

Discover Other Areas

Understand the scope of work, key skills, and tools used in different career areas.

About Web Designer

The Web Designer is the professional responsible for creating visual interfaces for websites, web applications, and landing pages, combining aesthetics, usability, and user experience. They transform business needs into functional and responsive layouts that communicate brand identity.

Key skills include UI design, responsive design, prototyping (Figma, Sketch, Adobe XD), wireframing, design systems, accessibility (WCAG), information architecture, and basic HTML/CSS knowledge. Knowledge of UX design, motion design, and front-end is a differentiator.

Web Designers in technology companies are highly valued, especially those who master design systems, design tokens, and can create interfaces that convert and engage. The field offers opportunities from junior web designer to product designer and design lead.

About Mobile Development

Mobile Development is one of the most dynamic and constantly evolving fields in the technology market. With billions of smartphones worldwide, the demand for qualified mobile developers continues to grow exponentially.

Key stacks include Flutter (Dart), React Native (JavaScript/TypeScript), Kotlin (Android native), Swift (iOS native), and hybrid frameworks like Ionic and Capacitor. Knowledge of mobile architecture (MVVM, Clean Architecture), mobile CI/CD (Fastlane, Bitrise, Codemagic), and App Store/Google Play publishing are essential.

Senior mobile developers are highly valued professionals, with competitive salaries and many remote work opportunities at international companies. Specializing in cross-platform or native is a strategic career decision.

About Branding

Branding is the area responsible for building, managing, and strengthening a brand's identity and market value. Branding professionals create strategies that define how the brand is perceived by the public, from the logo to the complete customer experience.

Key skills include brand strategy, visual identity, brand guidelines, positioning, naming, brand voice, market research, brand equity, and brand management. Knowledge of graphic design (Figma, Illustrator, Photoshop), storytelling, and brand experience is a differentiator.

Branding professionals in technology companies are highly valued, especially those who master employer branding, digital branding, and can build strong, memorable brands in competitive markets. The field offers opportunities from brand designer to head of brand, with a focus on identity, differentiation, and perceived value.

About Agile

The Agile and Digital Transformation area is fundamental for organizations seeking efficiency and rapid adaptation. Agile professionals facilitate processes, eliminate bottlenecks, and promote a culture of continuous improvement.

Key certifications include CSM, PSM, SAFe, ICP, and Kanban. Knowledge of Scrum, Kanban, XP, and agile frameworks is essential, as are leadership and facilitation soft skills.

Senior Agile coaches and Scrum Masters are highly valued, especially in technology companies that adopt agile methodologies at scale.

About Data

The Data field has undergone a radical transformation with the rise of Generative AI. Data professionals are fundamental for evidence-based decision-making across all industries.

Key specializations include Data Engineering, Data Science, Business Intelligence, Machine Learning Engineering, and Analytics. Tools like SQL, Python, Spark, dbt, and cloud platforms (AWS, GCP, Azure) are essential.

The data market continues with high demand and salaries among the most competitive in the technology sector, with many remote work opportunities.

Career Guides

Technology Career Guide

Planning, skills, interviews, and professional growth in IT, Data Science, DevOps, and Product.

Read full guide →

Design Career Guide

UX/UI, Graphic Design, Product Design. Portfolio, tools, interviews, and growth in the Design field.

Read full guide →

Marketing Career Guide

SEO, Paid Media, Growth, Content Marketing. Certifications, tools, and strategies to grow in Digital Marketing.

Read full guide →

Finance Career Guide

Financial market, investments, corporate finance, certifications, and strategies to grow in the financial field.

Read full guide →

Communication Career Guide

Journalism, PR, Corporate Communication, Content Marketing, and Multimedia Production.

Read full guide →

Administration Career Guide

Business Management, HR, Logistics, Consulting, Project Management, and Entrepreneurship.

Read full guide →

Data Career Guide

Data Science, Data Engineering, BI, Machine Learning, and AI. From training to the job market.

Read full guide →

Product Career Guide

Product Management, Product Ownership, Agile, Scrum, and OKRs. From strategy to execution.

Read full guide →

Tech & Remote Glossary

Stop getting lost in interviews and job descriptions

The job market, especially within tech and global companies, has developed its own dialect. Not understanding these acronyms can make you lose valuable opportunities or poorly negotiate your contract. To end this problem, we created the Definitive Glossary for the Remote Professional.

🏢 Work Models & Routine

Async (Asynchronous Work)
A communication model where responses don't need to be immediate. Instead of back-to-back meetings, the team relies on well-structured documents, threads, and messages. It's the gold standard for global companies spanning multiple time zones.
Sync (Synchronous Work)
The opposite of Async. It requires the team to be online and available at the same time for meetings, live chats, and real-time collaboration.
Daily / Stand-up
A quick daily meeting (usually 15 minutes) common in Agile (Scrum) methodologies. The team answers three questions: What did I do yesterday? What will I do today? Are there any blockers?
All-Hands / Town Hall
A company-wide meeting involving all employees. Usually led by the founders (C-Levels) to present results, new goals, and answer team questions.
1:1 (One-on-One)
A recurring individual meeting between a professional and their direct manager. It is used for career alignment, feedback, and problem-solving, not just for project status updates.

💰 Contracts, Benefits & Compensation

PTO (Paid Time Off)
Instead of strict, categorized leave policies, modern US companies usually offer a flexible pool of days (e.g., 20 days of PTO, or even "Unlimited PTO") that you can use for vacations, sick days, or personal matters, while receiving your regular compensation.
Equity / Stock Options
Company ownership. The startup offers you the right to buy shares at a heavily discounted strike price in the future. If the company grows, goes public, or is acquired, these shares can be highly lucrative.
Vesting (Vesting Schedule)
The rule that controls your Equity. It usually lasts 4 years. You don't get all the shares on day one; you "earn" them gradually as you stay with the company. A "1-year Cliff" means you must stay for at least one year to receive your first batch of shares.
RSUs (Restricted Stock Units)
Unlike Stock Options (where you have the right to buy the stock), RSUs are actual shares the company grants you as a bonus or part of your compensation package, following a strict Vesting schedule.
Independent Contractor (1099 / B2B)
The most common international hiring model for global talent working for US companies. You act as a service provider (business-to-business), receiving the gross salary (often six-figure compensation) without standard local payroll tax deductions at the source.

🤖 Recruitment & Hiring Process

ATS (Applicant Tracking System)
The "robot" that reads your resume. Software like Greenhouse, Ashby, and Workday are used to filter candidates by keywords before a human even looks at the document. (Pro tip: this is why your resume must be clean, semantic, and have the right keywords).
JD (Job Description)
The document that lists the responsibilities, technical requirements, and benefits of the open position.
Cultural Fit
The interview stage that evaluates if your core values, communication style, and worldview align with the company's culture. This is the ultimate test of your Soft Skills.
Onboarding
The integration process. It's the period of your first few weeks at the company, where you get your access credentials, learn about the culture, study the internal documentation, and understand how the product works.

🚀 How to use this to your advantage?

The secret isn't just knowing what these acronyms mean, but using them actively. If during an interview for a premium tech role you ask, "How does your PTO policy and Vesting schedule work?", the recruiter will immediately perceive you as a high-level professional, familiar with the global market standards.

The remote job market requires preparation. And having the right vocabulary is the first big step to securing six-figure proposals and standing out among thousands of applicants.

Expert Tip

How n8n and Automation Open Doors to Premium Jobs

The Paradigm Shift in Web Development

The web development market has matured. A few years ago, mastering a traditional stack (like MERN or LAMP) was enough to secure a highly sought-after role. Today, the corporate landscape — especially in US startups hiring globally and offering six-figure compensation — demands speed and operational efficiency. It's no longer just about building from scratch, but knowing how to integrate complex ecosystems rapidly.

According to Gartner, hyperautomation is one of the top strategic technology trends of the decade. The modern developer must be an integration architect, capable of connecting CRMs, databases, AI APIs, and payment gateways in a matter of hours, not weeks. This is exactly where n8n becomes an indispensable tool in your portfolio.

Why n8n? The Power of "Fair-Code"

n8n is a node-based workflow automation tool. Unlike competitors aimed at non-technical users (such as Zapier or Make), n8n was designed with the developer in mind first. It allows raw JavaScript injection for complex data manipulation, custom HTTP requests, and, most importantly, features a fair-code licensing model that allows it to be self-hosted on a company's own infrastructure.

For technical recruiters and CTOs, a candidate who masters n8n demonstrates maturity. It proves that you understand SaaS cost reduction and value the security and sovereignty of the company's data.

Practical Tips to Land Your Next Role

If you want your resume to pass rigorous ATS (Applicant Tracking System) screening — like Greenhouse or Ashby — and reach the hands of Tech Leads, here are the core skills you should highlight when associating Web Development with n8n:

  • Mastery of Webhooks and RESTful APIs: The foundation of automation is system communication. Demonstrate your ability to create n8n workflows that listen to native Webhooks from your application (e.g., a checkout event in a Next.js e-commerce app) and trigger subsequent actions with low latency.
  • Hosting and Docker: n8n's biggest differentiator is self-hosting. In your resume, mention your ability to package and orchestrate n8n instances using Docker and Docker Compose. Familiarity with Cloud providers (AWS, GCP, or DigitalOcean) to deploy these instances is a massive bonus.
  • Advanced JSON and JavaScript Manipulation: Show that you don't rely solely on pre-built integrations. Using the "Code" node in n8n to transform large JSON payloads using raw JavaScript or TypeScript is what separates a regular user from an automation engineer.
  • Error Handling and Resilience: Systems fail. APIs go down. An amateur automation will break a company's process. In your portfolio, document how you use Error Trigger nodes to build automated retries and send alerts to Slack/Discord when an integration fails.

Your Portfolio is the Ultimate Proof

Just listing "n8n" in the skills section of your resume isn't enough. Create a repository on GitHub containing a real-world use case. For example: export the JSON file of an n8n workflow that reads new leads from a PostgreSQL database, enriches the data using the OpenAI API, and sends them to a CRM. Add a detailed README.md explaining the architecture. This is the ultimate bait for Senior roles.

References and Further Reading