Data Warehouse Architect
About The Position
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
Requirements
- 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
Nice To Haves
- Experience in utility, energy, or telecom industries
- Knowledge of data movement connectors and integration platforms
- Architecture certifications (AWS, TOGAF)
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
Benefits
- 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
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
Mid Level
Industry
Professional, Scientific, and Technical Services
Number of Employees
101-250 employees
