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 staging, conformed, and curated warehouse layers in versioned SQL using incremental, declarative transformation patterns
- Recompute application-layer business logic, such as account balances and other derived values, as tested and versioned transformation logic
- Flatten and conform key-value/dimension-set source structures into standard dimensional attributes for reporting
- Capture spreadsheet and point-report formulas as reusable, versioned transformation logic in the curated layer
- Implement layered reconciliation and data-quality checks from replication integrity through report-level parity
- Enable downstream consumers, including the BI semantic model and reporting tools, against approved curated objects rather than raw source tables
- Participate in code review, CI/CD promotion, and automated regression testing within an engineered data SDLC
- Build the curated data layer and reconciliation logic for a large-scale Finance data platform modernization at a major US mortgage lender
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, including variance detection and exception handling
- Solid Git-based development workflow and CI/CD promotion experience (dev → test/UAT → production)
- Fluent English (B2) for 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, including ledger entries, chart of accounts, and dimension sets
- Nice to have: Experience in mortgage, lending, or financial-services data engineering
Benefits
Comp & perks- Health and dental insurance
- Meal and food allowance
- Childcare assistance
- Extended paternity leave
- Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass
- Profit Sharing and Results Participation (PLR)
- Life insurance
- Continuous learning platform (CI&T University)
- Discount club
- Free online platform dedicated to physical, mental, and overall well-being
- Pregnancy and responsible parenting course
- Partnerships with online learning platforms
- Language learning platform
- Health and Well-being team, inclusion specialists, and affinity groups
- Support and accommodations for people with disabilities
- Many more benefits