Civis consultant - Jaipur - BOT Consulting

Description

We are seeking an experienced CIVIS Data Consultant to support data warehousing and integration initiatives in the company.

The ideal candidate brings strong hands-on experience with Civis data warehousing, SQL, database modelling, and ETL tools, along with the ability to operate as a client-facing consultant.

This role requires both technical depth and business-analyst-like skills, enabling the consultant to work independently, engage stakeholders, and propose effective data solutions.

Key Responsibilities:
Data Warehousing & Platform Expertise

• Design, develop, and support data warehousing solutions on the Civis platform, leveraging its Redshiftbased architecture.
• Perform SQLbased data analysis, transformations, and optimizations to support reporting and analytics needs.
• Develop and maintain database models, ensuring data accuracy, scalability, and performance.

Data Integration & ETL

• Build and manage data integrations and ETL workflows, primarily using Informatica (or similar ETL/middleware tools).
• Support integrations with Azurebased systems, understanding data flows, processing pipelines, and connected applications.
• Troubleshoot and resolve data pipeline issues independently, ensuring reliability and data integrity.

Client Engagement & Consulting

• Act as a clientfacing consultant, working directly with stakeholders to gather requirements, clarify needs, and translate business questions into technical solutions.
• Demonstrate BAlike capabilities: documenting requirements, proposing approaches, and validating solutions with clients.
• Provide clear communication on data structures, integration logic, and solution outcomes to both technical and nontechnical audiences.

Independent Delivery & Collaboration

• Operate with a high level of autonomy, owning assigned workstreams endtoend.
• Collaborate with U. S.based team members during design reviews, demos, and solution validations.
• Participate in technical demos/interviews as part of solution validation and stakeholder confidence building.

Qualifications

• 4–6 years of experience in data warehousing, data engineering, or data integration roles.
• Handson experience with Civis data platform (strongly preferred).
• Strong proficiency in SQL and database modelling.
• Experience with ETL tools, preferably Informatica.
• Exposure to Azure for data processing, integrations, or connected systems.
• Proven ability to work in clientfacing roles, independently engaging stakeholders.
• Strong analytical, problemsolving, and communication skills.

Preferred Skills

• Prior experience supporting nonprofit or largescale data platforms.
• Familiarity with Redshift or similar cloud data warehouses.
• Experience transitioning into or operating in a consultingstyle delivery model.
• Ability to adapt to new tools quickly and platforms in environments with limited internal expertise.