Associate Principal Consultant

Associate Principal Consultant North Wales, PA 1 DAYS AGO 22443718 Summary North Wales, PA $117811.00 - $117811.00 per Year 3 Years Experience Bachelor's degree No Commission 40.00 hours per week / Day Shift /Full-Time Description Associate Principal Consultant (North Wales, PA)

Duties:

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. Additional Details How To Identify Potential Job Scams