What are the responsibilities and job description for the Data Warehouse Architect position at magnit-xcelenergy?
Data & Integration Architect
Position Summary
We are seeking an experienced Data & Integration Architect to lead the design, implementation, and governance of enterprise integration solutions supporting next-generation voice AI and contact center technologies. This role will be responsible for architecting secure, scalable integrations between enterprise systems, telephony infrastructure, CRM platforms, analytics environments, and cloud-hosted AI vendors.
The ideal candidate combines strong hands-on integration engineering experience with enterprise architecture expertise and can effectively collaborate across infrastructure, network, security, data engineering, and application teams. This individual will play a key role in evaluating and implementing voice AI platforms while ensuring seamless data access, transaction execution, analytics integration, and operational scalability.
Key Responsibilities
Design and govern end-to-end enterprise integration architecture supporting voice AI and contact center platforms
Lead integration efforts across telephony systems, CRM platforms, APIs, analytics environments, and cloud-hosted SaaS solutions
Architect and implement secure real-time integrations using REST APIs, GraphQL, webhooks, OAuth 2.0, mTLS, and event-driven patterns
Design and support batch and streaming data pipelines into enterprise analytics and reporting platforms
Partner with infrastructure, network, security, contact center, and data engineering teams to deliver integrated enterprise solutions
Serve as the primary technical liaison between internal technology teams and external vendors during platform evaluations, proof-of-value initiatives, and production deployments
Support competitive vendor bake-off processes by defining standardized integration environments, API contracts, testing criteria, and technical evaluation frameworks
Collaborate with architecture and engineering teams to ensure scalability, observability, resiliency, and compliance across all integrations
Support telephony and contact center integration initiatives including SIP connectivity, call routing, IVR integration, CTI integrations, and transfer workflows
Develop integration governance standards, documentation, and operational best practices
Assist with analytics data export, monitoring, troubleshooting, and continuous improvement initiatives
Ensure enterprise compliance standards related to security, data retention, privacy, and regulatory requirements are maintained
Minimum Qualifications
7 years of experience in integration architecture, data engineering, solution architecture, or related technical roles
Hands-on experience designing and implementing enterprise API integrations using REST, GraphQL, webhooks, and related technologies
Strong understanding of enterprise integration patterns including API gateways, OAuth 2.0, service accounts, mTLS, and event-driven architectures
Experience designing and implementing data pipelines for analytics and reporting platforms
Experience collaborating across cross-functional technical teams including network, security, infrastructure, data, and application engineering
Experience integrating enterprise CRM platforms, preferably Salesforce
Bachelor’s degree in Computer Science, Engineering, Information Technology, or related field (or equivalent experience)
Preferred Qualifications
Experience with SIP/VoIP telephony architecture including SBC configuration, SIP trunking, SIP/TLS, SRTP, and call routing
Experience integrating contact center platforms such as Avaya, Genesys, or similar technologies
Knowledge of IVR systems, CTI integrations, DTMF workflows, and call transfer patterns
Experience with Databricks, Snowflake, or similar lakehouse/data warehouse platforms
Experience with cloud networking concepts including VPC peering, private connectivity, firewall policy management, and IP allowlisting
Familiarity with observability and monitoring platforms such as Splunk, Datadog, Grafana, and OpenTelemetry
Experience with MuleSoft, Azure Integration Services, or similar enterprise integration platforms
Understanding of AI/ML integration patterns including model-serving APIs, conversation data exports, and feedback loop architectures
Experience working in regulated industries such as utilities, energy, or financial services
Knowledge of compliance standards including NERC-CIP, SOX, and enterprise PII handling practices
Additional Information
This position works closely with enterprise architecture, infrastructure, network engineering, security, contact center technology, and data engineering teams to support critical customer experience modernization initiatives. The role offers the opportunity to contribute to enterprise-scale AI and integration strategies within a highly collaborative technical environment.