Associate Principal Consultant

Jade Global

North Wales, Pennsylvania

JOB DETAILS
SKILLS
Application Programming Interface (API), Artificial Intelligence (AI), Atlassian JIRA, Cloud Computing, Consulting, Customer Relationship Management (CRM), Data Management, Data Migration, Data Visualization, Data Warehousing, DevOps, ERP (Enterprise Resource Planning), Financial Systems, Git, IBM Cognos, Information Technology & Information Systems, Microsoft Windows Azure, Order to Cash, Predictive Modeling, Project/Program Coordination, Python Programming/Scripting Language, SAP, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ServiceNow, Snowflake Schema, Systems Administration/Management, Tableau, Technical Leadership
LOCATION
North Wales, Pennsylvania
POSTED
30+ days ago
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.

About the Company

J

Jade Global