Jade Global

Associate Principal Consultant

North Wales, PA Full time
Associate Principal Consultant1

Spearhead the design and optimization
of end-to-end Order-to-Cash (O2C) data pipelines on Snowflake, dramatically improving query
performance and reducing processing times through advanced techniques like clustering,
partitioning, and query acceleration. Lead the deployment of AI-integrated O2C solutions for fraud
detection and predictive analytics, ensuring seamless integration with diverse customer and
payment systems. Expertly manage data consolidation across CRM, ERP, and finance systems,
implementing real-time validation and hybrid ingestion (batch/Snowpipe) to resolve fragmentation
and ensure data consistency. Design and develop robust ELT workflows in Snowflake, leveraging
Tasks, Streams, Procedures, and Fivetran for automated, incremental loads and precise financial
reporting, including Instructor Payment Reconciliation and Revenue Completeness. Define and
enforce comprehensive data governance frameworks, RBAC policies, and security best practices,
while providing technical leadership and ensuring seamless offshore coordination and project
execution.
Required: Bachelor’s degree or foreign equivalent Information Technology, Engineering or related
plus 3 years of experience in the job offered or related IT position.
Must have experience with: API Integration, Data Migration, Data Integration, Master Data
Management, Cloud Data Warehousing, Data Visualization, GIT, RestAPIs, Matillion, SQL, SSIS,
Python, Tableau, Azure DevOps, Snowpark, SAP Hana, IICS, Cognos 11, Profisee Master Data
Maestro Tool, SSRS, SSMS, PAF MatchCode Tool, Service Now, JIRA.