Civis Consultant

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 Redshift-based architecture.
Perform  SQL-based 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  Azure-based 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  client-facing consultant , working directly with stakeholders to gather requirements, clarify needs, and translate business questions into technical solutions.
Demonstrate  BA-like 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 non-technical audiences.
Independent Delivery & Collaboration
Operate with a high level of autonomy, owning assigned work streams end-to-end.
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.
Hands-on 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  client-facing roles , independently engaging stakeholders.
Strong analytical, problem-solving, and communication skills.
Preferred Skills
Prior experience supporting  nonprofit or large-scale data platforms .
Familiarity with  Redshift  or similar cloud data warehouses.
Experience transitioning into or operating in a  consulting-style delivery model .
Ability to adapt to new tools quickly and platforms in environments with limited internal expertise.