Experis
Job Title: Data Engineer
Location: Remote
Duration: 6Months
Pay rate:$ 53/hr on W2
Job Description
- Does the resource have to be Local: No
- Does this role have any *Visa Restrictions? None
- What type of education is needed for this position? Bachelors Degree of any IT related courses
- Work location : US Remote
- Will this role work remote/In Office/Hybrid: Remote
- Does this role require vaccination mandate? NA
- Will the client pay for travel and expenses? No
- Is industry experience needed for this role and why? 5+ years
- What are must-have skills for this role?
- 1. SQL
- 2. Data Engineering
- 3. Cost Allocation
- Years of experience required for each skill? 5
Responsibilities
- This engineer builds the data models that allocate, attribute, and distribute cloud costs to business dimensions, enabling showback and chargeback capabilities.
- 5-7 years of data engineering experience
- This is the most complex position from a business logic perspective. Building allocation rules, amortization calculations, and understanding how to model financial constructs requires both technical depth and domain experience. Ideally someone who has built chargeback/showback systems before.
Engineering Responsibilities
- Design allocation rule engine supporting tag-based, account-based, and custom mappings
- Build amortization models for upfront payments (1-year, 3-year commitments)
- Implement shared cost distribution models (proportional, even split, fixed coefficient)
- Create untagged cost attribution logic using account ownership and heuristics
- Build budget vs. actual variance models
- Design forecasting input models based on historical trends
- Ensure data models align with accounting periods and matching principles
Technical Skills required
- Expert SQL and dimensional modeling
- Experience building allocation and chargeback systems
- Understanding of FinOps cost allocation methodologies
- Data modeling tools (dbt, LookML, or similar)
- Understanding of financial accounting concepts (amortization, accruals)