Location: Hybrid – Denver, CO or Minneapolis, MN (Onsite 1 day per week)
Employment Type: Full-Time Consultant
Are you an experienced Data Warehouse Architect ready to make an impact on large-scale modernization initiatives? Trissential is hiring a Data Warehouse Architect to join our client’s team and support a major Customer Information System (CIS) Transformation effort. This is a high-visibility role where you’ll shape data architecture standards, optimize data movement, and enable a Customer 360 view across hybrid cloud environments. If you thrive in collaborative, agile teams and want to work with cutting-edge technologies like AWS, Databricks, and Salesforce, this is your opportunity!
What’s in It for You?
- High-Impact Projects – Drive architecture for CIS modernization and customer data integration across enterprise systems
- Modern Tech Stack – Work with AWS native services, Databricks, and advanced data lakehouse architectures
- Collaborative Culture – Join a highly supportive, agile team environment with strong peer partnerships
- Professional Growth – Expand your expertise in data governance, modeling, and hybrid cloud solutions
Your Role & Responsibilities
- Provide data architecture oversight for CIS modernization, including migration, conversion, and integration patterns
- Design and optimize data models for operational and analytical use cases aligned with Customer 360 initiatives
- Define data governance standards to ensure accuracy, minimize replication, and align systems of record
- Collaborate with database engineers to implement solutions across AWS Aurora, Databricks, and on-prem systems
- Work closely with internal teams and external vendors (Franklin, GridX) to ensure seamless data integration
- Deliver architecture artifacts and diagrams using industry-standard tools
Skills & Experience You Should Possess
- 8–10+ years of experience in data architecture and solution design
- Strong expertise in AWS native services and data lakehouse architectures
- Proficiency with Databricks and modern data platforms
- Advanced data modeling skills and experience creating data products
- Familiarity with Salesforce and/or SAP data models
- Experience with Agile/Scrum methodologies and tools like Jira and Confluence
- Excellent communication, documentation, and diagramming skills
Bonus Points If You Have
- Experience in utility, energy, or telecom industries
- Knowledge of data movement connectors and integration platforms
- Architecture certifications (AWS, TOGAF)
Education & Certifications You Need
- Bachelor’s degree in Computer Science, Information Systems, or related field
- Certifications are preferred but not required
What We Offer
At Trissential, we value expertise, innovation, and collaboration. By joining our client’s team, you’ll work on high-impact projects while enjoying a supportive work environment.
- Competitive Compensation – You choose the model that works best for you, both with company-sponsored benefits! $173,000–$193,000 annually or $100–$110 per hour, depending on your skills, experience, and location. Final compensation is determined based on skill alignment, years of experience, and fair, market-based rates by geography.
- Comprehensive Benefits for you and your dependents – Medical, dental, vision, free tele-health, HSA with company contribution, life and disability insurance, and 401k with matching
- Paid Time Off – Both compensation models offer paid time away from work
- Hybrid Work Model – Onsite in Denver or Minneapolis 1 day per week
- Career Development – Access to training, certifications, and leadership opportunities
- Supportive Team Culture – Work with a team that values continuous learning and growth
Please note: This role is only open to candidates authorized to work in the U.S.
Ready to architect the future of data? Apply today and take the next step in your career as a Data Warehouse Architect with Trissential!
