What are the responsibilities and job description for the Anaplan Integration Engineer position at Apetan Consulting?
Job Title - Anaplan Integration Engineer – BigQuery / Python / Enhancements & Support
Location – Duluth, GA (3days Hybrid)
Role Summary
We are looking for an experienced Anaplan Integration Engineer to support an existing enterprise integration landscape for a leading U.S. retail organization.
The current integration between Anaplan, Google BigQuery, and downstream custom applications is already implemented and operational.
The primary responsibility of this role will be to manage enhancements, change requests, interface modifications, production issues, data reconciliation, and continuous improvement across the existing integration ecosystem.
The candidate should have strong hands-on experience with Anaplan integrations, BigQuery, Python, SQL, REST APIs, and enterprise data integration, with the ability to quickly understand existing implementations and make changes without impacting downstream applications.
Key Responsibilities Enhancement & Change Management
• Analyze business and application enhancement requests impacting existing Anaplan integrations.
• Perform impact analysis across:
Anaplan → Integration Layer → BigQuery → Custom Applications
• Modify existing integrations based on changes to Anaplan models, business rules, or downstream application requirements.
• Enhance existing Anaplan exports, saved views, processes, and integration jobs.
• Update BigQuery tables, views, SQL logic, and transformation rules as requirements evolve.
• Manage schema changes while minimizing impact to consuming applications.
• Estimate effort and technical impact for enhancement and change requests.
Anaplan Integration Support
• Maintain and enhance existing integrations using:
o Anaplan Integration APIs
o Anaplan Imports / Exports
o Actions and Processes
o CloudWorks
o Existing integration scripts and frameworks
• Understand changes within Anaplan modules, lists, hierarchies, dimensions, line items, versions, and time structures.
• Work with Anaplan Model Builders to understand model changes and determine downstream integration impacts.
• Modify integration-specific views and exports where required.
Python Development & Automation
• Maintain and enhance existing Python-based integration components.
• Develop Python scripts for:
o API integration
o Data extraction
o Transformation
o Validation
o Reconciliation
o BigQuery processing
o File processing
o Automation
• Debug and modify existing Python code.
• Develop reusable utilities for new integration requirements.
• Improve error handling, logging, monitoring, and operational automation.
• Optimize existing code for performance and maintainability.
BigQuery Enhancements
• Maintain and enhance existing BigQuery datasets, tables, and views.
• Develop and modify BigQuery SQL based on new business requirements.
• Support changes to:
o Data mappings
o Transformation rules
o Source attributes
o Business hierarchies
o Planning measures
o Historical data
• Troubleshoot data discrepancies between Anaplan and BigQuery.
• Optimize queries and integration processing where required.
Custom Application Integration
• Work with custom application engineering teams consuming data through BigQuery.
• Understand new application data requirements and determine changes required in the existing integration.
• Maintain existing interface and data contracts.
• Ensure Anaplan changes do not inadvertently break downstream applications.
• Support the addition of new attributes, dimensions, measures, and datasets required by consuming applications.
• Participate in end-to-end testing across Anaplan, BigQuery, and downstream applications.
Production Support & Troubleshooting
• Investigate production data and integration issues.
• Perform root-cause analysis across:
o Anaplan
o Python integration layer
o BigQuery
o Downstream applications
• Resolve failed jobs, incomplete loads, data mismatches, and interface errors.
• Perform data reconciliation between source and target systems.
• Support incident, problem, and defect management.
• Implement permanent fixes and preventive improvements.
Retail Domain Context the role will support integrations within a large retail enterprise environment.
Experience working with data related to areas such as the following will be beneficial:
• Financial Planning
• Merchandise Planning
• Inventory
• Sales
• Forecasting
• Budgeting
• Stores
• Supply Chain
• Product Hierarchies
• Location Hierarchies
• Channels
• Business Units
The candidate should be comfortable understanding complex hierarchies and planning datasets commonly used within large retail organizations.
Mandatory Skills
• 5–8 years of overall integration / data engineering experience.
• 3 years of Anaplan experience with strong integration exposure.
• Strong hands-on experience with:
o Python
o Google BigQuery
o SQL
o REST APIs
o JSON / CSV
o ETL / ELT
• Experience supporting and enhancing existing production integrations.
• Working knowledge of:
o Anaplan Integration APIs
o Anaplan Imports and Exports
o Actions and Processes
o CloudWorks
• Ability to understand and modify existing Python code.
• Strong troubleshooting and root-cause-analysis skills.
• Experience performing source-to-target data reconciliation.
• Ability to perform impact analysis for integration changes.
Good-to-Have Skills
• Anaplan Data Orchestrator
• Google Cloud Storage
• Cloud Functions / Cloud Run
• Pub/Sub
• Dataflow
• Cloud Composer / Airflow
• Git
• CI/CD
• API Management
• Anaplan ALM
• Retail / Merchandise / Financial Planning domain experience
Anaplan Knowledge Expected the candidate does not need to be a dedicated functional Anaplan Model Builder but should understand:
• Models and Workspaces
• Modules
• Lists and Hierarchies
• Dimensions
• Line Items
• Time and Versions
• Saved Views
• Imports and Exports
• Actions and Processes
• Integration Security
• Model changes and their impact on downstream interfaces
Typical Activities the person should be comfortable handling requests such as:
• Add a new Anaplan attribute to an existing BigQuery feed.
• Add or modify planning measures consumed by a custom application.
• Modify existing Python transformation logic.
• Change an Anaplan export or saved view.
• Update source-to-target mappings.
• Modify BigQuery tables or consumption views.
• Support changes in product or location hierarchy.
• Troubleshoot missing or incorrect data.
• Reconcile Anaplan and BigQuery data.
• Resolve failed integration jobs.
• Assess downstream impact of an Anaplan model change.
• Support application testing after interface changes.
• Improve performance of existing integration jobs.
• Enhance logging, monitoring, and exception handling.
Preferred Skill Mix
30–35% – Anaplan Integration & Change Analysis
25–30% – Python / API Engineering
25–30% – BigQuery / SQL / Data Engineering
10–15% – Production Support & Retail Domain
Recommended Profile Positioning
Anaplan Integration Engineer – Python & BigQuery
This is primarily an enhancement and support role for an established integration ecosystem, rather than a greenfield architecture or implementation position.
The key expectation is the ability to understand an existing:
Anaplan → Python / Integration Layer → BigQuery → Custom Application
solution and independently deliver changes, enhancements, troubleshooting, reconciliation, and production fixes without disrupting existing business
-critical integrations.