Architect - Data EM

CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions--including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit www.cbts.com.

OnX is a leading technology solution provider that serves businesses, healthcare organizations, and government agencies across Canada. OnX combines deep technical expertise with a full suite of flexible technology solutions—including Generative AI, Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, OnX delivers comprehensive technology solutions for its clients’ transformative business initiatives. For more information, please visit www.onx.com.

Offshore Data Engineering Role that MUST work out of an approved Clean Room facility. This is a critical lead role responsible for managing and delivering key activities within the Enterprise Data Warehouse (EDW) Open Systems domain.

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Primary Offshore Contact for all open systems deliverables, reviews, clarifications, issue resolutions, and production fixes.
• Offshore Team Management: Oversee a team of 5+ members to ensure optimal resource utilization and productivity.
• Production Support: Address and resolve DataStage job-related production issues, escalations, and fixes promptly.
• Data Governance & Lineage: Respond to consumer queries regarding EDW data and provide clear data lineage clarifications.
• Technical Design & Development: Review and design DataStage requirements, including code changes and enhancements.
• Stakeholder Coordination: Collaborate with multiple consumers to finalize technical designs and conduct design reviews.
• DB-to-SF Pattern Enablement: Drive activities related to enabling the "Database to Snowflake" pattern and manage associated queries and escalations.
• Business Objects Reporting: Handle enhancements, queries, and clarifications related to Business Objects reports.
• Design Patterns & Performance Optimization: Work on DBT model standardization, reconciliation validations optimization, and performance improvements for Elevate and DBT jobs.
• Elevate Job Support: Manage production issues, escalations, and fixes for Elevate jobs.
• Legacy Modernization: Contribute to modernization efforts for legacy data products, including data modeling, design, and DBT model creation, while enabling legacy teams for future deliverables.
• Audit & Compliance Coordination: Coordinate and contribute to EDW audit and compliance-related analysis, clarifications, and activities.

PI67a083982fdd-30511-39326894