Senior Data Solutions Consultant

Reports to: Senior Manager, Professional Services

To apply, please send a cover letter and resume to jobs@jcainc.com. Applications without cover letters will not be considered. No phone calls or messages please. Applications are due by 11:59 p.m. PST on April 30, 2025.

Summary

As a Senior Data Solutions Consultant, you design, implement, and optimize data infrastructure and solutions that empower our nonprofit clients. Collaborating with the JCA Professional Services team of consultants, you translate client needs into impactful data strategies, driving positive change. Your expertise across the full data lifecycle—from extraction and cleansing to integration and data pipeline construction—is essential. This role offers a unique opportunity to shape our service offerings and contribute directly to our continued growth.

Responsibilities

Data Engineering and Design

• Extract data from diverse sources, including databases and APIs, ensuring timely and accurate data retrieval.
• Lead efforts to cleanse, validate, and transform data, maintaining high standards of data quality and consistency.
• Design and build robust data pipelines to automate data ingestion, transformation, and loading processes, ensuring efficiency and reliability.
• Integrate data from multiple sources into a unified data platform, enabling comprehensive data analysis and reporting.
• Design and support the implementation of scalable data storage solutions, such as data warehouses and data lakes, to support business needs.
• Optimize data storage and retrieval processes to enhance performance and scalability.
• Ensure all work and client solutions conform to data security and relevant compliance standards, protecting sensitive information.
• Maintain thorough documentation of data processes, pipelines, and architectures.
• Provide technical guidance and support to clients and internal teams, assisting with project planning, implementation, troubleshooting, and best practices.

Consulting

• Deliver high-quality consulting services to nonprofit clients, addressing their unique needs and challenges.
• Understand, explore, use, make decisions with, and communicate using data.
• Collaborate with clients to understand their unique requirements and develop tailored solutions to effectively align technology and data with strategy.
• Provide clear and actionable recommendations to the client, supported by detailed documentation and analysis.
• Expand consulting expertise through continuous learning and development to enhance JCA’s offerings and contribute to a diverse range of projects.
• Collaborate with colleagues to share knowledge and contribute to the development of internal resources, thought leadership, and new offerings.

Client Relationship Management

• Establish and maintain strong relationships with prospects and clients to enhance the organization’s reputation and influence.
• Identify opportunities for new and expanded projects.

Skills

You are successful as the Senior Data Solutions Consultant because you:

• have strong SQL programming skills and experience with database design and optimization;
• are able to extract data from diverse sources, including relational databases (e.g. SQL Server, MySQL), cloud-based data storage (e.g. Snowflake, AWS, Microsoft Fabric), APIs (e.g. REST, SOAP), and various file formats (e.g. JSON, XML, CSV);
• have knowledge of current trends and best practices in data solutions, including emerging technologies and methodologies;
• demonstrate the ability to adapt to changing priorities and learn new technologies quickly and effectively;
• have experience working with or within nonprofit organizations, understanding their unique challenges and opportunities;
• contribute to project planning, including defining scope, estimates, timelines, and deliverables;
• communicate technical concepts effectively to non-technical audiences through excellent written and verbal communication skills;
• work effectively in a collaborative team environment, contributing positively to group dynamics and shared goals;
• are highly organized and manage your time well, prioritizing tasks, managing multiple projects simultaneously, and consistently meeting deadlines; and
• are proactive and self-motivated, taking initiative and working independently with minimal supervision.

Qualifications

You are qualified for the position because you:

• have a minimum of three years’ experience as a computer science, data, or technical engineer or equivalent with demonstrable experience in SQL programming, software development, ETL processes, and nonprofit CRM data structures.

You have an advantage in the position if you:

• have experience working with Blackbaud CRM or The Raiser’s Edge, Kindsight ascend, Salesforce NPC or NPSP, or Tessitura data structures; and
• have one or more Microsoft Certifications specific to Azure or Power Platform.

Requirements

You may be required to:

• work remotely from a home office or other remote space;
• work 40 hours per week, as this is a full-time position;
• travel up to three times per year; and/or
• remain in a stationary position for the majority of an eight-hour workday.

You are required to:

• adhere to the company’s policies and procedures; and
• embrace JCA’s core values.

Benefits

• Salary range of $87,550 to $103,000, commensurate with experience and performance
• Paid holidays, vacation, personal, sick, and volunteer time\
• 401(k) retirement plan
• Employee Stock Ownership Plan (ESOP)
• Health, dental, and vision insurance
• Life insurance and long-term disability insurance
• Paid parental leave
• Employee Assistance Program
• Flexible Spending Account (FSA)
• Dependent Care Account (DCA)

About JCA

JCA is a leading consultant to nonprofit organizations in performing arts, healthcare, higher education, and museums and attractions. Since 1988, we have helped thousands of nonprofits in North America and around the world apply data and platforms to advance their missions and optimize their operations. We are known for helping clients take great leaps forward by helping them understand, organize, and apply their rich data to accelerate their missions.

We contribute to our clients’ success each day by embracing these core values:

• We act with integrity.
• We hold ourselves personally accountable for our work.
• We are honest, no matter what.
• We are fair and respectful to our clients and to each other.
• Excellence drives us.

JCA is a distributed company headquartered in New York City. The majority of our team works from home offices located across the United States and Canada. We collaborate with, and contribute to the success of, multiple internal teams, all to better serve our clients.

Equal Employment Opportunity

JCA provides equal employment opportunities in all employment-related matters, including hiring, training, promotion, compensation, benefits, transfers and other personnel actions. JCA prohibits discrimination and harassment of any type based on the following protected characteristics: race, creed, citizenship, religion, color, sex, gender identity, gender expression, national origin, age, disability, marital status, domestic partner status, veteran or military status, sexual orientation, medical condition, ancestry, pregnancy, childbirth, or related medical conditions, AIDS/HIV status, uniformed services status, genetic information, height, weight or any other characteristic protected by federal, state or local law.

JCA supports and encourages open communication to address each employee’s concerns and expectations. We strive to create a safe and healthy work environment where all employees can be their whole selves and recognize the need for constructive and timely feedback. JCA provides reasonable accommodation for religious beliefs or practices and persons with disabilities.