Business Intelligence Architect

Overview Job Title: Technical and Business Intelligence Architect Location: Sacramento, CA, 2-3 days/Weekly Hybrid Job Type: Long-term Contract About R Systems: R Systems is a global leader in technology and analytics services, delivering innovative solutions to drive digital transformation across industries like Telecom, Banking, Healthcare, and Public Services. With over 4,400 professionals in 25+ countries, we are committed to helping our clients achieve operational excellence and enhanced customer experiences. We are proud to be Great Place to Work Certified in 10 countries, including India, the USA, Canada, and more. Our vibrant team culture fosters collaboration, innovation, and growth, making R Systems a fantastic place to work. Join us in creating impactful solutions and advancing technology for a better tomorrow. Background The client is pursuing multiple initiatives in support of Digital Transformation, including BI and Data Warehouse capabilities, Generative AI initiatives, cloud adoption where feasible, migration of applications to a cloud data center, and modernization of pension administration systems to replace legacy systems. The candidate will provide technical expertise assisting the client with BI/DW implementation, working with a future BI/DW Implementation Contractor, and collaborating with the client’s staff to provide knowledge transfer. Responsibilities Provide technical expertise assisting the client with BI and DW implementation. Coordinate with any future BI and DW Implementation Contractor during the project. Work alongside the client’s staff to provide knowledge transfer. Minimum Technical Qualifications At least 10 years of hands-on experience with full life cycle of Data Warehouse technical design and development including logical and physical data modeling, mapping data elements from various data sources and loading Data Warehouse objects including dimensions, hierarchies, fact tables, and aggregates, building the Reporting Metadata layer, as well as building the reports. At least 5 years of experience spanning at least two IT disciplines, including technical architecture, network management, application development, middleware, database management or operations. At least 5 years of hands-on experience in architecture design and implementation of business intelligence and predictive analytics on cloud-based Data Warehouses. At least 3 years of using DevOps tool chains and processes. At least 1 year experience of Generative AI architecture design and AI application development. Desirable Technical Qualifications 10 years of experience of data warehousing like: SQL Server, Snowflake, and/or AWS Redshift. 3 years of experience of using ETL tools like Informatica, AWS Glue, or Talend. 3 years of experience of Microsoft Power BI or Tableau. Cloud Architect certifications and AI certifications. The client may request a copy of the certifications. Bachelor’s degree in computer science or related technical field. The client may request a copy of the degree. The proposed project person will be able to adhere to the hybrid working model by working on-site 2–3 days per week at the client’s Headquarters, West Sacramento, CA. Why Join Us? Innovative Environment: Work on impactful public sector projects that drive technological advancements. Competitive Compensation: Receive a competitive salary and benefits package that reflects your expertise. Professional Growth: Enjoy opportunities for career development, certifications, and continuous learning. Flexible Work Arrangement: Benefit from a hybrid work model that supports both remote and on-site work. Seniority level Mid-Senior level Employment type Full-time Job function Information Technology Industries IT Services and IT Consulting #J-18808-Ljbffr

Created: 2025-09-17