Systems Architect - Data Warehouse Architect
About The Position
Reporting to the System Director of Data Architecture and Enablement, this role provides leadership in the technical design, strategic development, implementation, enhancement, and operation of Minnesota State Colleges and Universities' centralized repository of data assets. This position is tasked with architecting and maintaining an efficient, scalable, and modern enterprise data warehouse that supports business intelligence, advanced analytics, and compliance reporting, empowering data-driven decision-making across the system. The Data Warehouse Architect establishes and enforces standards and best practices for data architecture, evaluates and recommends technologies to meet evolving business needs, and drives strategic planning for a modern data warehouse infrastructure. This infrastructure integrates diverse data sources (structured, semi- structured, and unstructured) and leverages various tools and platforms to deliver robust data solutions. In collaboration with stakeholders, business leaders, enterprise application developers, and data analysts, this position ensures that the enterprise data warehouse serves as a reliable, actionable foundation for analytics and reporting initiatives, fostering a culture of data-driven enablement across the organization.
Requirements
- Six (6) years of experience at the enterprise level while demonstrating increased technical competency in data architecture; a bachelor's degree may substitute for one (1) year of professional experience.
- Demonstrable advanced knowledge and experience in database design and management, data modeling, data governance, ETL, data warehousing, data integration, cloud platforms, business intelligence and analytics, metadata management, and performance optimization.
- Proven experience leading enterprise-wide data warehouse implementation in a Data Warehouse Architect role with demonstrably successful results.
- Demonstrated commitment to working with diverse clients, stakeholders, and students, fostering a diverse working and learning environment.
Nice To Haves
- Master's degree in information systems or a related field
- Experience in data architecture, that demonstrates the advance knowledge of data architectural theory and practice needed to provide technical leadership and lead the design and development of effective and reliable statewide data warehouses, lakes, and structures.
- Higher education experience in a large, multi-campus, distributed higher education system.
- Experience with Azure SQL Database, Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Azure SQL Data Warehouse, and Azure Analysis Purview
Responsibilities
- Provides leadership in the technical design, strategic development, implementation, enhancement, and operation of Minnesota State Colleges and Universities' centralized repository of data assets.
- Architects and maintains an efficient, scalable, and modern enterprise data warehouse that supports business intelligence, advanced analytics, and compliance reporting.
- Establishes and enforces standards and best practices for data architecture.
- Evaluates and recommends technologies to meet evolving business needs.
- Drives strategic planning for a modern data warehouse infrastructure.
- Integrates diverse data sources (structured, semi- structured, and unstructured) and leverages various tools and platforms to deliver robust data solutions.
- Ensures that the enterprise data warehouse serves as a reliable, actionable foundation for analytics and reporting initiatives.
Benefits
- Low-cost medical and dental insurance with affordable deductibles
- Employer-paid life insurance
- Short- and long-term disability
- Pre-tax healthcare and dependent care accounts with a roll-over option
- Confidential Employee Assistance Program (EAP) for mental health, legal, and financial counseling
- 12 paid holidays
- Generous vacation and sick time
- Six weeks of Paid Parental Leave
- Pension Plan
- 457(b) and 403(b) retirement accounts
- Various investment options
- Dedicated professional development
- Tuition waivers for both you and your dependents
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
