Appian Data Architect

Groundswell; McLean (VA); On-site; USD 117,000 - 209,000; Full time

Benefits offered by this job

Comprehensive benefits

401K Match

Paid Time Off

Tuition reimbursement

Flexible work schedule

On-site gym

Job summary

Groundswell is seeking an experienced Appian Data Architect to design scalable data solutions for a mission-critical federal program. Lead data architecture, modeling, and integrations within Appian, coordinating with solution architects, developers, and client stakeholders to translate complex requirements into effective data solutions.

The role requires 10+ years in related fields, deep SQL/data modeling expertise, and strong communication. Prior federal program experience and U.S.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 10+ years of experience in software development, application/data architecture, or related technical disciplines.
• Significant experience designing data solutions for complex enterprise applications.
• Strong experience with relational databases, SQL, data modeling and performance optimization.
• Experience with Appian or comparable low-code/BPM platforms.

Responsibilities

• Design and maintain scalable data architectures for enterprise applications on Appian.
• Develop conceptual, logical, and physical data models and data structures.
• Design data solutions including Appian data stores, record types, and data synchronization.
• Define data storage, access, integration, and exchange across Appian and external systems.
• Design relational databases and write complex SQL queries for performance.
• Collaborate with architects, developers, and stakeholders to translate requirements.
• Evaluate and improve data structures for scalability, performance, and quality.
• Create data integrations using APIs and web services.
• Establish data governance, security, metadata, and access controls.
• Troubleshoot data/architecture issues and recommend resolutions.
• Participate in design reviews and ensure alignment with standards.
• Mentor development teams and guide Appian data solutions.
• Engage with federal stakeholders to translate requirements into architecture.

Skills

Appian

Data modeling

SQL & DB design

Integrations

Education

Bachelor's degree in CS/IS/Engineering or related

Tools

Appian

Job description

Who Are We?

Groundswell is a premier technology integrator and solution provider, resolutely committed to solving the most complex challenges facing federal agencies today. Our name, Groundswell, represents our commitment to be an unstoppable, seismic change in government. Ours is a small company culture with big company reach and results. Are you ready to be audacious, be bold and drive change at a rapid pace? Join us, where we'll make a greater impact together.

What You'll do:

Groundswell is seeking an experienced Appian Data Architect to support a mission-critical federal program. This role will work as part of a cross-functional technical team to design and implement scalable, secure data solutions supporting enterprise applications built on the Appian platform.

The Data Architect will provide technical leadership across data modeling, application data architecture, database design, integrations, performance, and data governance. The ideal candidate combines deep technical expertise with the ability to collaborate with solution architects, developers, and client stakeholders to translate complex business and technical requirements into effective data solutions.

Responsibilities

• Design and maintain scalable data architectures supporting complex enterprise applications and business processes.
• Develop conceptual, logical, and physical data models, including data structures, relationships, schemas, and standards.
• Design data solutions supporting applications developed on the Appian platform, including Appian data stores, record types, data synchronization, and integration with external data sources.
• Define how application data is stored, accessed, integrated, and exchanged across Appian and external systems of record.
• Design and optimize relational database solutions and complex SQL queries to support application functionality and performance.
• Partner with Appian architects, developers, and integration teams to develop technical designs and resolve complex data and application architecture challenges.
• Evaluate existing data structures and recommend improvements to scalability, performance, maintainability, and data quality.
• Design data integrations using APIs, web services, and other enterprise integration patterns.
• Establish and promote standards for data integrity, security, access controls, metadata, and data governance.
• Troubleshoot complex application, database, integration, and performance issues and provide recommendations for resolution.
• Participate in architecture and technical design reviews and ensure solutions align with program and federal technology standards.
• Provide technical guidance and mentorship to development teams and serve as a subject matter expert for data architecture and Appian-related data solutions.
• Collaborate directly with federal client stakeholders to understand requirements, evaluate technical options, and communicate architecture recommendations.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent relevant experience.
• 10+ years of experience in software development, application architecture, data architecture, database engineering, or a related technical discipline.
• Significant experience designing data solutions for complex enterprise applications.
• Strong experience with relational database technologies, SQL, data modeling, database design, and performance optimization.
• Experience designing integrations between enterprise applications and external data sources using APIs, web services, and other integration technologies.
• Experience with Appian or a comparable enterprise low-code/BPM/case management platform.
• Strong understanding of application architecture and the relationship between application design, data architecture, integrations, and system performance.
• Experience diagnosing and resolving complex technical and performance issues across applications, databases, and integrations.
• Ability to translate business and functional requirements into scalable technical and data architecture solutions.
• Strong communication skills with the ability to work effectively with technical teams, business stakeholders, and senior client leadership.
• Experience providing technical leadership, conducting design reviews, and mentoring developers or engineers.
• Experience supporting federal government programs or other large, complex enterprise environments preferred.
• U.S. Citizenship required. Must be able to obtain and maintain any federal government clearance and/or background investigation required for the assigned client engagement.

Preferred Qualifications

• Deep technical experience with the Appian platform, including application architecture, data architecture, record types, data stores, integrations, and platform performance.
• Experience with Oracle, PostgreSQL, SQL Server, or other enterprise relational database technologies.
• Experience with PL/SQL and complex database development.
• Experience supporting large-scale workflow, case management, or business process management solutions.
• Experience working within DHS or another federal civilian agency environment.
• Appian certifications or equivalent demonstrated Appian platform expertise.

Skills:

Certification:

Why You'll Never Want to Leave:

• Comprehensive medical, dental, and vision plans
• Flexible Spending Account
• 4% 401K Match (immediate vesting)
• Paid Time Off
• Tuition reimbursement, certification programs, and professional development
• Flexible work schedule
• On-site gym and childcare option

The salary range for this role takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to skill sets, experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for any applicable geographic differential associated with the location at which the position may be filled. At Groundswell, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is:

$116,724.00 - $209,019.00

NOTE:

Groundswell does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Groundswell, and Groundswell will not be obligated to pay a placement fee.

Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws.

Read a copy of the Company's Non-Discrimination Policy Statement.

Additional Resources:

• EO 13496 Notification of Employee Rights under NLRA
• Know your rights: Workplace Discrimination is Illegal

Disability Accessibility Accommodation: If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact us [e-mail] or 703-639-1777.