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 workstreams 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
- 46 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.
