Data Engineer - R01571442

Brillio
Bengaluru
Workplace: OnsiteFull timeFunction: Software EngineeringExperience: 5-8 yearsSkills: ["Communication","Documentation","Stakeholder collaboration","Quality validation","Reconciliation"]

Migrate pricing logic from a legacy Gold layer into governed, reusable dbt models in the Silver layer. You’ll reverse-engineer analyst SQL and spreadsheet logic, build maintainable and testable data models, and run parity validation by comparing migrated outputs against Gold results. Partner with pricing analysts to align on definitions and approvals, while documenting lineage, tests, and downstream impacts and decommissioning retired legacy logic.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Brillio
Brillio
20 hours ago

Data Engineer - R01571442

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 14 hours agoStatus: Live

Job Summary

Migrate pricing logic from a legacy Gold layer into governed, reusable dbt models in the Silver layer. You’ll reverse-engineer analyst SQL and spreadsheet logic, build maintainable and testable data models, and run parity validation by comparing migrated outputs against Gold results. Partner with pricing analysts to align on definitions and approvals, while documenting lineage, tests, and downstream impacts and decommissioning retired legacy logic.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Software Engineering
Seniority: Mid level

Key Responsibilities

  • •Identify custom pricing definitions and transformations by reverse-engineering analyst-written SQL, spreadsheet logic, and ad hoc calculations.
  • •Re-implement approved pricing logic as governed, documented dbt models in the Silver layer with modelling, naming, testing, version control, and code review standards.
  • •Run parity validation by comparing Silver-layer outputs to Gold-layer results and resolving differences across representative periods and edge cases.
  • •Collaborate with pricing analysts to clarify calculations, lead walkthroughs/reviews, and document analyst sign-off before retiring legacy definitions.
  • •Document logic meaning, assumptions, exceptions, source inputs, lineage, tests, and downstream consumers in dbt and Confluence, then decommission retired Gold-layer logic after cutover approval.

Key Requirements

  • •5–8 years of data engineering experience on analytical data platforms.
  • •Strong SQL skills including joins, window functions, CTEs, aggregations, and conditional logic.
  • •Hands-on experience with dbt, including models, tests, documentation, and lineage.
  • •Strong Snowflake experience including modelling, performance tuning, and warehouse concepts.
  • •Ability to refactor and migrate complex analytical logic, untangle ad hoc SQL/spreadsheet calculations, and validate outputs with strong data-quality and reconciliation practices.
Experience:5-8 yearsData engineeringAnalytical data platforms
Skills:CommunicationDocumentationStakeholder collaborationQuality validationReconciliation
Tech Stack:SQLPythonSnowflakeDbtDbt CloudAirflowConfluenceJiraSlack

Company Brief

Brillio
Provides digital transformation and IT consulting services, including cloud migration, analytics, digital engineering, and managed services to accelerate business outcomes for enterprises across industries.
Industry: Consulting
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Funding: Private Equity Backed
Headquarters: Santa Clara, United States
Founded: 2014
WebsiteLinkedIn