Distinguished Data & Integration Architect
PowerSchool Group LLC2 months ago
Dallas, TX, USAStaff+
Responsibilities
- Advise the CTO, CIO, executive leadership, and board as appropriate on enterprise data strategy, integration architecture, risks, and technology investments.
- Define and own the enterprise-wide data and integration architecture vision and multi-year technology roadmap.
- Establish integration standards and patterns for batch, near-real-time, and event-driven architectures across ERP, CRM, HR, and SaaS systems.
- Provide architectural governance for large-scale initiatives such as Workday implementations and mergers and acquisitions system integrations.
- Define organizational standards for error handling, logging, monitoring, retry logic, performance, landing zones, transformation layers, and data modeling.
- Own the target-state data platform architecture using Microsoft Fabric and related Azure services.
- Ensure data ingestion pipelines align with enterprise integration architecture and support analytics, AI/ML, and product innovation.
- Define and champion enterprise data governance, including data domains, ownership, stewardship, metadata, lineage, cataloging, and classification.
- Lead the enterprise architecture review board and create reference architectures, design guidelines, and architectural decision records.
- Mentor senior architects and technical leads and influence architecture hiring standards, technical interviews, and career development pathways.
Requirements
- 15+ years of progressive experience in data architecture, integration architecture, or platform architecture, including at least 5 years at a principal, distinguished, or equivalent senior architecture level.
- Demonstrated experience setting enterprise-wide architectural vision and strategy that influenced business outcomes.
- Deep expertise designing enterprise integrations with iPaaS or middleware platforms such as Boomi across batch, near-real-time, and event-driven patterns.
- Deep expertise in modern data warehousing or lakehouse architectures and Microsoft data platforms such as Fabric, Synapse, SQL, or Power BI.
- Proven experience defining and implementing enterprise data governance frameworks and metadata management tooling such as Purview.
- Advanced SQL skills and working proficiency in at least one scripting or programming language, preferably Python.
- Experience with APIs, REST, JSON, and data transformation pipelines.
- Track record of influencing executive-level technology decisions and presenting to senior leadership.
Benefits
- Comprehensive medical, dental, vision, pharmacy, life insurance, and AD&D coverage.
- Flexible Spending Accounts and Health Savings Accounts.
- Short-term and long-term disability coverage.
- Comprehensive 401(k) plan.
- Generous parental leave.
- Unrestricted paid time off through Discretionary Time Off (DTO).
- Wellness program including ClassPass and an Employee Assistance Program.
- Tuition reimbursement.
- Optional pet insurance, identity theft protection, student debt repayment, and prepaid legal coverage.
About PowerSchool Group LLC
PowerSchool builds cloud software for K-12 school districts, spanning student information, learning management (Schoology), enrollment, assessments, analytics, special education, and HR/finance. It sells these products as SaaS to districts and state agencies to manage data, instruction, and operations across schools and families. Headquartered in Folsom, CA, PowerSchool supports over 60 million students at more than 18,000 customers, including over 90 of the 100 largest U.S. districts by enrollment.