Alteryx Data Transformation / Migration Specialist Contract
Buxton Consulting
Buxton, United States
20 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source
Tech stack
Information Engineering
Data Governance
Data Mapping
Data Migration
Oracle (Applications)
Oracle Fusion Middleware
Data Import/Export
Macros
Core Data
Oracle Cloud Infrastructure
Alteryx
Job description
- We are looking for a Senior Data Migration & Transformation Consultant to be the hands-on Alteryx Subject Matter Expert in a complex data migration program driving billions in active recurring revenue.
- The project involves extracting property/leasing data from the Legacy ERP and transforming it into scalable subscription data models within Oracle Fusion Subscription Management.
- The primary challenge of this role is functional data engineering: translating real estate leasing structures (with diverse localized/geographic rules) into standardized, mid-lifecycle subscription records in Oracle without disrupting billing schedules or revenue recognition.
- You will be using Alteryx as the primary engine to design, optimize, and automate these multi-layered, high-volume transformation pipelines., * Mid-Lifecycle Data Engineering: Architect Alteryx pipelines that map active, mid-lifecycle Legacy ERP leases into Oracle Subscriptions. Workflows must accurately calculate and balance historical “already billed” revenue against remaining downstream contract values.
- Geographic & Regional Data Standardization: Design automated logic within Alteryx to handle distinct data variations, currency conversions, and tax implications across multiple global regions. Complex Data Mapping (Lease-to-Subscription): Translate Legacy ERP lease components (e.g., base rent, escalations, CAM charges, recovery structures) into Oracle Fusion Subscription products, pricing tiers, and billing schedules.
- High-Volume Alteryx Optimization: Build and optimize high-throughput Alteryx workflows (leveraging batch/iterative macros, in-DB processing, or chained apps) capable of handling massive transactional datasets with optimal performance.
- Automated Reconciliation Frameworks: Develop robust data quality and audit workflows in Alteryx that provide cell-level validation and tie back to the penny before pushing to Oracle FBDI (File-Based Data Import) formats.
- Cross-Functional Collaboration: Act as the strategic bridge between Finance/Accounting teams (who understand the revenue impact) and technical teams executing the final load.
Requirements
Required Experience & Technical Skills
- Lead Migration Experience: 7+ years of experience managing complex data migrations for large enterprise systems, specifically involving billions in revenue impact.
- Advanced Alteryx Mastery: Expert-level proficiency with Alteryx Designer. Must be highly skilled in building dynamic, reusable macros and handling massive volume optimizations.
- Leasing Data Familiarity: Strong understanding of Leasing business models and ERPs and their core data schemas, leasing modules, and financial tables is highly preferred.
- Oracle Fusion Subscription Knowledge: Basic experience with, or functional understanding of, Oracle Cloud/Fusion Subscription Management or Cloud Contracts modules.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…