Data Warehouse Specialist

R Systems; Sacramento (CA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

R Systems is looking for a senior data/BI engineer to drive enterprise BI and data warehouse initiatives in a hybrid setting. You will lead a team, design scalable data models, and integrate AI/GenAI capabilities into analytics platforms.

We expect 10+ years in data/BI, 5+ years leading teams, and hands-on with Snowflake, Redshift, Airflow, dbt, and major BI tools. Hybrid work is available with onsite presence in West Sacramento, CA.

Qualifications

• 10+ years in data/BI engineering or analytics.
• 5+ years leading a team of at least 3 members.
• 5+ years with AI/ML or GenAI technologies.
• 2+ proven deliveries of production-grade BI or data products.
• 2+ years with ETL/ELT, Snowflake/Redshift, and orchestration tools.
• 2+ years using OpenAI APIs or similar LLM platforms for analytics.
• 2+ years of SQL, data modeling, and hands-on BI tool experience.
• 2+ years leading analysts/developers with stakeholder collaboration.

Responsibilities

• Lead a team of analysts and developers to translate requirements into BI solutions.
• Deliver enterprise BI and data warehouse projects with production-grade quality.
• Oversee ETL/ELT pipelines and data modeling for analytics platforms.
• Collaborate with stakeholders to capture and implement data requirements.

Skills

Data engineering

BI leadership

AI/ML knowledge

SQL performance tuning

Prompt engineering

Team collaboration

OpenAI APIs

Data modeling

Education

Bachelor’s degree in CS/CE or related field

Tools

Snowflake

Amazon Redshift

Airflow

dbt

Power BI

Tableau / Looker

Job description

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.

Minimum Technical Qualifications

1. At least ten (10) years of experience in data/BI engineering or analytics.

2. At least five (5) years of experience in leading a team (at least 3 members) to implement enterprise-level BI and/or large data warehouse solutions.

3. At least five (5) years of experience working with AI/ML or GenAI technologies.

4. At least two (2) proven deliveries of production-grade BI or data products (dashboards, data models, APIs).

5. At least two (2) years of experience with ETL/ELT pipelines, data warehousing platforms such as Snowflake, Amazon Redshift, and orchestration tools (Airflow, dbt, etc.).

6. At least two (2) years of experience using OpenAI APIs or similar LLM platforms, building natural language to SQL/query systems, designing prompt strategies for business insights and analytics, and prompt engineering to guide the platform's system behavior.

7. At least two (2) years of experience in SQL (advanced joins, window functions, performance tuning), data modeling (star/snowflake schemas, semantic layers), and hands-on experience with at least one major BI tool such as Power BI, Tableau, Looker.

8. At least two (2) years of experience leading a team of analysts and developers, as well as collaborating with stakeholders, to discover, document, and implement requirements and stakeholder requests for data warehouse or business intelligence projects.

Desirable Technical Qualifications

• Holding technical certifications in the areas of:
• AWS certifications
• Snowflake certifications
• BI certifications (Power BI, Tableau)
• AI/ML or GenAI-related coursework or credentials
• Have a bachelor’s degree in computer science, computer engineering, or related fields from an accredited or government sanctioned college/university. Client may request a copy of the diploma/degree.
• The proposed onsite project person will be able to adhere to the hybrid working model by working on-site 2 to 3 business days per week at Client 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.