New

Principal Consultant – Data Lead

United States - Remote

Attain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. From strategy to technology and everywhere in between, our experts use their unique skills to advance the important missions of education, nonprofit, healthcare, and state and local government clients.  

People are at the center of all we do, and that’s why we empower career growth, provide industry-leading benefits packages, encourage a flexible work environment, and foster a culture of inclusion to support the needs of our team. We share a collective passion for our mission and our people. Guided by our seven core values, The Attain Way, our vision is the foundation of our culture—to be and attain the best. 

Principal Consultant – Data Lead 

Role Overview 

The Principal Consultant – Data Lead serves as the senior data leader for Higher Education transformation engagements, with a strong requirement for experience with Ascend CRM and Advancement data. 

This role combines Engagement Leadership, hands-on SQL and data development, Data Strategy, Data Governance, and Integration Advisory. The individual must be comfortable leading executive and client conversations while also working directly with technical teams to analyze data, develop SQL, define integration patterns, and drive successful delivery. 

Key Responsibilities 

Engagement & Client Leadership 

  • Serve as the primary data and technical point of contact for client leadership and key stakeholders. 
  • Build trusted client relationships and ensure strong satisfaction, retention, and value realization. 
  • Provide oversight across project scope, schedule, budget, risks, quality, and deliverables. 
  • Lead and mentor consultants, business analysts, developers, and other project team members. 
  • Facilitate executive and working-team discussions, resolve issues proactively, and align delivery with client objectives. 
  • Identify risks, dependencies, and decisions requiring client or project leadership attention. 
  • Translate technical delivery activities into clear business outcomes and executive-level communication. 

Higher Education / Ascend CRM Leadership 

  • Bring strong knowledge of Higher Education Advancement data and CRM processes, preferably with direct Ascend CRM implementation or migration experience. 
  • Understand constituent, household, organization, gift, campaign, fund/designation, prospect, portfolio, and engagement data. 
  • Advise clients on data migration, conversion, reconciliation, integration, and data quality strategies associated with Ascend implementations. 
  • Partner with functional Advancement teams to translate business requirements into data and technical solutions. 
  • Understand the relationships between Advancement CRM, finance, identity, marketing, analytics, and other institutional systems. 

SQL Development & Data Engineering 

The Data Lead must remain technically hands-on and capable of directly supporting development when needed. 

  • Write and troubleshoot complex SQL queries. 
  • Analyze large datasets to identify data quality, transformation, mapping, and reconciliation issues. 
  • Support source-to-target mapping and migration development. 
  • Perform data profiling and assist with cleansing, normalization, deduplication, and transformation rules. 
  • Support developers during complex migration and integration troubleshooting. 

Data Strategy 

  • Serve as a bridge between executive leadership, business stakeholders, functional teams, and technical engineering/analytics teams. 
  • Translate organizational goals and business requirements into actionable data strategies and technical requirements. 
  • Develop current-state and future-state data architectures and roadmaps. 
  • Advise clients on data platforms, integration patterns, analytics architecture, master data, and enterprise data management. 
  • Help clients define how operational, CRM, financial, engagement, and analytical data should work together across the organization. 

Data Governance & Data Quality 

  • Establish and advise on enterprise data governance frameworks. 
  • Define data ownership, stewardship, accountability, and decision-making structures. 
  • Develop data standards, business definitions, and data quality controls. 
  • Establish processes for: 
  • Data quality monitoring 
  • Data remediation 
  • Data ownership 
  • Metadata and definitions 
  • Data lifecycle management 
  • Governance escalation and decision making 
  • Partner with business and technical stakeholders to embed governance into operational processes rather than treating governance as a standalone initiative. 

Integration Advisory 

  • Strategy & Planning: Design integration architectures and blueprints, map end-to-end data flows, define integration patterns, and establish technical requirements across cloud and on-premise environments. 
  • Cross-Functional Collaboration: Partner with business stakeholders, IT teams, application owners, architects, and external vendors to align integration requirements, priorities, dependencies, and business outcomes. 
  • Execution & Delivery Oversight: Provide technical leadership across design, development, testing, deployment, and stabilization while managing risks, dependencies, timelines, and overall solution quality. 
  • Support & Troubleshooting: Analyze integration failures, logs, data issues, and system errors; coordinate root-cause analysis and resolution of production incidents and interface issues. 
  • Integration Advisory: Serve as a subject matter expert on integration architecture, patterns, platforms, and best practices, recommending improvements that increase scalability, reliability, maintainability, and operational efficiency. 
  • Standards & Governance: Establish reusable integration standards, naming conventions, error-handling approaches, monitoring practices, security requirements, and documentation expectations. 
  • Platform Guidance: Advise on the appropriate use of APIs, batch/file processing, ETL/ELT, event-driven architecture, real-time and near-real-time integrations, and middleware/iPaaS platforms. 
  • Provide advisory guidance across platforms such as MuleSoft, Boomi, Informatica, Workato, Azure, AWS, and similar enterprise integration technologies. 

Required Qualifications 

  • Significant consulting experience leading complex enterprise data initiatives. 
  • Experience within Higher Education, preferably Advancement, fundraising, alumni relations, or constituent data. 
  • Experience with Ascend CRM strongly preferred. 
  • Strong hands-on SQL development capabilities. 
  • Experience with data migration, source-to-target mapping, transformation, data quality, integration, and reconciliation. 
  • Demonstrated ability to lead client engagements and communicate effectively with executive stakeholders. 
  • Experience leading cross-functional technical and functional teams. 
  • Strong understanding of enterprise data architecture, data governance, integration architecture, and data management principles. 
  • Experience designing or advising on APIs, ETL/ELT, batch, real-time, and event-driven integration patterns. 
  • Ability to move between executive strategy discussions and detailed technical problem solving. 
  • Excellent written, verbal, presentation, and facilitation skills. 

Ideal Candidate Profile 

The ideal candidate is not purely a project manager, architect, or developer. This person can operate across all three levels: 

Executive: Build trust, communicate strategy, manage risk, and advise leadership. 

Delivery: Own outcomes, coordinate teams, manage scope and priorities, and drive decisions. 

Technical: Get into the data, write SQL, review mappings, design integration approaches, troubleshoot interfaces, and help solve difficult migration and data-quality problems. 

The successful candidate should be viewed by the client as the overall Data Lead and trusted advisor for the engagement, while remaining technical enough to work directly alongside developers, architects, analysts, integration teams, and client data teams. 

Additional Requirements:

  • Demonstrated ability to build trusted advisor relationships with clients
  • Experience supporting sales and business development
  • Position requires flexibility to travel periodically based on business and client needs

 

Additional Information

Attain Partners values your mental, emotional, and physical health and wellbeing. Our comprehensive benefits package starts on your first day of employment and includes benefits such as:

  • Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
  • 11 paid federal holidays and flexible unlimited time off (UTO)
  • Generous 401(k) matching with immediate vesting
  • Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
  • A healthy environment where we value unique experiences, and care about everything that makes you, you.

 

Attain Partners is committed to fair and equitable compensation practices. Individual compensation will be commensurate with experience, education, and skills.

Attain Partners is committed to fair and equitable compensation practices. The individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills. In addition to base salary, this role is eligible for an annual discretionary bonus.

Interested in this position but the compensation isn’t quite right? Let us know your expectations, and we’ll see if we can make it happen based on your qualifications.

Salary Range

$160,000 - $160,000 USD

 

 

Attain Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. 

Applicants have rights under Federal Employment Laws. For more Information visit EEO, EEO Poster Supplement, Family and Medical Leave Act (FMLA), and Employee Polygraph Protection Act (EPPA). 

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. 

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Attain Partners’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 07/31/2029

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.