FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Tech Stack
Tools & technologiesCloudSDLCSQL
About the role
Key responsibilities & impact- Build transformation logic across the warehouse's staging, conformed, and curated layers in versioned SQL, using incremental, declarative transformation patterns
- Recompute application-layer business logic, such as account balances and other derived values not present in raw replicated data, as tested, versioned transformation logic
- Flatten and conform key-value/dimension-set source structures into standard dimensional attributes for reporting
- Capture logic currently scattered across spreadsheets and point-report formulas as reusable, versioned transformation logic inside the curated layer
- Implement layered reconciliation and data-quality checks, from replication integrity through report-level parity
- Support downstream consumers, including the BI semantic model and other reporting tools, against approved curated objects rather than raw source tables
- Participate in code review, CI/CD promotion, and automated regression testing as part of an engineered data SDLC
Requirements
What you’ll need- Solid hands-on data engineering experience, including nontrivial SQL-based transformation work on a cloud data warehouse (Snowflake strongly preferred)
- Experience building dimensional/curated data models from normalized or application-native source structures
- Experience implementing or working within a reconciliation/data-quality framework (variance detection, exception handling)
- Solid Git-based development workflow and CI/CD promotion experience (dev → test/UAT → production)
- Fluent English (B2) — daily collaboration with a distributed engineering team and client stakeholders
- Nice to have: Experience with Microsoft Fabric, Power BI, or another enterprise BI platform as a downstream consumer
- Nice to have: Experience with financial/GL data modeling (ledger entries, chart of accounts, dimension sets)
- Nice to have: Experience in mortgage, lending, or financial-services data engineering
Benefits
Comp & perks- Premium Healthcare
- Meal voucher
- Maternity and Parental leaves
- Mobile services subsidy
- Sick pay-Life insurance
- CI&T University
- Colombian Holidays
- Paid Vacations