BENGALURU · FULLTIME
Data Engineer - R01571442
Brillio
Bengaluru · onsite · Posted 28d ago
Sourced from
Not disclosed5–8 yrsfulltimeBengaluru
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.3s
- Found the form on Foundit · 6 questions to answer1.0s
- Decided the answers for all of them2.6s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Data Engineer
Job requirements
Key Responsibilities Logic Discovery And Requirements Analysis
Job requirements
Key Responsibilities Logic Discovery And Requirements Analysis
- Work with pricing analysts to identify custom definitions, calculations, transformations, dependencies, assumptions, edge cases, and ambiguities currently implemented in the Gold layer.
- Reverse-engineer analyst-written SQL, spreadsheet logic, and ad hoc calculations to define intended business behaviour.
- Translate legacy logic into clear technical requirements and migration plans.
- Re-implement approved pricing definitions as governed, reusable, documented dbt models in the Silver layer.
- Follow data modelling, naming, testing, version control, and code review standards.
- Build maintainable, scalable, auditable models independent of undocumented analyst knowledge.
- Apply dbt tests for uniqueness, not-null, accepted values, relationships, and business rules.
- Compare migrated Silver-layer results with existing Gold-layer outputs and resolve differences.
- Validate results across representative periods, segments, boundary conditions, and known exceptions.
- Confirm migrations only after parity review and pricing analyst approval.
- Partner with pricing analysts to clarify calculations, confirm intended behaviour, and align on expected results.
- Lead walkthroughs and reviews; document analyst approval before retiring legacy definitions.
- Communicate risks, open questions, dependencies, and decisions to technical and business stakeholders.
- Document business meaning, calculation rules, assumptions, exceptions, source inputs, ownership, lineage, tests, and downstream consumers in dbt and Confluence.
- Ensure documentation enables future engineers and analysts to maintain logic without relying on the original analyst.
- Decommission ad hoc Gold-layer logic after the Silver replacement is validated, approved, adopted, and downstream dependencies are updated.
- Verify retired logic is no longer used and operational documentation reflects the new source of truth.
- 5–8 years of data engineering experience on analytical data platforms.
- Strong SQL skills: joins, window functions, CTEs, aggregations, conditional logic, and optimisation.
- Hands-on dbt experience across models, tests, documentation, and lineage.
- Strong Snowflake experience, including modelling, performance tuning, and warehouse concepts.
- Experience refactoring, migrating, or modernising complex analytical logic.
- Ability to untangle ad hoc SQL and spreadsheet calculations and validate outputs.
- Strong understanding of data quality, reconciliation, testing, and release controls.
- Skilled at working with non-engineering stakeholders to clarify requirements and validate outcomes.
- Excellent communication and documentation habits.
- SQL; Python a plus
- Snowflake
- dbt, dbt Cloud
- Airflow
- Confluence, Jira, Slack
- Data modelling, quality validation, reconciliation, migration planning, stakeholder collaboration, and technical documentation.
Sourced from foundit
Section · 02
Skills
Slackquality validationConfluenceapache airflowdbtData modellingDBT CloudTechnical DocumentationPythonMigration planningJira AtlassianSQLSnowflakereconciliation
Section · Company
About Brillio
Brillio
IT Services & Consulting
3.7k+
employees
2014
12 years old
Dallas, US state of Texas
CU
About
Brillio offers comprehensive digital transformation services, focusing on customer experience, AI, and product engineering to drive business innovation.
Industries
IT Services & ConsultingAnalytics & KPO
Employee ratings
1,318 reviews
3.4/ 5
Culture
3.2
Career growth
2.8
Work-life
3.4
Employees rate it well for
Work Life Balance203Senior Management169Salary115Work Culture114Learning109
Find them on