Data Architect Consultant (Azure stack) needed for a hybrid position in Orem, UT. Local candidates only
Duration: 6 months, with option to extend based on project needs
Location: On-site in Orem, Utah. Hybrid considered by mutual agreement.
Reports To: Principal Enterprise Architect
Overview
Our client is seeking a Senior Data Architect to provide enterprise data architecture, data modeling, and analytics design expertise supporting the University's data and business intelligence initiatives.
The consultant will partner with the Business Intelligence and Data Platform team, Enterprise Architecture, application owners, database administrators, and business stakeholders to build scalable enterprise data models, establish architecture standards, and strengthen the University's analytics capabilities.
Scope note: Our client is evaluating the future direction of its analytics platform through a Microsoft Fabric Proof of Concept while continuing to operate its existing Azure Synapse Analytics environment. This role provides enterprise data modeling and architecture guidance to support that work. The consultant is not responsible for leading or implementing the POC.
Responsibilities
Enterprise Data Architecture
Develop conceptual, logical, and physical enterprise data models
Design data architectures supporting reporting, analytics, and institutional decision making
Define canonical business entities and enterprise data domains
Establish modeling standards, naming conventions, and documentation practices
Evaluate existing data structures and recommend architectural improvements
Promote consistency and reuse across enterprise data assets
Data Modeling
Design dimensional models for analytics and reporting
Develop star and snowflake schemas where appropriate
Review and refine existing models for scalability and maintainability
Support reusable semantic data structures
Business Intelligence Collaboration
Partner with the BI and Data Platform team on enterprise analytics initiatives
Provide guidance on enterprise data structures and modeling approaches
Review data and semantic models
Assist with complex data design challenges
Data Integration
Recommend enterprise integration patterns
Support scalable ELT/ETL architecture design
Support integration between Banner ERP, enterprise applications, and analytics platforms
Enterprise Architecture
Align data architecture with Enterprise Architecture standards and governance
Participate in architecture reviews and technical design discussions
Produce architecture documentation and contribute to long-term data strategy
Knowledge Transfer
Mentor BI and Data Platform staff on enterprise data modeling
Document enterprise data standards and reference architectures
Deliver knowledge transfer sessions
Deliverables
Enterprise conceptual, logical, and physical data models
Enterprise data modeling standards and documentation
Reference architectures for enterprise data solutions
Dimensional models supporting reporting and analytics
Enterprise data integration pattern recommendations
Architecture review findings and design recommendations
Data architecture documentation and knowledge transfer materials
Mentoring and guidance for the BI and Data Platform team
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field
Minimum 7 years of enterprise data architecture experience
Expertise in conceptual, logical, and physical data modeling
Extensive dimensional modeling and enterprise data warehouse design experience
Strong SQL Server and T-SQL experience
Experience designing enterprise reporting and analytics solutions
Experience with Power BI semantic models or comparable technologies
Strong understanding of data governance and metadata management
Preferred Qualifications
Higher education experience
Ellucian Banner ERP
Azure Synapse Analytics
Familiarity with Microsoft Fabric
Azure Data Platform technologies
Microsoft Fabric or Azure data certifications
DAMA or equivalent data management practices
Experience modernizing enterprise analytics platforms
#techjobs
#LI-SK1
About Us
Advantage Technical connects top- talent in technology, engineering, and technical fields with forward-looking companies.
Advantage Technical is an equal opportunity employer. All applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other legally protected status. Advantage Technical offers reasonable accommodations for qualified individuals with disabilities; contact your local branch for inquiries. Advantage Technical is an E-Verify employer. See our Privacy Notice for Candidates and Employees/Contractors at By applying, you consent to receive AI-generated and non-AI-generated calls, texts, or emails from Staffmark Group, its affiliates, and partners. Frequency varies and message/data rates may apply. Reply STOP to cancel or HELP for help.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10118370
- Position Id: 2057599
- Posted 2 days ago
Never miss an opportunity! Create an alert based on the job you applied for.
