Associate Principal Consultant

Associate Principal Consultant locations North Wales, PA time type Full time posted on Posted 10 Days Ago job requisition id R-105084 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.