Senior Data / Analytics Engineer

Title- Senior Data / Analytics Engineer GenAI & BI

Location- Sacramento, CA (hybrid/ 3days onsite)

Type- long term Contract-

Job Description-

Mandatory Qualifications:

• At least seven (7) years of experience in the Information Technology (IT) field with extensive experience in report writing, data analysis, or database querying.
• At least five (5) years of experience in data engineering, data warehousing, or BI analytics.
• At least two (2) years of experience with ETL/ELT pipelines, cloud data warehouses such as Snowflake, Amazon Redshift, Azure Synapse, and orchestration tools (Airflow, dbt, etc.).
• 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.
• At least two (2) years of hands-on experience in containerization and orchestration (Docker, Kubernetes), CI/CD pipelines for ML and data workflows, monitoring and logging for ML and BI systems, cloud infrastructure automation (Terraform, Ansible).

Desirable 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
• At least five (5) years of experience in front-end UX/UI design for analytics dashboards and highly interactive reporting.
• At least four (4) years of experience in development with React for or building scalable, highly customized production-grade user interfaces.
• At least two (2) years of experience in front-end development with Chainlit or Streamlit for AI/ML or GenAI solutions with complex state management & data handling (e.g., real-time updates; UI states for loading, retries, and partial responses).
• Experience and understanding in latency handling and async UX patterns, explainable AI interfaces (confidence, sources, disclaimers), and prompt design basics.
• Hands-on experience and proven ability to build chat interfaces (streaming responses, token handling), and AI-assisted workflows (autocomplete, summarization, recommendations).
• At least three (3) years of experience working with AI/ML or GenAI technologies.
• At least one (1) year of hands-on experience using OpenAI APIs or similar LLM platforms, building natural language to SQL/query systems, designing prompt strategies for business insights, and prompt engineering to guide system behaviour.
• At least three (3) years of experience in semantic layer design, data modelling, and delivering enterprise semantic models across multiple teams for large organizations.
• At least one (1) year of experience in developing semantic models supporting natural language querying and AI-driven analytics (i.e., GenBI); statistical analysis, predictive analytics, and optimization.
• Have a bachelor s degree in computer science, computer engineering, or related fields from an accredited or government sanctioned college/university.